Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
Report Builder 3.0 multi-languages

Answered Report Builder 3.0 multi-languages

  • Monday, January 28, 2013 5:16 PM
     
     
    Sign In to Vote
    0
    I develop reports in 3.0 for a company in the US. We have a need for some of our reports to display in Spanish for our client in Mexico.  Is there an update or add-on to have reports developed in English to translate into Spanish?
     

All Replies

  • Tuesday, January 29, 2013 6:39 AM
     
     Answered
    Sign In to Vote
    1

    Hi,

    You have many options,

    1] the simpliest , Duplicate the report layout  One Spanish and English  and toggle visibility dependant on the parameter selection.

    2] next use two subreport each written in the required languages and select them dependant on the Parameter selection.

    3] use A single report layout  and use an IIF stament on each  field that needs translating.

    4] Use the T-sql to select only the language that you want to display. this is fine for data but you will need to change the headers with an IIF

    5] If you are using SSRS 2008 R2 use the Lookup functions

    6] Use a T-SQL dynamic  pivot to  twist the data around to the language of your choice  the tricky bit here is to present a consistant column name to SSRS or it will fail this can either be a number whcich does not work well in  SSRS 2008R2 and but makes be-bugging difficult or  present the column headers in english.

    7] if you are using SSAS as a source then add the translations to the Cube

    8]create a report that allows the user to select a data source at run time. In order to achieve this, you must define an expression in the report that returns a list of possible data sources.

    This is Datawarehouse Forum, request to post your SSRS related queries in Reporting Forum for faster replies

    http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/threads

    Best Regards,
    Silna
    Please feel free to ask if you have any doubts and remember to mark the correct replies as answers.

     
  • Tuesday, January 29, 2013 6:44 AM
     
     Answered
    Sign In to Vote
    1

    Hi,

    For the stand-alone version of report builder(report builder 3.0), you can select the language version that you want to install.

    You must repeat the download for each language version that you want to use.

    See http://technet.microsoft.com/en-us/library/dd207038.aspx for more details about report builder 3.0 language.

    So, to install the Spanish report builder, you need to download it from

    http://www.microsoft.com/en-us/download/details.aspx?id=6116 --> with "Change Language" = Spanish, then install it.

     

    Best Regards,
    Silna
    Please feel free to ask if you have any doubts and remember to mark the correct replies as answers.