How would I clear up all the zeros in a report to either blanks or dashes
Example:
With a standard format numbers:
Col A | Col B
-----------------------
1.00 | 0.00
I want to clean it up like in Excel's Cell format called "Accounting"
Col A | Col B
-----------------------
1.00 | -
This makes it easy to read
Format of zeros
New England BizTalk User Group
You can use expression to show "-" conditionally, i.e.
=iif(Fields!ColB.Value = 0,"-",Fields!ColB.Value)
jjrr007
You can use custom numeric format strings as well, for example:
=Fields!ColB.Value.ToString("#.00;(#.00);-")