SSRS Getting pounds instead of dollars
As much as I hate to admit it Microsoft is a US company
which means everything defaults to US. So dates are in mmddyyyy not ddmmyyy
format, words are missing letters such as color instead of colour and the
currency is dollars and not the Great British pound.
Most of this is handled by regional settings so once you have said you are in
the UK you get the correct formatting. However Reporting services is
different.
A recent client was trying to display financial figures and so wanted the
currency symbol to be displayed. They tried all the regional settings but
couldn't get rid of the dollar sign.
The trick is to change the language of the report to English(United Kingdom).
And heh presto you get a pound sign.
-