Exporting General Reports in Batches

Version

Application Scenario

When you set Export Event in a general report, you can export multiple general reports in batches, as shown in the following figure.

You can use this function in common scenarios. For example, when exporting data from the main table, you may want to export related data from the sub table together. The following figure shows how to export the main table and sub table together as an example.

Function Description

• The function mentioned in this document is a sub-function of Export Event.

• The function is only supported in general reports, but not in tables of FVS visualization dashboards.

• You can export up to 50 templates in batches. If you export over 50 templates, an error message will be displayed.

• The following figure shows the batch export entry.

Template Preparation

This example implements the effect of exporting the main table and sub table in the figure in section "Application Scenario." First, open the two built-in templates in the designer.

Main table: %FR_HOME%\webapps\webroot\WEB-INF\reportlets\doc-EN\SpecialSubject\HyplinkReport\Main Table.cpt

Sub table: %FR_HOME%\webapps\webroot\WEB-INF\reportlets\doc-EN\SpecialSubject\HyplinkReport\Sub Table.cpt

Actually, you only need to set the main table in this example. Here, the sub table is provided for you to know which is the sub table of this main table.

Setting Batch Export for the Main Table

1. Enter the parameter editing panel of the main table , add a button, and rename it Batch Export.

Add a Click event to the button, select Export Event as the event type, and set Export Template to Other Templates for the event, as shown in the following figure.

2. Click the Insert icon and add an export event for the main table. The following describes specific setting items:

• Template file: %FR_HOME%\webapps\webroot\WEB-INF\reportlets\doc-EN\SpecialSubject\HyplinkReport\Main Table.cpt

• Export Way: Excel Output (Unaltered Export)

• Export File Name: Custom

• Custom: "Order"+$ID+"Main Table"

• Parameter Setting: Inherit Report

Note:

Because the parameters in the main table and sub table are the same, the parameter here can be directly set to Inherit Report.

3. Click the Insert icon and add another export event for the sub table. The following describes specific setting items:

• Template file: %FR_HOME%\webapps\webroot\WEB-INF\reportlets\doc-EN\SpecialSubject\HyplinkReport\Sub Table.cpt

• Export Way: Excel Output (Unaltered Export)

• Export File Name: Custom

• Custom: "Order"+$ID+"Sub Table"

• Parameter Setting: Inherit Report

Note:

Because the parameters in the main table and sub table are the same, the parameter here can be directly set to Inherit Report.

Effect Display

Save the report. After clicking Pagination Preview, first query an order and click Batch Export. Then both the main table and the sub-table of this order will be exported togther. The effect is the same as that shown in "Application Scenario".

Note:

The effect cannot be displayed on mobile terminals.

For details about the completed template, go to %FR_HOME%\webapps\webroot\WEB-INF\reportlets\doc-EN\ReportApplication\FeaturesApplications\Bacth File Export - Main Table.cpt.

For details, you can download the template

Batch File Export - Main Table.cpt.

Batch File Export-Sub Table.cpt

If you find that only one Excel is exported after clicking and ensure that the code is correct, you need to allow pop-ups in the browser settings.