When considering presenting SSRS reports in multiple languages, one also needs to consider where to store translations. Translations can either be:
stored in a data source (database, cube) or resource file, either accessed directly from the report or through a service call
retrieved from an external translation service, such as Bing Translate
In most solutions retrieving a predefined translation would be preferable to doing an automatic translation using an external translation service, since the quality of the results can be questionable. A scenario I come across often is that the external translation service is only used when a predefined translation is not available. The scenarios discussed in this series of posts do not pose any requirement on how the translation is retrieved. Reporting Services can pass the user’s language setting along. That can then be used to get the right translation.
Additionally, some of the items considered when thinking about a multilingual SSRS solution are:
Can the report be developed once and presented in multiple languages? All of the scenarios discussed in this series provide this capability.
Impact on report creation process. Does the solution chosen require manual activities when designing the report?
In this series of blog posts we talk about options for implementing multilingual SSRS reports. Below is a quick scoring of each option on the above capabilities and requirements. Of course the importance of requirements and the correct choice depends on the situation.
Each scenario will be discussed in a post in this series.