Currency in SQL 2005 Reporting Services

[Ice Rhino]

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!!!!

 

[SQL_Hell]

how about the language settings in SQL server?

run sp_configure, and check it in BOL

 

[Ice Rhino]

I ran it and this was the result

allow updates 0 1 0 0
clr enabled 0 1 0 0
cross db ownership chaining 0 1 0 0
default language 0 9999 0 0
max text repl size (B) 0 2147483647 65536 65536
nested triggers 0 1 1 1
remote access 0 1 1 1
remote admin connections 0 1 0 0
remote login timeout (s) 0 2147483647 20 20
remote proc trans 0 1 0 0
remote query timeout (s) 0 2147483647 600 600
server trigger recursion 0 1 1 1
show advanced options 0 1 0 0
user options 0 32767 0 0

Can't find you BOL section

Kindest Regards

 

[SQL_Hell]

Hi

run this


exec sp_configure 'default language', 23

then this


reconfigure with overide

 

[SQL_Hell]

oh btw BOL is the sql server help file

 

[Ice Rhino]

Thank SQL, I have done that and will give it a try.

This is by no means to look like a smarty pants or anything, more just to help others if they need to run the same commands.

In SQL Server 2005 I had to run it like this

EXEC sp_configure 'default language', 23;
GO

Then ran

RECONFIGURE WITH OVERRIDE;
GO

Or perhaps this is common knowledge and I was the dummy for not realising that everybody knew that.

Thanks for your help SQL Hell. I shall go see if that has solved the problem.

Regards

 

[Ice Rhino]

Problem Solved:- 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.

Regards