Currency Symbol Problem

I am currently writing a report in SQL 2005 RS and have a problem with the format of a currency field. I am creating the report through the 'SQL Server Business Intelligence Development Studio'

In the report preview (and live) it shows the prefix for the field to be $, and yet when I look at the custom format for the field it shows it as being Format Currency and the sample shows the output will be ￡1,234.00.

If I change the format to percentage or whatever it does exactly what you would expect it to do.

I have checked all the regional settings on my machine to UK in the various places you can and still it wants the result to be dollars.

Anybody, help please!!!!

Try setting the Report.Language property explicitly to en-UK.

Alternatively, set the Report.Language based on the user's language setting: =User!Language

Note: format code (such as currency) only have an impact if the textbox value is a numeric datatype and not already a string.

-- Robert

|||

I could not find the reference to which you referred, however following along the lines that you suggested I noticed that in the properties for the textbox, under 'International' there was a setting for 'Language', so I selected all of the offending boxes and changed their International properties from Default (U.S. I guess) to English (United Kingdom), and bingo, problem solved.

Thanks for pointing me in the right direction.

Regards

|||

The Report.Language is available through the VS properties window - which contains a drop down list with all items contained in the report. Select "Report" from the drop down.

The Report.Language property is a global setting for the entire report, while the Textbox.Language property will only impact that particular item.

-- Robert