Adding a Grid/Graph and a new dataset simultaneously

If the report that will populate the Grid/Graph with data has not been added to the document yet, you can add a new dataset and a Grid/Graph to the document at the same time.

To add a dataset and a Grid/Graph simultaneously

1. In MicroStrategy Web, open the document in Design Mode.
2. From the Insert menu, select Report.

3. Click and drag in the section where you want the Grid/Graph. The Select Dataset dialog box opens.

   You can place a Grid/Graph 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.

4. Locate and select the dataset to add to the document. This dataset also provides the data for the new Grid/Graph.

5. Select whether or not to use the formatting of the report:

   • To create a Grid/Graph that includes all the objects of the report, whether they appear on the report grid or in the Report Objects pane, clear the Add with formatting check box. Any view filters on the report are not applied to the Grid/Graph. The default Grid/Graph formatting is applied to the Grid/Graph.
   • To create a Grid/Graph that looks like the report itself (the report formatting is copied and only those objects displayed on the report grid are copied onto the Grid/Graph), select the Add with formatting check box. Any view filters on the report are applied to the Grid/Graph.

6. Click OK to return to the document.

   A new Grid/Graph is displayed in the document, and the dataset is displayed in the Dataset Objects pane.