CODEWITHSUNDEEP
ssrs-2008axaptassrs-2012microsoft-dynamicsx++
JamesnxD
JamesnxD

Reputation: 163

Display company currency in dynamics AX SSRS report

I have to add the company(master) currency to several existing report and i don't get it.

For example for the SSRS report: "LedgerTrialBalance" (General Ledger/ Transactions/ Summary trial balance)

I only want to display the CurrencyCode in the attached screenshot in a textbox of the above mentioned report.

With company currency i mean this:

Have anybody some ideas?

Upvotes: 0

Views: 813

Answers (1)

FH-Inway
FH-Inway

Reputation: 5107

The data sources of the LedgerTrialBalance report do not contain a field with the company currency code. You would therefore have to modify the report to include such a field. A detailed instruction on how to do that is not a good fit for the Q&A Format of stack overflow, but the high level steps would be:

  • identify the data sources of the report
  • add a new field to the appropriate data source
  • add code to fill the new field with data
  • add the new field to the report design

Since you mentioned in the comments that you have only experience with changing report designs I would recommend to get some training in this area and in AX development in general. A particular useful exercise would be to build a complete new report from scratch, this way you could learn about the anatomy of a report.

Upvotes: 2

Related Questions