We help IT Professionals succeed at work.

SSRS 2008 Spanish Translation

Lisa Callahan
on
240 Views
Last Modified: 2017-04-18
Hello experts -

We are in the process of localizing our SSRS reports and have run into an issue that I don't think is solvable at the user level. When you have a report with a multi-select parameter, SSRS automatically displays a '(Select All)' parameter as a choice. Is there a way to translate that choice into Spanish at the report level?

Thank you.

-- Lisa
Comment
Watch Question

Jim HornSQL Server Data Dude
CERTIFIED EXPERT
Most Valuable Expert 2013
Author of the Year 2015

Commented:
Not entirely sure what you are asking us, but SQL Server does not have any capabilities to automatically translate text to a different language.  What it can do is define different columns based on a collation (i.e. language, case sensitivity, access sensitivity), then have those tables.columns populated with those languages, and developers have the ability to write code to point to the appropriate table.column based on those languages.

For example, my current client is a travel rewards program.  We have an English database that describes hotels around the world, and multiple other databases with the same exact schema but different collations, and translators that write the same values but translated into those various languages.   Then front-end apps identify the language used, and functions pull data from the appropriate database.table.column.
Lisa CallahanBusiness Intelligence Analyst

Author

Commented:
Sorry for the confusion. We have been able to translate what we needed for the content of the reports by using a localization table in our SQL database and pointing to that. What I am trying to figure out is whether or not there is somewhere withing SSRS to translate the default of (Select All) in a multi-value parameter.

Select All default
Megan BrooksSQL Server Consultant

Commented:
Oh that. It is one of several recurring issues with the parameter UI (ever since SSRS was originally released). I don't know of any solution other than writing your own parameter UI code and suppressing what is in Report Viewer. If you want a clean UI, that is the way to go. I'm not saying it is easy to do that, but the Report Viewer parameter UI has significant issues that have no direct workarounds.
Megan BrooksSQL Server Consultant

Commented:
You can set the locale for a report. I haven't used this feature, and I don't know off the top of my head if it is an RDL-only setting or something that can be set using an expression.
Lisa CallahanBusiness Intelligence Analyst

Author

Commented:
I have tried to set the locale for the report but when I change it to Spanish and then run it, nothing happens. Either I am not doing it right (most likely) or it doesn't work.
Megan BrooksSQL Server Consultant

Commented:
It is surprisingly hard to find information about this. I am going to do a little experimenting, later today. Something is trying to come back to memory. :-)
SQL Server Consultant
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
Lisa CallahanBusiness Intelligence Analyst

Author

Commented:
THANK YOU!! Now I will hand this solution over to the development team in charge of those options.
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.