NON-ZERO VALUES TO BE DISPLAYED IN THE REPORT

[prasad_thakur]

Hi Friends,

How can i display only non-zero values in the query?

the zero values should not be displayed...

waiting for ur replay

Regards,

Pattnaik

[Former Member]

You can always create a condition showing rows Greater than 0.

Yaniv.

[edwin_harpino]

hi Pattnaik,

in query designer, edit query, click properties,

tab 'display' (2nd tab), and set 'zero values display' to 'suppress zero'

for row/column, there is section 'suppress zero row/column', set suppression = active, choose row, column or row and column.

hope this helps.