Geek Answers Handbook

Change a currency symbol in SQL Reporting 2005

I am using SQL Reporting 2005. I am formatting the currency in a cell using

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

but the format comes out

 $10.00

I want pounds to

 £10.00

Can someone tell me where this setting is. I looked and google and can not find it. It is obvious? I want to set it at the report level, if possible, and not change SQL Server settings due to minimizing the impact elsewhere.

I could translate the currency into a string and add "£" , I think, but I want to do it right.

+7
source share
2 answers

You do not need to manually edit the RDL file. I think you could not see the language section because you did not have the selected report.

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

enter image description here

+3
source

By default, the date, currency, and number formats are determined by the language of the report server at run time.

To override the formatting provided in the language of the report server, you can set the Language property in the report when it is developed. This can be set at the report level or at the TextRun level. If you want to change the formatting based on the language or local settings of the browser or client application, you can set the Language property to an expression that contains the User! Language

This information has been provided HERE .

In the Report, you can set the language property, which is located in the "Localization" section. In this property, you put the language code, for example en-GB. You can also do this at the field level if you wish. This should match your regional and language settings on your PC. If you want to override this or manage it, you can simply set the report property.

If you set this property and then look at the report code (RDL), you will see it at the very bottom:

  <Language>en-GB</Language>

This information will be used for currency, date and numerical conversions.

+2
source

More articles:


All Articles