Hiding Rows, Columns, or Grids

You can hide rows, columns, or an entire grid so that the values are not displayed when you print or view a report. For example, you might want to hide a grid if you include a chart based on the grid data and want to display only the chart on the report.

Note:

The data and calculations in rows or columns are evaluated, regardless of the formatting that is applied to them.

To hide a grid:

1. In the Report Designer, select a grid.

2. In Grid Properties, expand Suppression, and then select Hide Grid.

To hide a row or column in a grid:

1. In the Report Designer, select a row or a column in a grid.

2. In Row Properties or Column Properties, select Hide Always.

3. Specify whether ignore the values or calculations in the hidden row or column when you print or view a report.

   • To ignore values and calculations, select Suppression Ignores Row or Suppression Ignores Column.

   • To include values and calculations, clear Suppression Ignores Row or Suppression Ignores Column.

     Note:

     Hidden cells are ignored when suppression is evaluated unless they are specifically referenced using conditional suppression. For more information, see About Conditional Suppression.