Using the Basic Option in Conditional Suppression

Use basic conditional suppression to suppress data in rows or columns based on If Zero, If Missing, Is Error. Basic conditional suppression can be combined with advanced suppression options. See Using the Advanced Option in Conditional Suppression.

  To suppress data:

  1. Create a grid in a report in the Report Designer, or open an existing report containing a grid.

  2. Select the grid, rows, or columns to which you want to apply suppression.

  3. In the Row or Column Properties sheet, click the Basic Options button.

    Note:

    If you selected a grid, first select the Suppression category in the Grid Properties property sheet.

  4. Select one or more of the following options:

    • Select If Zero, Suppress to hide the rows or columns where all cell values equal zero.

    • Select If Missing, Suppress to hide the rows or columns where all cells are empty.

    • Select If Error, Suppress to hide the rows or columns where data cannot be retrieved or calculated because of errors.

  5. Optional: To replace #ZERO, #MISSING, or #ERROR values in a row or column that cannot be hidden, take one or more of the following actions:

    Note:

    You must have a grid selected and select the Suppression category in the Grid Properties property sheet.

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

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

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

  6. To select all options and specify customized suppression criteria, select Advanced Options.