User label localization SSRS 2008
In my reporting services' report I want to use localized data. The localized data is specified into a Resource.resx. I want to LET THE USER modify this resources.resx upon his needs. How can I solve this?
May 21st, 2010 10:32am
Hi Montanari,
In Reporting Services, we can use custom code to retrieve the localized values.
Below is great sample about this subject, I would suggest you reading this article:
http://www.codeproject.com/KB/reporting-services/SSRSReportLocalized.aspx
Also, to add and edit resources in resource file, please see:
http://msdn.microsoft.com/en-us/library/7k989cfy(VS.80).aspx
Alternative, I would suggest you saving the localized values in a database, implementing a custom application for the end-users to input the localized values, and then using the custom code(or custom assembly) to retrieve the localized value.
Using a user's application is more meanful than using Visual Studio to modify resources in resource file directly.
If you have any more questions, please feel free to ask.
Thanks,
Jin ChenJin Chen - MSFT
Free Windows Admin Tool Kit Click here and download it now
May 24th, 2010 12:32pm
I used the following tutorial:
http://www.codeproject.com/KB/reporting-services/SSRSReportLocalized.aspx for localization with the SSRS Reports that I am currently working on.
At the end of the tutorial, it states to copy the assembly file to the following two locations:
Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies
&
Program Files\Microsoft SQL Server\MSSQL.3\Reporting
I am using Visual Studio 2008 & Microsoft SQL Server 2008, and there is no MSSQL.3 folder on my Windows XP machine. Where is the alternative location where I can copy the assembly file that I have created?
I currently receive the following error message when trying to run the report without the assembly file in the MSSQL.3 folder:
An error occurred during local report processing.
The definition of the report 'Test Report' is invalid.
Error while loading code module: 'SSRS.ResourcesEX, Version=1.0.0.3, Culture=neutral, PublicKeyToken=7ca0a9683eac85b7' Details: Could not load file or assembly 'SSRS.ResourcesEX, Version=1.0.0.3, Culture=neutral, PublicKeyToken=7ca0a9683eac85b7' or one of
its dependencies. The system cannot find the file specified.
Help on this would be very much appreciated.
Thanks, Joe
October 25th, 2010 4:55pm