Exporting to Excel
To export the results of a report to an Excel file, follow the steps below:
- Open the report that you want to export.
- Select File > Export > To Excel. The Export to Excel dialog appears.
- Select the Browse button to specify the destination directory where the exported Excel file will be placed, or type the destination directory into the Directory text field directly (make sure that the folder you specify here does exist).
- Specify the name of the exported Excel file in the File Name text field. If you do not type the name, Logi JReport will use the report name as the Excel file name by default.
- If you are exporting a page report, in the Select Report Tabs box, select the report tabs in the page report you want to export. The selected report tabs will be exported into multiple sheets of the Excel file in the list order. You can select or to change the order or the report tabs.
- From the Excel Version drop-down list, select the version for the exported Excel file.
- Specify the format of the exported Excel file.
- To make the format of the result file match the format as designed in the template, check Report Format, and then specify the available settings according to your requirements.
- To export the report results to a general Excel file, check Column Format, in which case, you can set the Columned property value for the report tab in the Report Inspector to decide the calculation method used for all components' row/column values in the report when exporting (due to the particularity of mailing label report, do not set the Columned property to true when you want to export it in this format).
- To export only the report data without format, check Data Format. This option is only available for the Excel version Excel 97-2003 Workbook (*.xls).
- Check Run Linked Report if you want to include the reports that is linked with the report (not including the detail reports) in the exported Excel result. If you are only interested in the primary report, leave this option unchecked. Generating linked reports at the same time, especially when the linked reports contain a large amount of data, will cause performance issue.
- When done, select OK to start exporting.
- Multiple colors and languages in a report can be exported to an Excel file, but multiple pie charts and the arc drawing object cannot be. For example, Excel only supports 56 kinds of colors, if there are more than 56 kinds of colors in a report, when you export the report to Excel, some colors will be merged.
- When exporting a report to Excel,
- Paragraphs and texts in the report will be exported as objects.
- If the data type of the field on the category axis of a chart is Date, DateTime or Time whose format confirms to the date format of the Excel, the axis will be exported as a date axis, otherwise, it will not be exported as a date axis.
- Gauge and surface chart in the report will be exported as bar chart while stock chart will be exported as image.
- The minor tick marks on a chart will not be exported.
- If the field on the category axis of a chart is of Number type and you use a constant interval to customize the tick marks on the axis, the settings will not take effect.
- If the report contains a drop-down list, only the value selected in the list will be exported.
- If you set an object's Export to Excel property to false, the object and other objects contained in it will not be exported.
- When Data Format is selected in the Export to Excel dialog, formulas, barcodes, images, HyperLink property, charts and all drawing objects will not be supported, therefore, we recommend not using this format when exporting report results to Excel.
The following topics are related to exporting the report results to Excel:
- Setting the Excel Buffer Size
- Setting the Maximum Number of Rows for Every Worksheet
- Setting the Excel Column Width
- Realigning Objects for a Better Appearance in the Exported Excel File
- Specifying Subreport Location in the Exported Excel File
- Controlling Banded Object Panels in the Exported Excel File
- Improving the Performance of Exporting to Excel