Add a label in SSRS report for a text.

(0) Share

Report

Posted on by Daljit Kaur Rahsi

1,260

Hi,

I want to have the following sentence "We want you to love your purchase" to get translated in French when the report is running in French version. To show "Nous voulons vous faire aimer votre achat"

Whereas if the report is running in English show the English version.

Will I have to create a label or how am I suppose to do this?

*This post is locked for comments

I have the same question (0)

All responses (11)

Answers (0)

Suggested answer

Martin Dráb 238,149 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Yes, label is the right way. That's exactly what allow field titles to change if you switch report language.

Was this reply helpful? Yes No
Daljit Kaur Rahsi 1,260 on at

Like (0)

Report
Copy link

Link copied!

Martin,

How will I get the label for this one? Placeholders?

Was this reply helpful? Yes No
Mea_ 60,286 on at

Like (0)

Report
Copy link

Link copied!

Hi D_Meethu R,

You already asked the same question community.dynamics.com/.../210492

Was this reply helpful? Yes No
Suggested answer

Martin Dráb 238,149 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

You have to create a label in Dynamics AX. Do you know what AX labels are and how to use them?

Then refer to the label in your report using an expression, e.g. =Labels!@ABC12345. Just look at any existing report to see a plenty of examples.

Was this reply helpful? Yes No
Daljit Kaur Rahsi 1,260 on at

Like (0)

Report
Copy link

Link copied!

Ievgen,

I got for the text labels you have the labels available in the ssrs report as per the document.

Just not understanding how to do for a sentence. Created the label in the placeholder but it is not getting converted to French.

Was this reply helpful? Yes No
XB 1,875 on at

Like (0)

Report
Copy link

Link copied!

are your report in french language?Did you set on placeholder a label?

technet.microsoft.com/.../gg724077.aspx

Was this reply helpful? Yes No
Daljit Kaur Rahsi 1,260 on at

Like (0)

Report
Copy link

Link copied!

Javier,

I have a text in English "We want you to love your purchase" and I want to show in French statement.

So I used a placeholder as the below image, but still I am not getting the converted French language. Am I missing something?

Was this reply helpful? Yes No
Martin Dráb 238,149 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Your picture shows a hard-coded English text; there is no magic that would translate it for you.

You have to create a label in AX, provide the translation there and refer to the label ID in your report. I already gave you an example above (=Labels!@ABC12345).

Do you understand the concept of labels in Dynamics AX?

Was this reply helpful? Yes No
Martin Dráb 238,149 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

I see that you're trying to use AX label ID in SSRS label property, but that's not correct. You must use the expression such as =Labels!@ABC12345 as the value.

Open any report in AX to see a plenty of examples.

Was this reply helpful? Yes No
Daljit Kaur Rahsi 1,260 on at

Like (0)

Report
Copy link

Link copied!

Martin,

For the existing labels from AX example, item id, product name I am taking the labels from AX itself and using the example as you mentioned i.e. =Labels!@ABC1234

All I am not understanding is the steps for placeholder for the custom statement that I am looking for.

English words like Thank you, how to add a label for it and show in the report? like Placeholder but how?

Was this reply helpful? Yes No