MicroStrategy ONE

Exporting a report to Microsoft Word

  1. Run the report to export. (For steps to run a report, see Running a report.)

  2. If you want to configure export options, complete the following steps:

    1. From the Data menu, choose Export Options. The Export Options dialog box opens.

    2. Select MS Word Document from the Application drop-down menu. The options for exporting the report to a Microsoft Word document are displayed.

    3. Click the General tab.

    4. To automatically open the report in Word after you export the report, select the Show application after exporting check box.

    5. If you send a report to your History List with the Export this report automatically check box selected, and then read the report from your History List, the report is automatically exported to Word.

    6. To export the report with all the page-by fields expanded, select the Expand all page fields when exporting data check box.

    7. Type the File name to export the report to.

    8. Type the Bookmark to export the report to.

    9. To specify a macro to run before exporting the report, enter the macro in the Pre-macro field.

    10. To specify a macro to run after exporting the report, enter the macro in the Post-macro field.

    11. To specify additional general, formatting, error handling, and location options, click Advanced Options. For more information on these options, see Advanced Options for Exporting to Word.

    12. Click the Appearance tab.

    13. Select which report elements (such as title, details, data, headers, and SQL) to export from the Exported fields list.

    14. To define the order that the report elements are exported, select a report element in the Exported fields list, and click Up or Down to move the selected element.

    15. To format the exported report as the grid report displays in MicroStrategy, select the Apply formatting check box.

    16. Click OK to return to the report.

  3. On the Data menu, point to Export To, then choose MS Word.

If you want the system to use the same the file name and destination location, or other export options, each time you export a file, you can enter this information in the My Preferences area of MicroStrategy Developer. For details, see My Preferences dialog box: Reports tab, Export Options.