Show Print Date & Time and Page Number in SSRS report - Custom formatted

Views (5421)

Faisal Fareed

10,796 User Group Leader

Like(0)

Report

Following expression can be used to show print date and time in SSRS 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

Following expression can be used to show page number in SSRS report.

=System.String.Format(Labels!@SYS182565, Globals!PageNumber & space(2) & Labels!@sys26401 & space(2) & Globals!TotalPages)

OutPut: Page 1 of 2

This was originally posted here.