Using Hidden Grids
You can hide a grid from being displayed in the report output. For example, if you use row or column formulas to pull in data from additional data sources into one grid, you can hide the source data grids by placing them in the hidden sheet.
To hide an existing grid:
-
In the Report Designer, select the grid to be hidden.
-
Right-click, and select Move To, and then select Hidden Sheet.
To create a new hidden grid:
-
In the Report Designer, from the sheet panel, click
-
To add a grid to a report. See Adding a Grid topic to insert a new grid.
To unhide a hidden grid:
-
In the Report Designer, from the sheet panel, click
-
Select the grid in the Hidden Sheet that you want to unhide, then right-click, and select Move To, and then select a sheet, where you want to move the grid.
