Grid Section of the Properties and Formatting Dialog

Use the Grid section of the Properties and Formatting dialog to format grid reports in your documents, or change how users drill on a grid or graph.

Access

Open a document in Design or Editable Mode.
Right-click a control and choose Properties and Formatting.
In the left pane, click Grid.

Fields

Headers

Rows Choose whether to display row headers, merge repeated row headers, or lock them in place.

Columns Choose whether to display column headers, merge repeated column headers, or lock them in place.

View

Specify general display options for displaying grids in a document, such as whether to apply banding to rows in the grid.

Outline Display the grid in outline mode.

Show Banding Apply banding to the selected grid once the document runs.

Show attribute form names Select how headers for attributes and attribute forms appear .

Off Select this option to have the attribute name automatically appear in the header of each attribute in the grid. No attribute form names are included in the grid.
On Select this option to have a header automatically appear for each attribute form in the grid, with each header consisting of the attribute name followed by the attribute form name.
Form name only Select this option to have a header automatically appear for each attribute form in the grid, with each header consisting of only the attribute form name.
Show attribute name once Select this option to have a header automatically appear for each attribute form in the grid and have the attribute name included only in the header for the first attribute form for each attribute. The remaining attribute forms display using the attribute form name only.
Automatic Select this option to automatically display either headers for each attribute or each attribute form depending on the number of attribute forms visible in the grid for each attribute. If only one attribute form is shown in the grid for an attribute, the attribute appears with a header containing the attribute's name. If more than one of the attribute's forms are visible in the grid, each attribute form is displayed with a header containing the attribute name followed by the attribute form name.

Remove extra column Determines whether the word Metrics appears as a column or row header on the grid.

Hide Null/Zero toggle behavior This option allows you to hide null and zero metric values in a grid.

Show thresholds Allows you to display thresholds in the selected grid. This option is available only if thresholds have been defined in the grid.

Drilling

Specify drilling options for a grid or graph.

Drill OptionsSpecify whether users can drill on the selected grid or graph. Drill within allows user to only drill on objects within the dataset. Drill anywhere allows user to drill on attributes other than those available in the dataset.

Synchronize the following templates with this object You can enable users to automatically drill on another grid or graph (the target) when they drill on the grid or graph that is currently selected (the source). Drill Options must be set to Drill within.

Incremental Fetch

Incremental fetch divides a large grid or graph into pages, thereby loading the data in batches rather than all at the same time. Incremental fetch can help improve performance, especially with very large reports. Incremental fetch is applied when the document is executed in editable or presentation mode in Workstation.

Enable incremental fetch on grid Select whether to allow incremental fetch.

Count by

Individual rows Divides the grid or graph by rows. In Maximum number of rows per page, enter the maximum number of rows to include on each page.
Blocks To divide the grid or graph by blocks (or groups of data), select Blocks. In Blocks per page, enter the number of blocks to include on each page.