Language Setting for a Field (Run Time) | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Language Setting for a Field (Run Time)

Hello all,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.So, do i need to create separate report for separate currency!!!.. or is there any way we can generate report with different currencies by using parameters!!!!Anybody had this issue before? Thanks!!-RP
Most client apps will show you the currency symbol related to the OS’s language setting, for any column defined as "currency".
Yes, of course we need a true currency date type, including a varying symbol, plus the historical and current exchange rates – but then you don’t get to program anymore.

Thank you Adriaan, yea, I couldn’t find any help on that on web. Well, I found intermediate solution for this issue by having two separate columns for each language as i have two currency columns. and then setting visible property to true/false as per the passed parameters.Thanks for your reply though…-RP

Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |