Tuesday, February 21, 2012

Reporting Services Currency (£)

I am trying to produce a report showing Currency in £ using Visual Studio 2005 reporting services.

On trying to format the textbox the only option that it seems to give you is for it to be displayed in $.

Does anyone know how i can display a number in £ instead of $?

Try putting something like this in your format code:

£ ###,###,###.##

Depending on how large your numbers could get, just add #'s. It doesn't add leading 0's.

Hope this helps.

Jarret

|||

Another way to do this is to set the language property of the report to 'English (United Kingdom)', then set your fields to display with the format code of 'C' (currency). It will automatically set the default currency symbol for that language on any fields set for currency.

Jarret

No comments:

Post a Comment