Express Report Export

To export a report to an external format, select the required format in the Express Report > Save As item in the submenu of the main menu:

NOTE. The formats PPEXPRESS, PPCUBE, PPMOBILE are internal formats of Foresight Analytics Platform and are used to load reports to a local file to further work with them without connecting to the repository.

The Export to File dialog box opens. Determine path and name of the file in the dialog box.

NOTE. Only visible express report objects are exported. A warning appears during the export process if some objects are not compatible.

To export multiple versions of the report formed by the selection of fixed dimensions, use batch export.

Export Features

Depending on express report settings the following export features can be determined:

NOTE. On export of report the output file may contain the stamp No. 1 according to the Guidelines No. 0126-87, if mandatory access control is used as a security policy and export and print labeling is enabled for the security level of this express report.

On exporting to XLS and XLSX format before the Export to File dialog box the Export Options to <format> dialog box opens:

Set the options in the dialog box:

Expanders. By default the checkbox is deselected. When the checkbox is selected, the displayed expanders in the current view of express report table are exported. If expanders are collapsed then all nested table elements and expanded/collapsed expanders are exported. Expanders are available for Microsoft Excel tools.

NOTE. The option is available only on exporting to XLSX format.

Chart as Image. The checkbox is selected by default. Select the Charts as Images checkbox to export a chart as image to the EMF format, and be able to work with it only as with image using Microsoft Excel tools. Deselect the checkbox to export a chart as an object and work with it as with a chart using Microsoft Excel means.

NOTE. Chart types, which do not support XLS and XLSX formats are exported as images. When exporting waterfall chart the chart type will differ from the source one due to mismatching settings. An object is exported to XLSX as a chart, to XLS - as an image.

To export the selected sheets, select the Selected Sheets radio button.

The output file contains each express report object on a separate sheet. If a data table is hidden, and a chart is visible, in the export file the sheet with the data table will be hidden, and a corresponding message will appear.

Expanders export features:

If the table heading or sidehead contains more than one hierarchical dimension then expanders will be exported only for the first dimension located in the first table column or row. If expanders are hidden for the first dimension, then displayed expanders of the next dimension are exported.
If the table heading or sidehead contains several merged dimensionsthen expanders are exported only for the first column or row taking into account the merge. If the first dimension contains several levels which are located in several columns or rows then only zero level expanders are exported.

Conditional formatting of cells is exported with the following restrictions:

Conditional formatting is supported only by Microsoft Excel 2007 or later.
Some designations in the output file may differ from designations used in the express report.

If the express report includes a column that contains a legend, in series mode this legend is exported to XLS and XLSX as shapes.

When the mandatory access control mode is active, and the print marking is enabled, the first line of the report contains a security label.

The report in the PDF format in the output file looks the same as the previewed express report.

If maps and charts located on the report sheet do not contain unsupported settings for export to the PDF format (dashed lines, alpha channel), they are exported to PDF as vector images. Otherwise they are exported as bitmap images.

On exporting to this format remember that:

Cell texture may not be the same in the output file and in the express report.
Symbols of chart data series legend may be displayed differently in the output file and in the express report.
Data series names may not be displayed fully in the legend.
Chinese or Arabic characters may not be displayed fully or correctly.
Depending on the selected font the text written in Russian with use of italic style may not be correctly displayed.

Exporting to the PPTX format opens the Options of Export to PPTX dialog box before the Export to File dialog box:

Select the Charts as Images checkbox to export a chart as image to the EMF format, and be able to work with it only as with image using Microsoft Excel means. Deselect the checkbox to export a chart as an object and work with it as with a chart using Microsoft Excel means. The checkbox is selected by default according to the settings of the previous export.

To export the selected sheets, select the Selected Sheets radio button.

On exporting the express report containing cell formatting, only one formatting type with the following priority will be loaded:

Image.
Conditional formatting.
Cell fill.

Exporting to the HTM or MHT format opens the Options of Export to HTML or Options of Export to MHT dialog box before the Export to File dialog box:

To export the selected sheets, select the Selected Sheets radio button.

Selecting the Cells Auto Height checkbox enables the user to perform autofit the cell height on exporting in accordance with the information they contain.

When the user exports to HTML, the set scale is taken into consideration during export, that is, the report in the HTML format looks the same as the objects located in the data area.

On exporting an express report to one of the specified formats the dialog box opens:

Choose a saving option in the The Volume of Stored Data area:

Displayed Data Only.
All Existing Data (may take long time).
Select Data to Save. In this case select dimension elements that are required to be saved.

By default, selection coincides with selection in the express report. Data is saved only by the selected dimension elements and the report chart and map are also saved.

NOTE. Export to the PPEXPRESS or PPCUBE file format is unavailable, if data source dimension contains a calculated element.

	XLS, XLSX	PDF	RTF	HTML	MHT	EMF	PPEXPRESS	PPCUBE	PPTX
Headers and footers
Table legend
Wrap text
Top and bottom cell margins
Footnotes connected by the Fore language
Sparklines