How to get full AX company in SSRS report
=Microsoft.Dynamics.Framework.Reports.DataMethodUtility.GetFullCompanyNameForUser(Parameters!AX_CompanyName.Value,
Parameters!AX_UserContext.Value)
Parameters!AX_UserContext.Value)
How to show alternate row colour in SSRS report
Set following expression to row’s background property
=IIf(RowNumber(Nothing) Mod 2 = 0, “LightGrey”,
“WhiteSmoke”)
“WhiteSmoke”)
How to format a date
=format(Parameters!Dataset1_AsPerDate.Value,“dd/MM/yyyy”)
How to show date and time on report
=Microsoft.Dynamics.Framework.Reports.DataMethodUtility.ConvertUtcToAxUserTimeZoneForUser(Parameters!AX_CompanyName.Value,
Parameters!AX_UserContext.Value, System.DateTime.UtcNow, “d”,
Parameters!AX_RenderingCulture.Value) & ”
at “ & Microsoft.Dynamics.Framework.Reports.DataMethodUtility.ConvertUtcToAxUserTimeZoneForUser(Parameters!AX_CompanyName.Value,
Parameters!AX_UserContext.Value, System.DateTime.UtcNow, “t”,
Parameters!AX_RenderingCulture.Value)
OutPut: 01/01/2015 at 8:14 AM
Page 1 of 2
Parameters!AX_UserContext.Value, System.DateTime.UtcNow, “d”,
Parameters!AX_RenderingCulture.Value) & ”
at “ & Microsoft.Dynamics.Framework.Reports.DataMethodUtility.ConvertUtcToAxUserTimeZoneForUser(Parameters!AX_CompanyName.Value,
Parameters!AX_UserContext.Value, System.DateTime.UtcNow, “t”,
Parameters!AX_RenderingCulture.Value)
OutPut: 01/01/2015 at 8:14 AM
Page 1 of 2
How to show page number on report
=System.String.Format(Labels!@SYS182565,
Globals!PageNumber & space(2) & Labels!@sys26401 & space(2) &
Globals!TotalPages)
How to get last date of
the month
the month
Format(DateSerial(Year(Parameters!Dataset1_AsPerDate.Value),
Month(Parameters!Dataset1_AsPerDate.Value), “1”).AddMonths(1).AddDays(-1),“dd/MM/yyyy”)
Input: Parameters!Dataset1_AsPerDate.Value = “02/01/2015”
Outout: 31/01/2015
How
to get Month’s name and Year from date
Month(Parameters!Dataset1_AsPerDate.Value), “1”).AddMonths(1).AddDays(-1),“dd/MM/yyyy”)
Input: Parameters!Dataset1_AsPerDate.Value = “02/01/2015”
Outout: 31/01/2015
How
to get Month’s name and Year from date
cstr(MonthName(month(Parameters!Dataset1_AsPerDate.Value)))
+ ” – “ +
cstr(Year(Parameters!Dataset1_AsPerDate.Value))
+ ” – “ +
cstr(Year(Parameters!Dataset1_AsPerDate.Value))
