locked
how to set the language for a report? RRS feed

  • Question

  • hi all,
    how to set report language??
    is it done by using USER!Language = xxx
    and if so where can i put this expression ???


    Ahmed Salah
    Monday, May 4, 2009 6:56 AM

Answers

  • Hi A.Salah ,

    The language when viewing report manager is taken from IE culture.
    see http://msdn.microsoft.com/en-us/library/ms156493(SQL.90).aspx



    The language & Culture for  for a single text box is set via properties  "F4" 
    look for Language properties  pull down language\culture  SSRS 2005 is in words whilst SSRS 2008 has it in in the four letter format.

    To set the  language for the complete report.
    SSRS 2005  top top left of the design window  for a small square  click on it en press "F4"  
    SSRS2008 Click on the blackground  then "F4". ( not the body but the area out side of the page layout.)

    The properties  you set at report level are inherited and marked as "default"
    see  http://msdn.microsoft.com/en-us/library/ms159642.aspx


    If you want to set the culture via =User!Language then set it in any of these places


    If You want to set the Culture via a URl this can be done by using the 4 letter format
    see http://msdn.microsoft.com/en-us/library/ms155064.aspx 

    Hope this helps
    • Proposed as answer by Raymond-Lee Tuesday, May 5, 2009 6:23 AM
    • Marked as answer by A.Salah Tuesday, May 5, 2009 9:10 AM
    Monday, May 4, 2009 1:01 PM

All replies

  • Hi A.Salah ,

    The language when viewing report manager is taken from IE culture.
    see http://msdn.microsoft.com/en-us/library/ms156493(SQL.90).aspx



    The language & Culture for  for a single text box is set via properties  "F4" 
    look for Language properties  pull down language\culture  SSRS 2005 is in words whilst SSRS 2008 has it in in the four letter format.

    To set the  language for the complete report.
    SSRS 2005  top top left of the design window  for a small square  click on it en press "F4"  
    SSRS2008 Click on the blackground  then "F4". ( not the body but the area out side of the page layout.)

    The properties  you set at report level are inherited and marked as "default"
    see  http://msdn.microsoft.com/en-us/library/ms159642.aspx


    If you want to set the culture via =User!Language then set it in any of these places


    If You want to set the Culture via a URl this can be done by using the 4 letter format
    see http://msdn.microsoft.com/en-us/library/ms155064.aspx 

    Hope this helps
    • Proposed as answer by Raymond-Lee Tuesday, May 5, 2009 6:23 AM
    • Marked as answer by A.Salah Tuesday, May 5, 2009 9:10 AM
    Monday, May 4, 2009 1:01 PM
  • Hi R.Edgson,

    thanks alot for your great answer
    it really helped me alot
    you give me a detailed answer


    Ahmed Salah
    Tuesday, May 5, 2009 9:10 AM