web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Blogs / DAXology (Study about Dynamics AX and Dynamics ... / Display datetime, company i...

Display datetime, company information and page number on SSRS report in D365FO

Views (519)
Chaitanya Golla Profile Picture Chaitanya Golla 17,225

Hi,

Please refer to my earlier post to view the report SSRSPrecisionDesign related classes, tables and menuItem.

https://community.dynamics.com/365/financeandoperations/b/daxology/posts/creating-a-simple-report-in-d365fo

In this post, we will try to add the page number, company information and datetime stamp to know when the report was generated.

Step 1: Added a text box just beneath the report title and added the expression to display the company name.

Expression: =Microsoft.Dynamics.Framework.Reports.DataMethodUtility.GetFullCompanyNameForUser(Parameters!AX_CompanyName.Value, Parameters!AX_UserContext.Value)

Step 2: Added a text box to the extreme right that aligns with the report title and added the expression to display the text as "Page <currentPageNumber> of <TotalPages>"

Expression: =System.String.Format(Labels!@SYS179442, "" & Globals!PageNumber & " of " & Globals!TotalPages & "")

Step 3: Added a text box to the extreme right that aligns with the company name and added the expression to display the datetime stamp.

Expression: =Microsoft.Dynamics.Framework.Reports.DataMethodUtility.ConvertUtcToAxUserTimeZoneForUser(Parameters!AX_CompanyName.Value, Parameters!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)

Step 4: Deployed the report and generated it to see the values displayed on the report.

Regards,

Chaitanya Golla

Comments

*This post is locked for comments