Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
krabople
Starting Member
17 Posts |
 Posted - 2008-06-06 : 03:18:45
|
| Hi, I have a report which displays monetary amounts. I have set the format of the table cells to c0, and everything is showing in dollars. However, I need this to show as pounds and can't seem to find out how to do this. I have checked the regional settings on my PC which are correctly set to English (United Kingdom). I have also tried going to tools, options in the report and then changing the language to "Same as Microsoft Windows" under International Settings but this does not seem to have done the trick. Also I have to enter date parameters in as mmddyy as opposed to ddmmyy. Does anybody know how I can change these things? Please help, it's driving me up the wall!! |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-06-06 : 04:25:32
|
| Did you check the language settings for your report? Open the rdl in Visual Studio and in properties window select report and make sure the language settings is set to English (UK) |
 |
|
|
krabople
Starting Member
17 Posts |
Posted - 2008-06-06 : 04:32:29
|
| That's spot on, thanks very much, didn't realise it was that easy. However, although that's worked for the currency, the date still appears to be in American format. Any idea why this is? |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-06-06 : 04:59:48
|
quote:
Originally posted by krabople
That's spot on, thanks very much, didn't realise it was that easy. However, although that's worked for the currency, the date still appears to be in American format. Any idea why this is?
You mean locally or even after deploying to server? |
|
|
|
krabople
Starting Member
17 Posts |
Posted - 2008-06-06 : 05:41:41
|
| Both locally and once it's been deployed unfortunately |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-06-06 : 10:30:00
|
quote:
Originally posted by krabople
Both locally and once it's been deployed unfortunately
Is the behaviour consistent in both report manager and report viewer? |
|
|
|
|
|
|
|
|
Change from dollars to pounds