SQLServerCentral.com / Article Discussions by Author / Article Discussions / Discuss content posted by Jessica M. Moss / Management - Level 9 in the Stairway to Reporting Services / Latest PostsInstantForum.NET v99.99.99SQLServerCentral.comhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comFri, 09 Dec 2016 19:08:31 GMT20RE: Management - Level 9 in the Stairway to Reporting Serviceshttp://www.sqlservercentral.com/Forums/Topic1304700-2668-1.aspxGreat job on this 9 step program!Is the source code available anywhere???much appreciated...D@veEMon, 08 Apr 2013 12:42:07 GMTdavebrigitteRE: Management - Level 9 in the Stairway to Reporting Serviceshttp://www.sqlservercentral.com/Forums/Topic1304700-2668-1.aspxOne thing I see hardly addressed in SSRS is translations. i.e. provide the same data to different users in the same layout but all fixed texts on the report are changed into the users' preferred language. The way most people seem to go at this is to write a copy of the same report for each language and have the end user select the report in their language. There surely must be better ways to do this if the only thing that changes between the copies is the text on the labels, captions and fixed text boxes, plus the format of the dates and numbers. Can anyone of you more experienced SSRS developers share your opinions/knowledge on this topic too?I've seen so far some examples that employ a CLR routine included in the report to lookup from a resource the translation for each text value. But since we've already got a data source, I would much rather retrieve the translations from the db and replace all fixed texts on-the-fly just before rendering the &#100;ocument.I'd especially like to see some solution that -just before rendering the output document- automatically finds all texts from the report definition (rdl?), passes those texts to a procedure in the database (as an xml?), retrieves all translations available and then for each translation found replaces the fixed text by the translated text, to then have a document rendered in which all labels, header and footer texts, captions, etc. are in the end-users' language of choice. All from one and the same report definition. This scenario has some big advantages: for example we need to test the document only once to see that the report is functionally correct and need not redo it all again after yet another translation is added/changed. Same for deployment onto various environments, it only needs to be done once per environment. And no longer do we need to wait for all languages "official" translations to arrive before we can start developing, testing or even deploying the report...Here's [url=http://blogs.msdn.com/b/bwelcker/archive/2007/07/11/laser-guided-missiles-report-localization-through-parameters.aspx]an excellent blog by Brian Welcker[/url] close to what I intend to get to. The main thing this solution still lacks however is finding all texts from the report definition and replace them automatically. Does anyone have some (links to) examples on how this can be done?Fri, 01 Jun 2012 06:18:32 GMTR.P.RozemaRE: Management - Level 9 in the Stairway to Reporting Serviceshttp://www.sqlservercentral.com/Forums/Topic1304700-2668-1.aspxHi Jessica,Thank you for putting all this information into one place - you have helped me a whole lot, and I'm sure plenty of other folks have benefited.Congratulations on a job well doneTom :-)Wed, 23 May 2012 12:36:30 GMTTom_SacramentoManagement - Level 9 in the Stairway to Reporting Serviceshttp://www.sqlservercentral.com/Forums/Topic1304700-2668-1.aspxComments posted to this topic are about the item [B]<A HREF="/articles/Stairway+Series/72654/">Management - Level 9 in the Stairway to Reporting Services</A>[/B]Wed, 23 May 2012 00:02:57 GMTJessica M. Moss