Zero Suppresion Query Level

[Former Member]

Hi All,

How do we have zero suppression activated at Query level automatically.

In other words when the report is opened the zero suppression should work without manually going to properties and selecting Zero suppression.

Thanks for the help.

James

[Former Member · Accepted solution]

Hi

In the query properties (7th tab on toolbar of query designer) , go to rows/columns tab there you can select Supress zero as active . This is supress the rows/columns when they have zero values.

Hope this helps. Let me know if you have any questions.

Regards

Suvarna

[Former Member · Accepted solution]

Thank you Suvarna

[Former Member · Accepted solution]

Hi Harrison,

Please mark as answered if your issue is solved.

Regards

Suvarna