To work with the tool in Foresight Analytics Platform 10, use the new interface.
Reports allow for exporting selected data or the entire report. To export data to XML, CSV and other formats, use ETL task data consumers, and to export the entire report to external formats, select the Report > Export main menu item and select the required format:
Excel Workbook (*.xlsx).
Excel 97-2003 Workbook (*.xls).
PDF Document (*.pdf).
RTF Document (*.rtf).
PowerPoint Presentation (*.pptx).
Web Page (*.html).
Web Page, single file archive (*.mht).
OpenDocument Spreadsheet (*.ods).
Image (*.emf).
Regular Report (*.ppreport).
NOTE. The PPREPORT format is an internal format of Foresight Analytics Platform and it is used to load reports to a local file to further work with them without connecting to the repository.
A dialog box for entering export parameters opens after external file format is selected.
The controls on this dialog box change depending on the file type of the export, but the following radio buttons are always available:
Entire Report. If this radio button is selected, the entire report is exported.
Selected Sheets. If this radio button is selected, select checkboxes of the sheets to export. Hidden sheets are not included in the list.
NOTE. When exporting to XLS and XLSX, the Selected Sheets list contains hidden sheets if the Hidden Sheets checkbox is selected in the Options of Export to XLS dialog box.
To export multiple versions of the report formed by the selection of fixed dimensions, use batch export.
On export of reports to various formats consider the following features:
XLS, XLSX | RTF | HTML, MHL | ||
Export from the web application | ||||
Headers and footers | ||||
Hyperlinks | ||||
Marking stamps | ||||
Icons in cells are connected to by the Fore language | ||||
Footnotes connected by the Fore language |
ODS | EMF | PPTX | PPREPORT | |
Export from the web application | ||||
Headers and footers | ||||
Hyperlinks | ||||
Marking stamps | ||||
Icons in cells are connected to by the Fore language | ||||
Footnotes connected by the Fore language |
Conventions:
- report export is available.
- report export is unavailable.
The following export features can be distinguished depending on regular report settings:
If the Print Cell checkbox is deselected for the cells, on export to XLS, XLSX, PDF, or HTML the text, icons and hyperlinks stored in the cell, along with cell background settings, are not exported.
Headers and footers that were set up for the report are exported to all formats except for HTML and ODS:
One can work with headers and footers in the output XLS and XLSX file using Microsoft Excel tools (Page Settings > Headers and Footers).
If headers or footers for even, odd pages and the first page are set up, after export to ODS and XLS (for versions earlier than 2007) the settings determined for the header and footers in odd pages are applied to those on the first page.
If sections of report header and footer contained images on exporting to RTF, then:
If header or footer contains empty sections, adjacent sections are stretched out to take place of empty sections.
If the central section is empty and side sections are not empty, the image stored in the right section is stretched out.
If a report sheet is exported to PDF and RTF and the Print Sheet with Report checkbox is deselected for it in page settings, the sheet is not exported.
NOTE. If export is executed when the non-printed report sheet is opened, only this sheet is available for export.
A sheet with connected plugin is not exported.
The output file look depends on the defined page settings.
To export hyperlinks to HTML or PPTX, use the Fore language to set the IPrxReportExporter.ExportHyperlinkOpenURLAction property to True.
When exporting to XLSX, a text block is exported to an object of the Label type. When exporting to other formats, it is exported as an image.
On exporting to RTF, footnote numbers are ordered by sheets: from the first to the last.
On exporting to XLS or XLSX, footnotes are not exported by default. Footnote numbers are exported if the appropriate setting is determined by means of the Fore language. Footnote text is not exported.
Format of the cells containing footnotes is changed to text one. In this case:
The chart look may differ from that in the original report.
Formulas, for which footnotes are set, are displayed as text.
Formulas, which refer to cells with footnotes, are not calculated.
NOTE. When a report is printed and exported, the output file may display stamp No. 1 according to the No. 0126-87 Guidelines if the mandatory access control is used as the security policy, and export and print labeling is enabled for the security level.
See also:
Getting Started with the Reports Tool in the Web Application | ImageList | Regular Report Batch Export | Working with Ready Report