You can remove rows and columns from a grid if the entire row or column contains zeros. If any cell contains data other than zero, the row or column will not be removed.
![]() |
Enabling all three Suppress missing rows, Suppress missing columns and Suppress zero rows & columns options allows you to remove rows that have a combination of missing data and zeros. These options can not be undone. Once these options are in use, disabling them again will not return the missing and zero rows or columns to the display. If you want to return that data you must unselect the options and re-issue the query. |
To suppress zero rows and columns:
When you click the Apply button the changes are implemented but the dialog box remains open.