Executing Layered Reports with the Row-based Engine Enabled

Version

Problem Description

Sometimes, reports whose forms are elementary (for example, basic single-dataset detail reports) involve a high volume of data — millions, tens of millions of data records, or even more. The time taken to fetch and calculate the data of these reports is quite long.

You want to improve the report display speed so that you will not experience lag when querying reports.

Solution

For single-dataset detail reports, the row-based engine can be enabled to execute the reports, improving report display speed and optimizing the user experience.

Note:

1. The row-based engine cannot be enabled for FVS visualization dashboards.

2. The row-based engine cannot be enabled for FRM reports.

3. The row-based engine cannot be enabled on mobile terminals.

Prerequisites

To confirm whether the report environment supports enabling the row-based engine, see the "Report Feature Limit" section in Introduction to the Row-based Engine.

If not, refer to the "Example Index" section in Introduction to the Row-based Engine to select other suitable alternative solutions.

Example in this document: Use the row-based engine to paginate and display data from the orderdetails_new table in the MySQL database, with 50 rows per page.

Connecting to the MySQL Database

For details about connecting to the MySQL database, see Data Connection to MySQL.

Report Creation

Data Preparation

(1) You need to place a table named orderdetails_new in the MySQL database. The table structure is as follows:

Download the file orderdetails_new.xlsx and upload it to your MySQL database.

(2) Create a database query and select the mysql data connection.

Create a dataset ds1 with the SQL statement Select * from orderdetails_new, and click OK. The dataset preparation is complete, as shown in the following figure.

Report Design

Create a general report, set Expansion Direction to Vertical and Left Parent Cell to Default for cells A2 to F2.

The template style is as follows:

Report Engine Attribute Setting

(1) Choose Template > Report Engine Attribute from the menu bar to open the report engine attribute page.

(2) Select Enable Background Pagination and select Row-based Engine.

(3) In the Row-based Engine settings, select Pagination by Fixed Row Quantity and set Number of Records Per Page to 50.

Click OK to complete the row-based engine attribute settings for the report, as shown in the following figure.

Note:

The number of records per page cannot exceed 500.

Effect Preview

Click Pagination Preview, and the effect is as shown in the following figure: