Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

Is there a way to set the language of a document body to a value fetch from the DB in SSRS? I tried with a simple expression and I got this error. I wonder what the best workaround is

enter image description here

share|improve this question
add comment

1 Answer

up vote 2 down vote accepted

I think I found a work around for you.

  1. Set up a new dataset to pull back the language value (let's say language_dataset into column language_value).
  2. Create a parameter, let's say called language. Set it to internal and set its default value -> Get values from a query and use the dataset and value you just set up.
  3. In the Report properties, Language -> expression and set the expression to =Parameters!language.Value.

Let me know if you need more details.

share|improve this answer
1  
It also worked by getting the value in the application that calls the report, a web app in my case, and then passing the value as a parameter to the report. –  tou Jun 26 '12 at 21:03
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.