Help Topics

Suppressing Zero Rows and Columns


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.

Note

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:

  1. In the Data Options dialog box, check the Suppress zero rows & columns check box.
  2. Click the OK button to close the dialog box and implement the changes.

When you click the Apply button the changes are implemented but the dialog box remains open.


Related Topics: