Display Format #.00 shows negatives in brackets. And I dont want brackets....
I have a report with a figure, with a display format of #0.0 - but when the
number is negative it displays as (#0.00) but I have not specified to use
brackets. If I use a format of #0.0;#0.0;-#0.0 the thing screws up
totally and prints 0.00; ; - with all the characters. What is the
story?
Amb
number is negative it displays as (#0.00) but I have not specified to use
brackets. If I use a format of #0.0;#0.0;-#0.0 the thing screws up
totally and prints 0.00; ; - with all the characters. What is the
story?
Amb
This discussion has been closed.
Comments
In my testing, using "#,0;-#,0" seemed to work correctly. Be sure your
Windows Regional Settings are not overriding this. I believe when you do
not define a negative number format, ReportBuilder will use the Windows
default.
--
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com