SSRS Reports Expressions in D365fo x++

SSRS Reports Expressions in D365fo x++

 Get Company name

=Microsoft.Dynamics.Framework.Reports.DataMethodUtility.
GetFullCompanyNameForUser(Parameters!AX_CompanyName.Value,Parameters!AX_UserContext.Value)

 Hide Colum on report On condition

IIf(Sum(Fields!Returnable.Value, "Header") = 0,True, False)

 Hide Tablix on report On condition:

=IIF(Parameters!POInvoiceTmp_InvoicedUnInvoiced.Value = "Invoiced" , True, False)

Rows Color expression:

=iif(RowNumber(Nothing) Mod 2, "#ffffff", "#f0f0f0")

Show All selected values of lookup :

Expression: 

=join(Parameters!GDWiseIssuanceTmp_ClassType.Value, ",")