Globalization & Localization in sql server reporting services.

Hi All,

I am new to sql server reporting services. I am planning to use sql server reporting services for one of my project. But i have some doubts. Please any one help me.

1) Is it possible to localize sql server reporting services?

2) Is it possible to read and display the search labels and other column headers from resource file?

3) Will it display numeric, date and sort based on culture?

4) If it is possible then where we have to make the setting for that? I mean in the sql server or in the asp.net code behind file?

5) Is there any samples available in the net.

Thanks in advance.

I'm new to reporting services as well but i'll try to answer a few of your questions.

3. it will display the data based on the language setting on the computer that is hosting the file I believe

Check out this article for some more infohttp://www.sqljunkies.com/WebLog/tpagel/archive/2005/07/24/16197.aspx

4. see the article above (just a heads up but there are no code behind files in reporting services)

5. there are some samples located on the msdn site (herehttp://msdn.microsoft.com/sql/bi/reporting/default.aspx also a good place to start for info )

|||Thanks saiham|||

Hi Vinoth, I am also new to this reporting service and now struggling with the globalization issue. Have you found out the answer to your second question "Is it possible to read and display search label and other column headrs from resource file"?

The report designer has a section for developer to create custom function or refernce to function from external assemblies. I wonder whether we can use this section to read the resource file. Any idea? I have zero knowledge on the Resource File. I'll highly appreciate any input. Thanks

Best regards,
Jess

|||

Hi jess, I posted this in many forums but not found any useful answers. I will get back to you if i found any.

|||

Hi, I wanna share with you guys, what I done on localization by making use of resource file.
I am new on this programming world, feel free to correct me.

Given the fact that we can add custom assembly to our report, my idea is to create a function (can be in any language) outside the report, which will return locale value for particular key. Then, create an assembly of the code, and add reference to the assembly from the report designer

The function I used as this:

Public shared Function ReturnString (ByVal myValue As String, ByVal myCI as Stirng) As String
Dim ci As New CultureInfo (myCI)
Dim rm As ResourceManager
rm = ResourceManager.CreateFileBasedResourceManager ("MyStrings", "e:\resources\", Nothing)
Return rm.GetString(myValue, ci)
End Function

Where MyStrings is my resource file name and "e:\resources" is the location where i stored all my resource files.

One thing to take note when adding custom assembly to report. The assembly we are referencing to, must be copied to report designer and report server. For SSRS 2005, copy the assembly to these 2 locations:

C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies
C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\bin

Hope this can be input to anyone who is looking for using resource file for localization for SSRS. If you have a better solution, please share with me.