Zero as blank

[sdawson]

Is it possible on a report to display all field values of 0 (zero) as blanks?

 

[Dennisk]

you need the reverse of NZ (null to zero). you could write your own function and call it either in the underlying query for the report or as a calculated field on the report.

 

[Brianwarnock]

The short answer is yes but on a field by field basis. I've never understood why people want this as zero and blank are quite different, if it is merely to make the report look pretty and have blank fields ignored then I would use visible=false on both the field and its label if possible.

Brian

 

[sdawson]

Got it with conditional formatting. Printing zero fields in white!!
Easy or lazy?

 

[Brianwarnock]

There's nothing wrong with a little wit saving a lot of sweat.

Brian