Local Currency Symbol Not Working

  • BIjourneyMan

    SSC Enthusiast

    Points: 119

    Hi Guys,

    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!

  • Site Owners

    SSC Guru

    Points: 80372

    Thanks for posting your issue and hopefully someone will answer soon.

    This is an automated bump to increase visibility of your question.

  • Sergiy

    SSC Guru

    Points: 109881

    Make a lookup table which allocates every location mentioned in the system to a correlated currency symbol.

    Locales might not be sufficient for this purpose.

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply