Local numberformat in reporting services

Hi,

I am making a report using Reporting Services with Microsft SQL Server 2005 (through Visual Studio). I need to display some numbers, but they default to numbers like: 10000.00. The target number in this case is 10.000,00 (danish numberformat with a different decimal separator and an added thousand separator than english).

This is what I have tried:
1. Formatnumber(number), which gives 10,000.00 (english numberformat) because the machine running reporting services is english.
2. Format(number,"###.###.##0,00") which gives and error
3. Replace(FormatNumber(number),",",".") which is not desirable because:
a) what to do with last "." when all separators are now "."
b) I read about this beeing bad coding because it would give me some problems with different systems

I read about changing the locale setting for the session using LCID or something like that but I am not sure how to use this through reportings services, what code to use and where to put it...

Can you help me?

Thanks in advance!
Kind regards
DavidStart Free Trial