MicroStrategy ONE

Exporting a report to a text file

  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 Text File from the Application drop-down menu. The options for exporting the report to a text file are displayed.

    3. Click the General tab.

    4. To automatically open the text file 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 a text file.

    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 table name to export the report to in thePass file to field.

    9. 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 a Text File.

    10. Click the Appearance tab.

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

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

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

    14. Click OK to return to the report.

  3. On the Data menu, point to Export To, then choose Text File.

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.