Viewing a report as a grid: Grid View

A grid report displays report results in a format similar to a spreadsheet. Grid view provides an effective display to analyze details of your business data.

You can go to specific pages in a grid report, and you can determine how many rows or columns are displayed at one time. You can also search for an object to add to the report. See the appropriate steps below for information.

To view a report in Grid view

1 Click the name of a report to execute it.
2 Click the Grid icon Grid icon on the toolbar.

Viewing additional pages of results

If arrows Arrow to see additional data Arrow to see additional data appear at the top or bottom of the report, the report contains more result rows than can be displayed on a single page at a time. You can view additional data by clicking the arrows or by clicking a specific page number between the arrows.

To view a specific result page, click the drop-down arrow located next to the current page number. The Go To field opens, as shown below. In the Go To field, type the page number you want to navigate to, then click the Go icon icon.

Go To field

To set the number of rows/columns that are displayed

1 On the upper right of any page, click your user name, and then select Preferences from the drop-down list. By default, the General preferences page is displayed.
2 From the left, select Grid display. The Grid display preferences page opens.
3 In the Maximum rows in grid field, enter the maximum number of rows you want to see on your report. The maximum number of rows you can set is 9,999.
4 In the Maximum columns in grid field, enter the maximum number of columns that you want to see on your report. The maximum number of columns you can set is 9,999.
5 Click Apply to save your changes.

The Maximum rows and columns settings specified above can be overridden by a setting in MicroStrategy Developer called Maximum number of XML cells. For more information, contact your administrator.

To search for an object to add to the report

* To add an object to the report, you must have the necessary Web Professional privileges to create a report.
1 Hover your cursor between the columns where you want to add the object. A pop-up Search field is displayed.
* If a pop-up Search field is not displayed, the Search from report grid view option is disabled. An administrator can enable the Search from report grid view option.
2 By default, all attributes, consolidations, custom groups, hierarchies, and metrics are searched. To change which types are searched, do the following:
a Click the Search icon Search icon to display a list of object types, as shown below:
List of object types to search
b Select the object types to search.
c Click in the Search field to close the object type list.
3 Type the object name in the Search field, and then select from the results. The selected object is added to the report between the columns.

Related topics

Viewing a report in Graph view
Viewing a report in Grid and Graph view
Maximizing your view of a report: Full Screen mode