Copying data from a grid report

You can copy data from a grid report, including cells, rows, or columns of data, to the clipboard. You can then paste the copied data into a non-MicroStrategy program. You can copy data from a grid report or from a grid report displayed in a document.

For example, the revenue for the Books category is selected in the grid displayed below:

Category and Revenue report, with Books revenue selected

Press CTRL+C, and the data is copied to the clipboard. You can now paste it into another application, such as Notepad or Excel, as shown in the image below.

Notepad, displaying the copied revenue amount ($2,640,094)

If your grid contains attributes with merged row headers, you can select a single row of data from within a merged row. To do so, click the cell of the right-most attribute element in the row. For example, in the image below, you can click the Books cell to copy sales information only for Books in the Mid-Atlantic region.

Example of copying a single row of data in a grid report

To copy data from a grid report

1 Click the name of a report to execute it.
2 To switch to Grid view, click the Grid icon Grid icon on the toolbar.
3 Select the data to copy. You can select an entire row or column of data by clicking the header of the row or column. You can select multiple rows, columns, or cells by pressing CTRL and clicking additional data in the grid.
4 Press CTRL+C. The selected data is copied to the clipboard.

To copy data from a grid report on a document

1 Open the document in Presentation Mode or Editable Mode.
2 If the report is not displayed as a grid, do one of the following:
In Presentation Mode, click View: Grid View: Grid icon, at the top left of the report. If the icon is not displayed, the document designer has not enabled switching views.
In Editable Mode, right-click the report, point to View Mode, and select Grid View.
3 Click anywhere outside of the grid so that the grid is no longer selected.
4 Select the data to copy. You can select an entire row or column of data by clicking the header of the row or column. You can select multiple rows, columns, or cells by pressing CTRL and clicking additional data in the grid.
5 Press CTRL+C. The selected data is copied to the clipboard.