Multi language represent in SSRS 2008 r2

Question

Hi All,

I have a client requirement to show the reports in multiple languages. In database the data will stored in English language but when crate the reports i want to give a parameter for selection of language. For example i have to show the report in below languages

1. English

2. Spanish

3. Slovania

4. French

I need to pass the above four languages as a parameter. When the end user select the Spanish language the data will show in Spanish language.

data is same for all languages.

Thanks in Advance,

Madhava Ganji

Answer 1

Hi,

if data is same for all 4 languages and you need to play only with labels, then you can switch labels based on selected language in your parameter. For this you can use function SWITCH, example:

=SWITCH(Parameter!ReportLanguage.Value = 1, "English Word", Parameter!ReportLanguage.Value = 2, "Spanish Word",.....)

Or you can put more tables and elements which are needed for report to be displayed on same report and play with hide and show option, again with switch expression.

But if only labels need to be adjusted first option will be better, report performance will be better. 

Regards

Answer 2

Hi Ursa,

Thanks for your quick response. Could you please provide any examples..Data is different for country.

Apologies for the bad post.

Thanks,

Madhava

Answer 3

Uf,

what means data is different?

Do you have 4 different datasets or all data is catch in one dataset and data is divided only with additional attribute (let say Country)?

I currently don't have any such report that I could provide you as an example.

If you have 4 different datasets then you can put many tables on report and you can assign each table to one of the datasets. Then you can use visibility property of table and set it to be visible or not based on the selected parameter (you do that with switch expression).

Regards

Answer 4

Hello - I have a similar need where I need to change the currency field for the data. For example, my default is English (US) so we show $ signs but we have projects in South Africa and China and they have different currency symbols. Any suggestions on how to address this? I've currently been dealing with this by creating separate reports and it's not very practical.

---

Chris

Answer 5

Hi Cris,

if you click on textbox that has this data inside, go to >Textbox Properties >Number >Custom, there you can put custom format for individual language. Expression to use is Switch as my above post suggest.

You can use something like =SWITCH(Parameters!Country.Value=1, "0.00'€'", Parameters!Country.Value=2, "0.00'yuan'")

I used euro char and word yuan, you can take the correct  symbol from windows charmap.

Regards

Answer 6

Hi Ursa,

Below my requirement.

Name             Id
Adams          100
Brain            102

This data i want to display in Multiple languages..So i need to pass a parameter to represent the entire data as user select language

Am i making sense...

Thanks in Advance,
Madhava

Answer 7

Not sure,

if data is pulled from database I assume your dataset is returning:

Adams 100

Brain 102

and this data is the same for all languages, right?

And you need just different display labels? By this I mean Name and Id?

If this is a case then you change Labels with switch function in textbox in table. By this, I mean you put table on report and you put expression in each individual textbox in table header, and in details you drag data that you are getting in your dataset.

Expression for table header:

=SWITCH(Parameter!ReportLanguage.Value = 1, "English Word", Parameter!ReportLanguage.Value = 2, "Spanish Word",.....)

Answer 8

Hi Ursa,

You are thinking is correct..Thanks for your answers and for patience. I will try and will get back to you..

How can we achieve Localization for below requirement. I have two columns and my data set look likes below.

Question                                       Rating

1. Is this site is useful                    2 

2. How is my services                     5

Let me explain the above scenario briefly.

I have a report in that report i need to show 20 questions along with 20 questions i need to show the rating..So here Question are same for all countries but i need to show the questions as per their languages..

For Example If the user is coming from India the report should be in English-India and the user is coming from French the Questions should be in French...

Please let me know if i am not making sense..

Thanks,

Madhava

Answer 9

Hi,

if questions are queried from database, data is always in same language, in language that is entered in database.

SSRS is only reporting feature and cannot change data to other language. This tool is just for representing data, from database in different ways.

If this are labels, the way is the same:

=SWITCH(Parameter!ReportLanguage.Value = 1, "Is this site is useful", Parameter!ReportLanguage.Value = 2, "Is this site is useful  in French language",.....).

From above post, it seems to me you are not querying the data, just designing report with static labels (questions?). So make static table with no details, or use textbox and use switch function. Even if you have question in database (and they are in English language), it will be easier for you to put it as a static text, and switch text based on parameter selection.

Check this SSRS tutorials, they make helpful contribute of capabilities: http://msdn.microsoft.com/en-us/library/ms170246%28v=sql.90%29.aspx

Regards,