Microsoft Dynamics 365 | Integration, Dataverse...

Dynamic language of SSRS Report

(0) Share

Report

Posted on by Andrei U

Hello,

I have a form-like report in German and I need to translate it in French and Italian. But the language of the report should be dynamically chosen, based on the account language of the user that runs the report. The issue is that almost all elements(row headers, column headers, text boxes with terms and conditions etc.) that needs to be translated are hardcoded now.

I've come up with a solution, using SQL - I can create a procedure that takes the account language of the user and based on this, using CASEs, it will populate the elements with the right language, but as there are a lot of fields, this seems like a lot of work.

I'm looking for smarter ways to achieve this behavior. Any ideas?

Thank you!

All responses (2)

Answers (0)

Andrei U 20 on at

Like (0)

Report

RE: Dynamic language of SSRS Report

Hello,

I only need to translate the headers/labels. The data is static regarding the language.
Suggested answer

Wahaj Rashid 11,319 on at

Like (0)

Report

RE: Dynamic language of SSRS Report

Hi,

Thank you for your query.

Do you need to translate the headers/labels only? Or data also changes depending on the language?

If you have installed/configured multiple languages in Dynamics 365, you can create separate reports per language.

I understand, it is not optimal in your case, however this is another approach to look at:

Categorize and display reports in different languages (Dynamics 365 Customer Engagement (on-premises)) | Microsoft Docs