SSRS useful expression

Page 1 of 1

="Page " & Globals!PageNumber & " of " & Globals!TotalPages

Report header need to change based on report parameters


RowNumber() -- > to count no of rows in grid

Combating Blank Page in SSRS Reports – Dynamics AX 2012 (NEC Multiple pages fix solution)
https://community.dynamics.com/ax/b/axcasperkamals/archive/2013/11/07/ssrs-tips-combating-blank-page-in-ssrs-reports-dynamics-ax-2012

IF conditions

=IIF(Parameters!PurchaseReportDS_Include_Delivered.Value = true AND
Parameters!PurchaseReportDS_Include_Returns.Value = false AND
Parameters!PurchaseReportDS_Include_Invoiced.Value = false, "GOODS RECEIPT NOTE","PURCHASE REGISTER")

Multiple If Conditions

=IIF(Parameters!PurchaseReportDS_Include_Delivered.Value = true AND
        Parameters!PurchaseReportDS_Include_Returns.Value = false AND
Parameters!PurchaseReportDS_Include_Invoiced.Value = false, "GOODS RECEIPT NOTE",
IIF(Parameters!PurchaseReportDS_Include_Delivered.Value = false AND
Parameters!PurchaseReportDS_Include_Returns.Value = true AND
Parameters!PurchaseReportDS_Include_Invoiced.Value = false, "PURCHASE RETURN NOTE", "PURCHASE REGISTER"))