How to Copy 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:

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.

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.

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 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. In Presentation Mode, click View: Grid , at the top left of the report. If the icon is not displayed, the document designer has not enabled switching views.
3. In Editable Mode, right-click the report, point to View Mode, and select Grid View.
4. Click anywhere outside of the grid so that the grid is no longer selected.
5. 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.
6. Press CTRL+C.