I am trying to set Language setting for a filed in my table dynamically. I have an expression which decides which language should be there for that field depending on the parameter passed...
Code looks something similar to this.
=iif(Parameters!Curr_Code.Value="USD","English (United States)", IIF(Parameters!Curr_Code.Value="GBP","English (United Kingdom)", "French"))
When I run the report and pass "GBP" or "EUR", it gives me USD sign for currency. it is not giving me Pound or Euro sign for this currency field.
If i set it static: Pound or Euro; then i am able to see Pound and Euro sign, but not the case with an expression.
Anybody had this issue before?