sql server reporting services: How to format numerics with the sign on the right? -- sql server reporting services

How to format numerics with the sign on the right?

virtualfergy
9/21/2005 1:25:03 PM

sql server reporting services: I've got an amount field in a report where I want the values to have the sign
(if negative) on the right. But I also want the numbers to line up properly.
I can't seem to find a way to format this. In Excel, you'd use a format like
#,##0.00_);#,##0.00-. But that does not quite do it in Reporting Services. I
see you can use custom formats and the syntax is similar to Excel but not
quite the same. I tried:

#,##0.00 ;#,##0.00-

but RS seems to ignore the whitespace. I also tried:

#,##0.00' ';#,##0.00-

also to no avail.

RE: How to format numerics with the sign on the right?

Albert
9/22/2005 2:43:03 AM

What about using double quotes: " " ?

[quoted text, click to view]

RE: How to format numerics with the sign on the right?

virtualfergy
9/22/2005 7:21:04 AM

Tried it. No luck I'm afraid. Works the same as single quotes. Any other
advice out there?

[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 in the sql server reporting services group.