Format Question -- sql server reporting services

RMac
7/11/2005 9:19:15 AM

RP,
If I try 0.## I get the results you are looking for. The data type for the
data is dec(5,3). With #.## I get .00 for 0 rather than 0.00. What is the
datatype of your data?

RMac

[quoted text, click to view]

RMac
7/11/2005 9:27:01 AM

I take that back. I'm seeing 0.00 for zero. Let me see what I can come up
with. Apologies.

[quoted text, click to view]

RMac
7/11/2005 9:36:08 AM

RP,
Give G5 a try. If you need a larger precision specifier, just change the 5
to the desired number.
RMac

[quoted text, click to view]

RP
7/11/2005 11:19:17 AM

G5 worked perfect. Thanks RMAC.
(Actually in the meantime i changed it to #.00, and in expression i put an
iif(no <=0 then '0') ..blah blah....
But G5 is much much easier to use. Thanks again.

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server reporting services

sql server reporting services : Format Question