all groups > sql server reporting services > november 2004 >
You're in the

sql server reporting services

group:

Formatting Currency (rounding)



Formatting Currency (rounding) Karl
11/11/2004 3:40:01 PM
sql server reporting services: I'm trying to show currency values rounded to the nearest thousand (i.e
$797,100.12 would display as $798. I can't seem to figure out the custom
Re: Formatting Currency (rounding) Karl
11/12/2004 8:07:04 AM


[quoted text, click to view]

That didn't really do the trick. I'm not trying to show the value as a
percentage, I'm trying to show it as currency but rounded to the nearest
Re: Formatting Currency (rounding) Jonas Montonen
11/12/2004 9:01:43 AM
[quoted text, click to view]

Try using "Format" = "P0" for the field.
P as for Percent
0 as for 0 decimals

Re: Formatting Currency (rounding) Jarle72
1/26/2005 1:39:03 AM
I have done this for norwegan format i used # ##0,.# to show 986000 as 986
hope this helps

[quoted text, click to view]
Re: Formatting Currency (rounding) Jarle
1/26/2005 1:41:05 AM
I have done this for norwegan format, I used # ##0,.# to show 986000 as 986
or 986100 as 986,1 Hope this helps

[quoted text, click to view]
AddThis Social Bookmark Button