Suppress zero values in a crosstab

[mocgp]

CR10; Oracle

Does anyone know a way to suppress a zero value in a crosstab cell? I know about the suppression options in the Customize Style tab, but they only apply to rows/columns. The usual technique of inserting a suppression formula in the field format does not work.

 

[Madawc]

Right-click and 'Format Field' on the field in the cross-tab. Then you can use Customise > Number and check the 'Suppress if Zero' box.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[mocgp]

Thanks!! Elegantly simple, huh?