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"))

How to Create VM in Azure portal & Configure D365 in VM

Follow the Link

Create VM in Azure portal

https://buildazure.com/2017/03/07/visual-studio-2017-development-using-a-vm-in-azure/


Configure D365 FO in VM

https://www.linkedin.com/pulse/setup-dynamics-365-operations-virtual-machine-rajesh-mallempati/


To extend License for VM - 180 days

https://community.dynamics.com/ax/b/newdynamicsax/archive/2017/08/24/windows-evaluation-license-expiring-on-local-development-vms