Overview
Version
Report Server Version | Functional Change |
11.0.5 | Normal reports may be exported as blank images due to internal network problems and other reasons. In FineReport V11.0.5 and later versions, the export returns an image with a prompt, rather than a blank one. |
11.0.6 |
|
Functions
You can export templates in the FineReport designer, in browsers, or in API interfaces.
General Report Export
1. The adaptive function is not supported in the general report export. 2. You are not advised to export general reports as PDF files or images in jdk1.8.0_262, jdk-8u231, and jdk1.8.0_192 versions through the export function.
Export Method
Export Method | Introduction | Document |
Designer Export | Directly export templates through visual operations in the designer with no need to preview templates. | |
Browser Export | Export templates as files in various formats after previewing templates on the Web. Logic: Select the format of the exported file, generate the page content in the server memory based on the report content, and directly push it to the client through serverlet.
| |
API Export | Export in the program through exporting the API. | / |
URL Export | Add the format parameter after preview the report URL and directly export through URL by assigning an export format. | |
Custom Export Button | Export by integrating Web pages and customizing Web page buttons. |
Exporting to Excel Files
Classification | Introduction | Document |
Built-in export solution | Pagination Export Unaltered Export Page to Sheet Export | |
Export format | Excel (2007) files | / |
Excel (2007/2003) files | ||
Export style | Keep hyperlinks during export. | / |
Keep formulas during export. | ||
Keep hidden rows and columns during export. Set passwords during export. | / |
Exporting to Files of Other Formats
Export format | Introduction | Document |
Export to Word files. | Export headers and footers to Word files. | |
Automatically adjust line height during export. | ||
Export to PDF files. | Merge multiple templates into one PDF file and export it. | / |
Set passwords during export. | ||
Export to PPT files. | Export to PPT files. | / |
Export to CSV files. | Export to CSV files. | / |
Customize the encoding formats of the exported CSV files. | / | |
Export to image files. | Export to image files. | / |
Export to HTML content. | Export templates containing HTML statements by users. | / |
Export to text files. | Exported files are text files. |
Dashboard Export
Introduction | Document |
Export dashboards to Excel, PDF, Word, and image (in PNG, JPG, GIF, and BMP formats) files. | |
Export dashboards to PPT files. Merge multiple templates into one PPT file and export it. | / |
Export single report block in dashboards. | / |
Big Dataset Export
Batch Export
Introduction |
Batch export multiple general reports. |
Batch export specified subtables. |
Filter data from the current table and export separately to multiple files. |
Simultaneously export multiple general reports to a certain format. |
Merge multiple CPT templates and export them to one Excel file. |
Custom Export
Introduction | Document |
Customize file names of the exported general reports. | |
The file names of the exported general reports change dynamically according to the value of the filter box. | / |
Export general reports to Excel files with groups and sheets. That is, the report format is the same on each sheet page, but the content is different. | / |
Select a report to download in the specified general reports and customize the exported file name. | / |
Introduce APIs for exporting reports. Users can customize the export. | |
Export to files with only one format through custom buttons. | / |
Functional Change
1. FineReport V11.0.5
Normal reports may be exported as blank images due to internal network problems and other reasons. In FineReport V11.0.5 and later versions, the export returns an image with a prompt, rather than a blank one.
A prompt pops up: "Error code: 11100028; Image export failure: network reason. You can view error details in the log."
2. FineReport V11.0.6
If a cell includes rich texts, the rich text font is exported.
After you set the rich text in the cell and click OK, the font size displayed in the cell is consistent with the maximum font size of the rich text.
Exporting HTML Content
1. If a cell content is HTML, the font set in HTML should be consistent with Font under Cell Attribute > Style. Otherwise, the upper half of the text may not be displayed after you export HTML content to Word files. 2. If a cell content is HTML, the backend does not separately process color attributes for strikethroughs and underlines, which have the same color as the font. 3. If the export function is used with the performance optimization function enabled, HTML statements that are not supported in templates are displayed as string HTML statements in the exported PDF files.
Notes
1. If you export templates to Word files, a maximum of 63 table columns is allowed. Otherwise, the template content of the exceeding part is lost.
2. After the table font in a template is bolded, exporting it to an image results in a file size twice as large as the original one. If the image size is limited in your network, you may fail to download the image.
3. If there is a barcode set in the exported template, you need to ensure that the height of the cell where the barcode is located is greater than or equal to 6 millimeters. Otherwise, the text below the barcode may be obscured after export.
4. You need to note the following two aspects when exporting templates with sheet names to Excel files:
The sheet name cannot exceed 31 characters. Otherwise, the sheet name is automatically truncated during export, which may result in two same sheet names and export errors.
Sheet name can include English, Chinese characters, |, and (). It cannot include :, /, ?, *, and [].
Advanced Export
Comparison Item | Current Plan | New Plan |
Plan overview | Some business personnel within a company need to export data by connecting to the business system through FineReport for data filtering and analysis. To meet the above needs, business personnel need to export online data to offline. | Integrate with the business system through FineDataLink, process raw data, and load the data result wide table into FineBI public datasets. Business personnel can directly perform self-service analytics through the result wide table. |
User experience | Low data security and high operational costs for business personnel | High data security and accuracy and low operational costs for business personnel |