Printing xxx.xx but not 0.00 in reports

  • Thread starter Thread starter CW
  • Start date Start date
C

CW

I produce invoices as multiple-line reports (up to 5 lines).
Sometimes just one or two lines will have a value and the others will not.
When a line is 0.00 I do not want this to print on the invoice so I used a
format in the report controls that fredg had suggested: #;-#;""
This works fine to suppress the unwanted 0.00s but unfortunately on the
lines that do have a value e.g. 123.45, these are printed as just 123 (the
DPs are not shown).
How can I get round this, so that where there are values they will be shown
in full, but where the value is 0.00 they will not be printed?
Many thanks
CW
 
CW said:
I produce invoices as multiple-line reports (up to 5 lines).
Sometimes just one or two lines will have a value and the others will not.
When a line is 0.00 I do not want this to print on the invoice so I used a
format in the report controls that fredg had suggested: #;-#;""
This works fine to suppress the unwanted 0.00s but unfortunately on the
lines that do have a value e.g. 123.45, these are printed as just 123 (the
DPs are not shown).
How can I get round this, so that where there are values they will be shown
in full, but where the value is 0.00 they will not be printed?
Click to expand...


The # format only displays integers. You should use a
currency kind of format. This is like the standard one:

$#,##0.00;($#,##0.00);""
 
Perfect! Many thanks, Marsh
CW

Marshall Barton said:
The # format only displays integers. You should use a
currency kind of format. This is like the standard one:

$#,##0.00;($#,##0.00);""
Click to expand...
 
Back
Top