SSRS 2008 Spanish Translation
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
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
ASKER
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.
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.
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.
ASKER
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.
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. :-)
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
THANK YOU!! Now I will hand this solution over to the development team in charge of those options.
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.