A Grid/Graph is a special type of control you can add to a document. When a dataset report is added to the Grid/Graph, and the document is executed, a Grid/Graph acts as a standard MicroStrategy report. For steps to add a dataset report inside a Grid/Graph to a document, see Adding, changing, or removing a dataset report.
When you want to design a document template, you can add a Grid/Graph to serve as a type of summary for a group or the entire document, because the data displayed in it is aggregated to the level in which the Grid/Graph is placed. If the Grid/Graph is in one of the Grouping header or footer sections, it limits the data displayed in it to only that which is included in that group. For example, suppose you have a report with Region in the Grouping panel, and you place a Grid/Graph in the Region Header section. If there are three values for the region (Midwest, Northeast, and Northwest), the Grid/Graph aggregates and displays only Midwest data in the Midwest region header, only Northeast data in the Northeast region header, and only Northwest data in the Northwest region.
A Grid/Graph can be placed anywhere in a document except in the Detail section. Since controls in the Detail section are repeated once per row of the dataset, the Grid/Graph would be repeated on each row.
You can also use a Grid/Graph to display a subset report, that is, a report with Report Objects that are not displayed on the grid. For more information, see Using a subset report as a dataset.
For examples and images, see the MicroStrategy Report Services Document Creation Guide.
Related topics