I ran into an issue with regards to Currency Symbol in SSRS. I'm currently developing a report thats being called in application that needs a Currency symbol. Since this report will be used in different locations the Currency Symbol needs to be dynamic. For sample if it is viewed in UK it needs to show Pound and if its in the US needs to show the dollar sign. The locale settings is setup within the app.
I already done a few reports that has the same capability and it works perfectly fine. Here are the things I am doing to achieve that:
1. Set the Language to en-US in the Report Properties.
2. Set the textbox properties format to "c".
But for an unknown reason the report thqt im developing right now is not working. I've tried to change the locale in our app to english(UK) and French but the currency symbol remains in USD.
Can you suggest anything to fix this?
Thanks in advance!