Export

  • Last update:  2023-10-19
  • 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

    • 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.

    Functions

    You can export templates in the FineReport designer, in browsers, or in API interfaces.

    iconNote:
    The report effect achieved through adding JavaScript (hereinafter called JS) cannot be reflected after export. In other words, the exported report has the same effect as the report without JS. For example, a cell row hidden through JS still exists after export, because JS modifications are purely frontend and have no impact on the export in the backend.

    General Report Export

    iconNote:

    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.

    Designer Export

    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.

    iconNote:
    The report export follows the principle of WYSIWYG (What You See Is What You Get). The exported page is identical to the previewed page in the browser. Only the display values, rather than the actual values, are exported.

    Browser Export

    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.

    URL Export

    Custom Export Button

    Export by integrating Web pages and customizing Web page buttons.

    Custom Export Button

    Exporting to Excel Files

    Classification

    Introduction

    Document

    Built-in export solution

    Pagination Export

    Unaltered Export

    Page to Sheet Export

    Excel Export

    Export format

    Excel (2007) files

    /

    Excel (2007/2003) files

    Export Excel Mode Selection Widget

    Export style

    Keep hyperlinks during export.

    /

    Keep formulas 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.

    Export Headers and Footers to Word Files

    Automatically adjust line height during export.

    Automatical Line Height Adjustment

    Export to PDF files.

    Merge multiple templates into one PDF file and export it.

    /

    Set passwords during export.

    Password Attributes of Exporting PDF

    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.

    URL Export

    Dashboard Export

    Introduction

    Document

    Export dashboards to Excel, PDF, Word, and image (in PNG, JPG, GIF, and BMP formats) files.

    Dashboard Export Plugin

    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.

    Customize Export File Name

    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.

    Report Export API

    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."

     1.png

    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.

     2.png

    Exporting HTML Content

    iconNote:

    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


    Attachment List


    Theme: Report Application
    • Helpful
    • Not helpful
    • Only read

    滑鼠選中內容,快速回饋問題

    滑鼠選中存在疑惑的內容,即可快速回饋問題,我們將會跟進處理。

    不再提示

    10s後關閉

    Get
    Help
    Online Support
    Professional technical support is provided to quickly help you solve problems.
    Online support is available from 9:00-12:00 and 13:30-17:30 on weekdays.
    Page Feedback
    You can provide suggestions and feedback for the current web page.
    Pre-Sales Consultation
    Business Consultation
    Business: international@fanruan.com
    Support: support@fanruan.com
    Page Feedback
    *Problem Type
    Cannot be empty
    Problem Description
    0/1000
    Cannot be empty

    Submitted successfully

    Network busy