Report Localization Help
I have the following requirement
There may be some employees in German that have English operating system but they still may want the report in German. So no matter what the OS, the report needs to
generate in German. So i went into Report properties then localization and selected de-DE as German. I deployed the report in Report manager but i still see it in English. I am aware that the data in my report would be the language of database..
Can someone help me ?FM
July 6th, 2011 10:03am
I have a requirement , There may be some employees in German that have English operating system but they still may want the report in German. So no matter what the
OS, the report needs to generate in German.
So i went into report properties and under localization i select de-DE as my language.. But i still see the textboxes in English.. Can someone help me ?FM
Free Windows Admin Tool Kit Click here and download it now
July 6th, 2011 5:13pm
Try to add this tag to the top of the report (open the report definition in notepad)
<Language>de-DE</Language>
and let me know if it works for you
This posting is provided "AS IS" with no warranties, and confers no rights
July 6th, 2011 6:40pm
okay so i opened the rdl file in notepad and this is what i did
<Language>de-DE</Language>
<?xml version="1.0" encoding="utf-8"?>
<Report xmlns="http://schemas.microsoft.com/sqlserver/reporting/2008/01/reportdefinition" xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">
<Body>
<ReportItems>
<Tablix Name="Tablix1">
<TablixBody>
<TablixColumns>
<TablixColumn>
<Width>6.75125in</Width>
</TablixColumn>
</TablixColumns>
<TablixRows>
<TablixRow>
<Height>3.24607in</Height>
<TablixCells>
<TablixCell>
<CellContents>
<Rectangle Name="Rectangle4">
<ReportItems>
<Textbox Name="Textbox109">
So save the rdl file in note pad?FM
Free Windows Admin Tool Kit Click here and download it now
July 6th, 2011 7:09pm
Hi Farhan1,
Normally, report data is retrieved from the data source and placed into the layout you define. That is to say, if
source data in your database is English data, then no matter what the version (such as French version, Japanese version) of your Report Manager/operating system is, the report will still contain English content.
The Report property
Language is used to set the language on a report to show the formatted values (such as dates, currency, and numbers) of a specific language. So, to show the report in German, we might need to create another report with German content manually.
For more information about Localizing Reports, please refer:
http://msdn.microsoft.com/en-us/library/aa178910(v=sql.80).aspx.
Thanks,
Lola Wang
Please remember to mark the replies as answers if they help.
July 8th, 2011 5:15am
Hi Farhan1,
Normally, report data is retrieved from the data source and placed into the layout you define. That is to say, if
source data in your database is English data, then no matter what the version (such as French version, Japanese version) of your Report Manager/operating system is, the report will still contain English content.
The Report property
Language is used to set the language on a report to show the formatted values (such as dates, currency, and numbers) of a specific language. So, to show the report in German, we might need to create another report with German content manually.
For more information about Localizing Reports, please refer:
http://msdn.microsoft.com/en-us/library/aa178910(v=sql.80).aspx.
Thanks,
Lola Wang
Please remember to mark the replies as answers if they help.
Free Windows Admin Tool Kit Click here and download it now
July 8th, 2011 12:16pm
Hi Lola,
Totally understand this part
Normally, report data is retrieved from the data source and placed into the layout you define. That is to say, if
source data in your database is English data, then no matter what the version (such as French version, Japanese version) of your Report Manager/operating system is, the report will still contain English content.
However what i wanted to know was we have offices in Germany and they would like to see the reports that i am working in German
( such as dates, currency, and numbers) and Textbox labels as well. Where it gets tricky is we also have some german users in US would like to see the report in german format.. When you say Manually are suggesting i create a Linked report?????FM
July 8th, 2011 5:33pm
Hi
Farhan1,
To create another report manually as I suggested in my first reply, I mean to create a totally new report for
German. We can add a link to drillthrough to another report by the steps below:
On the German version report, drag a textbox to proper position, and input English in the textbox.
Right-click the textbox, click Text Box Properties. In Action category, select Go to report, and choose the
English version report from the list.
Do the similar action on English version report, to drillthrough to the German version report.
Thanks,
Lola Wang
Please remember to mark the replies as answers if they help.
Free Windows Admin Tool Kit Click here and download it now
July 11th, 2011 4:48am