Search code examples
sql-server-2005reporting-servicesformattingglobalization

Changing currency symbol in SQL Reporting 2005

I'm using SQL Reporting 2005. I'm formatting a currency in a cell using

Format(Fields!NetPrice.Value, "C")

but the format is coming out

$10.00

I want pounds so

£10.00

Can someone tell me where is the setting to do this. I've looked and google and can't find it. Is it obvious? I want to set it on the report level if possible and not alter SQL Server settings due to minimise impact elsewhere.

I could cast the currency to a string and add "£" I guess but I want to do it properly.

Solution

  • You shouldn't need to manually edit the RDL file. I guess you couldn't see the language section as you didn't have the report selected.

    To see the report properties click on the background behind the outline of the report (the yellow section) and check the properties window or select 'Report' from the drop down when viewing the properties window.

    enter image description here