Hiding Rows, Columns, or Grids

You can hide rows, columns, or an entire grid so that their values are not displayed when you print or view a report. You might want to hide a grid, for example, if you include a chart based on the grid data and want to display only the chart on the report. When the grid is hidden, the grid’s title bar changes from blue to gray.

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

  To hide a grid:

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

  2. Select a grid.

  3. In the Grid Properties property sheet, select Suppression category.

  4. Select the Hide Grid check box.

  To hide a row or column:

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

  2. Select a row or column.

  3. Select the Hide Always check box.

    Note:

    You can specify whether the data values of hidden row or column are taken into account during suppression. For information on this option, see the topic below: “Controlling the Evaluation of Suppression in Hidden Rows or Columns”.