The Export Reports preferences page allows you to specify exporting preferences. Here, you can select the way that you want to export grid reports, graph reports and HTML documents. For details to set preferences for Reports Services documents, see Report Services preferences.
When you export a report, you move a copy of the report into some other software, such as Microsoft Excel, Adobe PDF, or a simple text file.
Select Preferences at the top of any page, and then click Export Reports. The following options are available:
Export: From the drop-down list, select either Whole report to export the entire report or Portion displayed only to export only the portion of your report displayed on your browser. This is a useful option if you commonly view reports with many pages and only want to export the page you are viewing.
Export grids to:
Excel with plain text (default): The report is exported and displayed as a Microsoft Excel spreadsheet, which contains only the text of the grid report. The spreadsheet does not retain the formatting of the report as displayed in MicroStrategy Web.
CSV file format: The report is exported as a CSV file. The contents of the grid report are displayed, separated by commas.
Excel with formatting: The report is exported and displayed as a Microsoft Excel spreadsheet. The spreadsheet retains the formatting of the report as displayed in MicroStrategy Web, such as colors, fonts, and structure.
HTML: The grid report is exported to an HTML file.
Plain text: The contents of the grid report are exported to plain text, and the Delimiter you specify separates data from each cell of the report.
Export graphs to:
Excel with formatting: The graph report is opened in the version of Excel you specify in the Excel version drop-down list below.
HTML (default): The graph report is exported to an HTML file.
Export HTML documents to:
HTML (default): The HTML document maintains its format, color, and structure when exported to an HTML file.
Excel without formatting: Only grids from the HTML document are exported to plain text, giving users access to the data within the grid reports. Graph reports in HTML documents are not exported to Excel.
Export Report Title: The title of the report is included in the exported information. This check box is selected by default.
Export Page-By Information: If the report has objects in the page-by field, the objects in the page-by field are included in the exported information. This check box is selected by default.
Export filter details: Choose whether or not to export the filter details of the report. If you choose to export them, they appear above the exported report. This check box is cleared by default.
Export Header and Footer: Specify header and footer details by clicking Edit Custom Settings.
Edit Custom Settings: Click Edit Custom Settings to edit the header and footer settings. Type text in the Header and Footer fields, or select auto-text to insert from the Insert Auto-text drop-down list. For detailed steps to edit the header and footer and more information about auto-text, see Specifying the header and footer for a report. The export header and footer can also be included as part of a subscribed report. For more information, see the Web Administrator Help.
Remove extra column: Determine whether or not the column that displays the word "Metrics" is displayed on the exported report.
Yes: The word "Metrics" is not displayed.
No: The word "Metrics" is displayed.
Automatic (default): The report-level setting for the feature is applied. For steps to determine whether the Metrics column is displayed at the report level, see the Basic Reporting Guide.
Expand all page-by fields: Determine whether or not to export all objects in the page-by drop-down lists when exporting a report. To export only the objects currently selected in the page-by field (default), clear this check box. For an introduction to page-by, see Grouping data by page: Page-by.
Excel options
Excel version: Specify which version
of Excel is used to export reports and documents. The version you specify
determines how version-specific situations, such as European symbol formatting,
are handled in Excel. The version of Excel you select also determines
whether the export settings at the report level are considered or not.
The options are:
Note: The Excel 2000 option is only available if the supported
Excel version was previously specified as Excel
2000.
Excel 2000
Excel XP/2003 (default)
Excel 2007 or newer versions (compatible with Office for Mac)
Export metric values as text: Determine whether numeric values should be exported as text or as numbers. If you choose to export metric values as numbers, Excel may automatically format the number. For example, $34.23614 may be rounded to $34.24 in Excel. If you choose to export metric values as text, Excel will not automatically format the numbers. This setting only applies to exports to Excel. This check box is cleared by default.
Export headers as text: Determine whether header values should be exported as text or in their current format, which could be numeric, date, and so on. This setting only applies to exports to Excel. This check box is cleared by default.
Excel with formatting options
Place each page on a separate sheet: Determine whether each page of your report will be placed on its own Excel sheet. This check box is cleared by default.
Always export graphs as live Excel charts: Determine whether graph reports are exported as Excel charts on which you can perform Excel manipulations, just as you can on any graph in Excel. If you do not select this check box, graphs are exported to Excel as bitmaps. This check box is cleared by default.
Embed images: Determine whether exported
graphs and images from the report are included in the Excel spreadsheet
as images. If this check box is selected, the images and graphs can be
accessed from the spreadsheet without having to run MicroStrategy Web.
This check box is selected by default.
Note: Live charts are supported by all versions of Excel.
Only Excel XP or later versions support embedded images.
Allow MicroStrategy Office to refresh Reports after exporting: If you have the MicroStrategy Office product, determine whether MicroStrategy Office has the ability to refresh reports and documents after they have been exported to Excel. This setting only applies to exports to Excel with formatting.
Show options when exporting: Determine whether the Export Options page opens each time you export a report. This allows you to easily change export settings for each report you export, such as which format you want to export to. To automatically export reports with the settings specified on this page, clear this check box. This check box is cleared by default.
From the drop-down list at the bottom of the page, apply the changes to the current project or all projects you have access to that are stored on the Intelligence Server and then click Apply.
Warning: Clicking Load Default Values will reset all of your preferences settings.
Related topics