Printing xxx.xx but not 0.00 in reports

[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

 

[Marshall Barton]

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?

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

$#,##0.00;($#,##0.00);""

 

[Olduke]

With your form in design view, right click the text box.

 

[CW]

Perfect! Many thanks, Marsh
CW

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

$#,##0.00;($#,##0.00);""