Export
Through this series of menu items, you can export certain report data to Excel, Word, PDF, Text, XML and HTML, and then perform operations on the result file.
Export a report as an unpaginated Excel file.
Under the preview status, click File -> Export -> Excel file to get into the “Open” dialog, where you select a location for saving the target Excel file and enter a file name, as figure 1.2.10.1-1 shows:
Click “Open” button to export information of the report under preview to an unpaginated Excel file. By exporting a report displaying employee information to an Excel file, the export effect is as follows:
Paginated Excel
This menu item lets you export a report to a paginated Excel file.
Under the preview status, click File -> Export -> Paginated Excel to get into the “Open” dialog, where you select a location for saving the target Excel file and enter a file name. As figure 1.2.10.1-1 shows, click “Open” button to export information of the report under preview to a paginated Excel file.
By exporting a report displaying employee information to a paginated Excel file, the export effect is as follows:
Excel with Formula
This menu item lets you export a report to an Excel file with formulas.
Under the preview status, click File -> Export -> Excel with Formula to get into the “Open” dialog, where you select a location for saving the target Excel file and enter a file name. As figure 1.2.10.1-1 shows, click “Open” button to export information of the report under preview to an Excel file with formulas.
●Under this menu item, formulas that Excel does not support cannot be exported and paginatation isn’t supported.
This menu item lets you export a report to a Word file.
Under the preview status, click File -> Export -> Word file to get into the “Open” dialog, where you select a location for saving the target Word file and enter a file name and its extension. As figure 1.2.10.2-1 shows, click “Open” button to export information of the report under preview to a Word file.
This menu item lets you export a report to an unpaginated PDF file.
Under the preview status, click File -> Export -> PDF file to get into the “Open” dialog, where you select a location for saving the target PDF file and enter a file name. As figure 1.2.10.3-1 shows, click “Open” button to export information of the report under preview to a PDF file.
By exporting a report displaying employee information to an unpaginated PDF file, the export effect is as follows:
Paginated PDF
This menu item lets you export a report to a paginated PDF file.
Under the preview status, click File -> Export -> Paginated PDF to get into the “Open” dialog, where you select a location for saving the target PDF file and enter a file name. As figure 1.2.10.3-1 shows, click “Open” button to export information of the report under preview to a paginated PDF file.
By exporting a report displaying employee information to a paginated PDF file, the export effect is as follows:
This menu item lets you export a report to a text file.
Under the preview status, click File -> Export -> Text file to get into the “Open” dialog, where you select a location for saving the target text file and enter a file name. As figure 1.2.10.4-1 shows:
Click “Open” button to pop up the following “Export-to-text Options” dialog:
If you want to export a text file showing gridlines in the background, check “Text with border line” option. By doing this, the “Separator” drop-down list and “Data” box turn gray.
For an exported text file without showing gridlines, select in the “Separator” drop-down list the separator for separating cells in the report file, and the exported text file will use the selected separator. The available separators are “Tab”, “Comma”, “Semicolon”, Hash” and “Asterisk”. In “Data” box, select whether you want to show “Displayed Value” or “Real Value” for the exported data. Then click “OK” button to export information of the report under preview to a text file format.
This menu item lets you export a report as an .html file format.
Under the preview status, click File -> Export -> HTML file to get into the “Open” dialog, where you select a location for saving the target HTML file and enter a file name. As figure 1.2.10.5-1 shows, click “Open” button to export information of the report under preview to an HTML file.
By exporting a report displaying employee information to an HTML file, the export effect is as follows:
This menu item lets you export a report as an XML file.
Under the preview status, click File -> Export -> XML file to get into the “Open” dialog, where you select a location for saving the target XML file and enter a file name. As figure 1.2.10.6-1 shows, click “Open” button to export information of the report under preview to an XML file.
By exporting a report displaying employee information to an XML file, the export effect is as follows:
Office2007
Items on this menu are used to export reports as office2007 Excel file format. Refer related details in Excel file, Paginated Excel and Excel with Formula items.