Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

What is an easy way to Localize a SQL Server Reporting Services report (.rdl)?

I am trying to provide a Spanish and English version of the reports that I am currently building in SQL Server Reporting Services. Is there an easy way to localize the report (similar to using Resource files for labels in a .NET web application)?

like image 484
Jon Erickson Avatar asked Mar 04 '09 18:03

Jon Erickson


People also ask

How do I find the SSRS report in SQL Server?

The easiest way to select and run a report is to open the web portal and then search for or browse to the report that you want to view. After you run a report, you can refresh it to see new data.

Where can I find SQL Server Reporting Services instance?

From SharePoint central administration, click Manage services on server in the System Settings group. Verify the SQL Server Reporting Services Service is installed and in the Running state. If you do not see the Reporting Services service in the list, verify the service is installed.

Where are the RDL files stored in Reporting Services?

rdl files are stored in the Content column of ReportServer. dbo. Catalog.


1 Answers

It's all just .Net code so you could access standard resource file via some helper methods in a custom assembly, but this gets hard to test etc

An example of this is here http://forums.asp.net/p/952617/1171729.aspx

Sometimes a simpler soulution is to have a language table in your database and have all lables use a filter on it by label name and the User!Langauge parameter

like image 147
user73993 Avatar answered Sep 23 '22 06:09

user73993