How to display company name, Page number and current (print) date & time in SSRS header.
expression for Company name:
=Microsoft.Dynamics.Framework.Reports.DataMethodUtility.GetFullCompanyNameForUser(Parameters!AX_CompanyName.Value,
Parameters!AX_UserContext.Value)
Expression for page number
=System.String.Format(Labels!@SYS182565,
Globals!PageNumber & space(2) & Labels!@sys26401 & space(2) &
Globals!TotalPages)
Expression for Print date & time.
=Microsoft.Dynamics.Framework.Reports.DataMethodUtility.ConvertUtcToAxUserTimeZoneForUser(Parameters!AX_CompanyName.Value,
Paraemeters!AX_UserContext.Value, System.DateTime.UtcNow, "d", Parameters!AX_RenderingCulture.Value) & vbCrLf &
Microsoft.Dynamics.Framework.Reports.DataMethodUtility.ConvertUtcToAxUserTimeZoneForUser(Parameters!AX_CompanyName.Value,
Parameters!AX_UserContext.Value, System.DateTime.UtcNow, "t", Parameters!AX_RenderingCulture.Value)
Happy DAXing....
No comments:
Post a Comment