Overview
Version
| Report Server Version | Functional Change |
|---|---|
11.0.5 | Optimized two scenarios (Large Dataset Export by JS and Large Dataset Export Plugin):
|
Function Description
This document introduces solutions for exporting large dataset templates, especially exporting high-volume data templates to Excel files, which consume significant memory. In scenarios with both high-volume data and high concurrency, there is a high risk of server memory overflow, or the export page may freeze when the data volume is too high, making export impossible. Therefore, different methods should be adopted for high-volume data templates based on business requirements.
Note:Export Solution Comparison
| Solution | Description | Advantage/Disadvantage |
|---|---|---|
| (1) The file generated after export can be renamed. You can select all or partial fields from the dataset for export, and configure conditions on the parameter panel to export corresponding data. (2) CPT and CPTX are supported. (3) The export results are Excel files. Note: | (1) Advantage:
(2) Disadvantage:
|
| (1) You can export data corresponding to dynamic columns, and you can configure conditions on the parameter panel to export corresponding data. JS export offers the most flexibility. (2) CPT instead of CPTX is supported. (3) The export results are Excel files. Note:CPTX templates refer to reports created using the new calculation engine in the original FineReport 10.0 version. | (1) Advantage:
(2) Disadvantage:
|
Large Dataset Export with the New Calculation Engine Enabled
| (1) You can choose which of the datasets to export, but you cannot specify which fields within the dataset to export. You can configure conditions on the parameter panel to export corresponding data. (2) CPT and CPTX are supported. Note:CPTX templates refer to reports created using the new calculation engine in the original FineReport 10.0 version. (3) The export results are Excel files. | (1) Advantage:
(2) Disadvantage:
|
Exporting High-Volume Data Reports to Excel (Row-based Engine Enabled) | (1) When the row-based engine is enabled for exporting high-volume data reports to Excel, a report is split into multiple XLS files, and the files are transmitted to the client in a compressed package format. (2) The export to the XLS format is non-streaming export, which consumes more memory. However, after the Streaming Export to Excel (Row-based Engine) Plugin is installed, reports can be exported as XLSX files (namely, streaming export). Note: | (1) Advantage:
(2) Disadvantage:
|
/ | Advantage:
|
Note:1. For the comparison of exports with and without the row-based engine enabled, see Exporting High-Volume Data Reports to Excel (Row-based Engine Enabled).
2. For Layered Reports in a Multi-Dataset Template, pagination export, unaltered export, and pagination export by sheet can only export data from the current page.
Export Interaction Optimization
For 11.0.5 and later versions, the export process for Large Dataset Export by JS and Large Dataset Export Plugin has been optimized.
During the export, if an error occurs, an error message window will pop up. The pop-up window content includes the title, error code, error details, and error stack.
Note:(1) If you click the Exit button, the export will be terminated, and the preview page will be displayed.
(2) If no click operation is detected for a long time, a window with the message "Timeout occurs. Refresh the page and export data again." will pop up when you click the page again after the timeout. In this case, clicking OK or the X icon will refresh the current page.
Note:
Previous：Large Dataset Export Plugin
