Defining Basic Conditional Suppression

Use basic conditional suppression to suppress data in rows or columns based on "If Zero," "If Missing," and "If Error". You can combine basic conditional suppression with advanced suppression options. See Defining Advanced Conditional Suppression.

To suppress data:

1. In a grid, select the rows or columns to suppress, or select the entire grid.

2. In Properties, under Suppression, select Basic Options, and the select one or more of the following options:

   • If Zero, Suppress—Hide rows or columns where all cell values equal zero.

   • If Missing, Suppress—Hide rows or columns where all cells are empty.

   • If Error, Suppress—Hide rows or columns where data cannot be retrieved or calculated because of errors.

To replace #ZERO, #MISSING, or #ERROR values in rows or columns that cannot be suppressed:

1. Select an entire grid by clicking in the upper left cell.

2. In Properties, expand Suppression, and then do one of the following.

   • To replace zero (#ZERO) values in cells, enter a value in the Zero Values text box.

   • To replace no data (#MISSING) in cells, enter a value in the No Data text box.

   • To replace erroneous data (#ERROR) in cells, enter a value in the Error text box.