Determining langauge in SSRS by URL

  • Hello,

    I have a report that I want to render in different languages. Easy enough. However, the way I want it to work is for the user to go to a particular URL, and depending on whether the URL is, say, .fr for France, or .uk for the UK, it will recognize the URL and render the report in the correct language.

    The problem is, in testing, I've been trying to use the global &ReportServerURL but it does not seem to work.

    Using &ReportServerURL the text returns:

    http://rs1/ReportServer --(altered server name to rs1 for security)

    However, the URL that displays in the browser is:

    http://rs1/Reports/Pages/Report.aspx

    Do I take it, then, when I put the report live, it will not recognize the URL that appears in the browser, and so won't be able to tell whether the URL is .fr or .uk and so forth?

    Thanks for your help.

  • How are you rendering in different languages? Multiple copies of the report for different languages?

  • I was planning on using one report and determining the text for each of the text boxes in the expression using an IIF with the &ReportServerURL global. But now I'm thinking that this probably won't work.

  • You may want to look at the following then

    http://www.keepitsimpleandfast.com/2011/09/localization-of-your-ssrs-reports.html

    This is how I do it in one report

  • Thank you very much. This is excellent.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply