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. 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 under 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

Setting the number of rows/columns that are displayed

  1. Select Preferences at the top of the page. The Preferences page opens. On the left, select Grid display. The Grid display preferences page opens.

  2. 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.

  3. 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.

  4. Click Apply to save your changes.

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

Related topics