all groups > sql server reporting services > september 2005 >
You're in the

sql server reporting services

group:

Currency Format


Currency Format Weston Weems
9/28/2005 3:26:00 PM
sql server reporting services: I'd like currency format of $#,###

but when i specify that, I dont get any values for 0 I just get a $
which is somewhat expected.

If I specify C, I get the cents, which I dont care about.

Anyone knowhow I might achieve C currency format, that doesnt include
cents, but displays 0 when the value is 0?

Thanks in advance
Re: Currency Format Jerry Spivey
9/28/2005 4:01:20 PM
Weston,

Check out the FORMATCURRENCY function.

HTH

Jerry
[quoted text, click to view]

AddThis Social Bookmark Button