Overview
Version
| Report Server Version | Functional Change |
|---|---|
11.0.5 | Resolved the possible problem that the report preview is normal, but the exported images are blank due to some reasons (such as intranet issues) during data export. In FineReport of 11.0.5 and later versions, images with prompt messages, instead of blank images, will be returned as the export result. |
11.0.6 | Exported the rich text font when the cell content was rich text. Allowed the font size of text displayed in the cell to follow the maximum font size of the rich text after you set the cell content to rich text and clicked OK. |
Function Description
FineReport allows you to export templates both in the designer and in browsers.
Note:General Report Export
Note:1. Exported general reports do not support automatic adaptation.
2. You are not advised to export general reports to PDF files or images by the export function in FineReport with jdk1.8.0_262, jdk-8u231, or jdk1.8.0_192 installed.
Export Method
| Export Method | Description | Help Document |
|---|---|---|
Designer export | You can directly export the template through visualized operations in the designer without previewing the template. | |
Browser export | Overview: You can export a template to files of various formats when previewing the template on a web page. Principle: After you select the desired export format, the file content is generated in the server memory based on the report content and is directly pushed to the client through Servlet. Note: | |
Direct URL export | You can suffix the report preview URL with the format parameter to assign an export format, achieving direct URL export. Note: | |
Custom export button | You can customize an export button on the web page to achieve the export function through web page integration. |
Export to Excel
| Classification | Description | Help Document |
|---|---|---|
Built-in export solution | Pagination Export Unaltered Export Pagination Export by Sheet | |
Export format | Export to Excel 2007 | / |
Export to Excel 2003 or Excel 2007 | ||
Export style | Retaining hyperlinks during export to Excel | / |
Retaining formulas during export to Excel | ||
Retaining hidden rows and columns during export to Excel Setting passwords during export to Excel |
Export to Other Formats
| Export Format | Description | Help Document |
|---|---|---|
Export to Word | Exporting a template together with the set headers and footers to Word | |
Automatic row height adjustment during export to Word | ||
Export to PDF | Merging multiple templates and exporting them to one PDF file | / |
Setting passwords during export to PDF | ||
Export to PPT | Export to PPT | / |
Export to CSV | Export to the CSV file | |
Customizing the encoding format of the exported CSV file | / | |
Image export | Export to images | |
HTML content export | Exporting a template containing HTML statements | / |
Export to a text file | Exporting a template to the text file |
FVS Template Export
For details, see FVS Template Export.
FRM Report Export
| Description | Help Document |
|---|---|
Exporting FRM reports to Excel, PDF, and Word files, or images (PNG, JPG, GIF, and BMP) | |
Exporting a single report block from an FRM report | / |
Big Dataset Export
Batch Export
| Description | Help Document |
|---|---|
Exporting multiple general reports in batches | |
Exporting specified subtables in batches | |
Filtering data in the current table and exporting result data to multiple files respectively | / |
Exporting multiple general reports simultaneously in a certain format | / |
Merging multiple CPT templates and exporting them to one Excel file | / |
Custom Export
| Description | Help Document |
|---|---|
Customizing file names after exporting general reports | |
For general reports: names of the exported files dynamically changing with the values of the filter box | |
For general reports: grouped export by sheet during export to Excel (namely, the same report format but different contents in each sheet) | |
For general reports: selecting the report to be downloaded from specified reports, and customizing the name of the exported file | / |
Report export APIs, which can be used for custom export | |
Exporting reports in only one file format through a custom button | Exporting Reports in Only One File Format Through a Toolbar Button by JS |
Functional Change
(1) Version 11.0.5
During export, you may encounter the problem that the report preview is normal, but the exported images are blank due to some reasons (such as intranet issues). In FineReport of 11.0.5 and later versions, images with prompt messages, instead of blank images, will be returned as the export result.
For example, the message "Error code: 11100028. Image export failed due to network reasons. You can view error details in the log." is displayed.
The following figure shows an image with a prompt message.
(2) Version 11.0.6
(1) When the cell content is rich text, the exported font will be the rich text font.
(2) After you set the cell content to rich text and click OK, the font size of text displayed in the cell will follow the maximum font size of the rich text.
HTML Content Export
The precautions are as follows:
(1) If the cell content is the HTML code, the font set by HTML code should be consistent with that set under Cell Attribute > Style > Text > Font. Otherwise, the upper half of text may not be displayed after the HTML content is exported to a Word file.
(2) If the cell content is the HTML code, during the export, the backend will, rather than separately processing the extra color attributes (if any) of strikethroughs and underlines, directly process them in the same color as that of text.
(3) If the export function is used with performance optimization enabled and the export format is PDF, unsupported HTML statements in the template will be displayed as HTML strings in the PDF.
Precautions
The following points should be noted for template export:
(1) If the template will be exported to Word, the maximum number of columns of the table in the template cannot exceed 63. Otherwise, content exceeding the 63rd column will be lost.
(2) If the table text in the template is bolded, and the template is exported to an image, the size of the exported image after bolding will be twice that before bolding. Therefore, the image after bolding may not be downloadable if the image size is limited on your network.
(3) If a barcode exists in the template to be exported, ensure that the cell where the barcode is located is at least 6 mm high. Otherwise, the text in the row below the barcode may be blocked after export.
(4) When exporting the sheet names in a template to Excel, pay attention to the following two issues:
The sheet name can contain up to 31 characters. Two sheet names with more than 31 characters may be identical in the exported template because the system only retains the first 31 characters of each sheet name, causing an export error.
The sheet name can contain characters such as English characters, vertical bars (|), and parentheses, but not special symbols such as colons (:), slashes (/), question marks (?), asterisks (*), and brackets ([]).
