web
You’re offline. This is a read only version of the page.
close
Skip to main content
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Use 2 different langua...
Microsoft Dynamics AX (Archived)

Use 2 different languages in SSRS Reports.

(0) ShareShare
ReportReport
Posted on by Manmohan 140

Hi guys

My client wants all its SSRS reports to be printed in 2 different languages.According to my regional settings,I Am working EN-us but along with that the report should be printed in 2 languages i.e EN-us & other.

Can you help how can i achieve it??

*This post is locked for comments

I have the same question (0)
  • Martin Dráb Profile Picture
    Martin Dráb 235,914 Most Valuable Professional on at
    RE: Use 2 different languages in SSRS Reports.

    Don't forget that you can use all standard reports as examples.

  • Suggested answer
    Martin Dráb Profile Picture
    Martin Dráb 235,914 Most Valuable Professional on at
    RE: Use 2 different languages in SSRS Reports.

    The FORMAT function is used for converting values (such as numbers and dates) to formatted strings. =Format("Item Number") doesn't do anything useful - you should rather tell us what you're trying to achieve by that.

    If your intention is to use labels, the correct syntax is =Labels!@XYZ12345. Nevertheless you should seldom write it manually; it's usually taken from fields and their EDTs.

  • Daljit Kaur Rahsi Profile Picture
    Daljit Kaur Rahsi 1,260 on at
    RE: Use 2 different languages in SSRS Reports.

    The report was designed previously by other developer,I was asked to change into another language.

    One more quick question,

    If I have a hard coded text as Item Number, can I convert into expression as "=Format("Item Number")" will this work for both the languages?

    Or how can I create the text into labels within report itself?

  • Martin Dráb Profile Picture
    Martin Dráb 235,914 Most Valuable Professional on at
    RE: Use 2 different languages in SSRS Reports.

    If somebody made a mistake when developing the report and didn't use labels, you'll have to fix now. Copying the report and changing hard-coded texts to other hard-coded texts would be more work and you would end up with two reports to maintain (and without labels), which would increase maintenance costs.

    Regarding parmLanguage(), I provided an example in the duplicate thread. If you're not familiar with basic concepts such as controller classes, I suggest you consult AX documentation. You can also look at blogs, older discussion threads and so on, and obtain a book about AX reporting.

  • Daljit Kaur Rahsi Profile Picture
    Daljit Kaur Rahsi 1,260 on at
    RE: Use 2 different languages in SSRS Reports.

    Martin,

    I don't have labels when the English version of the report when it was created. Now there is a requirement of having the same report called and running in French version.

    When you saying call the report twice in different language via parmLanguageId(), how can I achieve that?

    Sorry I am new to AX, but with your expertise I can overcome this. Thanks again.

  • Martin Dráb Profile Picture
    Martin Dráb 235,914 Most Valuable Professional on at
    RE: Use 2 different languages in SSRS Reports.

    You don't have to design to reports just to change labels. Design a single report and call it twice with different language (parmLanguageId()).

    Does "The report does not support French version in terms of data" mean that the data in database that you show in the report is in English? If so, what do you expect to happen? Reports can only show existing data, so either you'll show English data regardless the language of labels, or you have to provide data translated to French. AX supports language versions out of the box in a few cases, such as item names.

  • Daljit Kaur Rahsi Profile Picture
    Daljit Kaur Rahsi 1,260 on at
    RE: Use 2 different languages in SSRS Reports.

    Nitesh,

    For the other approach you mentioned that design the two report in two different language in my case English and French.

    But when I will run the report how it will show?

    As in, if I create a retail transaction report one in English and the other in French. Once I create the menu items for that particular report, how am I going to call both the reports from it.

    As French version is only probably for Quebec and maybe in one or another part and English else where/

  • Daljit Kaur Rahsi Profile Picture
    Daljit Kaur Rahsi 1,260 on at
    RE: Use 2 different languages in SSRS Reports.

    Hi Nitesh,

    I am just popping up in the loop, as I am facing the same scenario. I need to create two reports one in English version and the other in French. The report does not support French version in terms of data for the report.

    Is there any way to do so?

  • Martin Dráb Profile Picture
    Martin Dráb 235,914 Most Valuable Professional on at
    RE: Use 2 different languages in SSRS Reports.

    My answers are in the duplicate thread on another forum.

  • Suggested answer
    A.Prasanna Profile Picture
    A.Prasanna 8,221 on at
    RE: Use 2 different languages in SSRS Reports.

    Hi Manoj,

    Are you referring to SSRS reports in Enterprise Portal  or AX Client?

    If it is run on client you can attached SSRS report in other language , which already have on reports library.by default there are reports in many languages. It's seems to it's  bit harder If reports is on Enterprise Portal .

    Thanks & Regards,

    Amith Prasanna.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Dynamics 365 Community Calls Return
Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft
Responsible AI policies for the Community

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Andrés Arias – Community Spotlight

We are honored to recognize Andrés Arias as our Community Spotlight honoree for…

Congratulations to the August Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Syed Haris Shah Profile Picture

Syed Haris Shah 9

#2
Mea_ Profile Picture

Mea_ 4

#3
Martin Dráb Profile Picture

Martin Dráb 2 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans