Usage Instruction to the New Calculation Engine

Version

Application Scenario

This document introduces the usage of the new calculation engine. The setting page of the new calculation engine is shown in the following figure.

Note:

 

For details about functions supported and currently not supported by the new calculation engine, see Introduction to the New Calculation Engine.

1. Prepare a CPT template. For example: Row-based Report.cpt

Choose Template > Report Engine Attribute, as shown in the following figure.

2. Tick Enable Background Pagination, tick New Calculation Engine, and click OK, as shown in the following figure.

3. Save the setting, and click Pagination Preview to view the template.

Function Description

• After ticking Pagination by Fixed Row Quantity, you can set Number of Records Per Page. An integer from 1 to 500 is supported. Entering a number greater than 500 may result in failure to calculate page numbers.

• Only detail reports with a single dataset are supported, and Data Setting of all fields in the detail report must be set to list. If Pagination by Fixed Row Quantity is enabled for a detail table that contains multiple datasets, the backend will report an error: "Error code: 11100052. The template contains multiple datasets and is not detail table, so it is not able to calculate total number of rows or page number. Please adjust template structure."

• The Number of Records Per Page setting counts only rows from vertically expanded datasets, excluding headers and non-expanded datasets. The template will no longer paginate horizontally and will not support adaptation settings.

• If the Number of Rows Displayed Per Page setting in the template based on Fixed Row Quantity Per Page differs from the Number of Records Per Page setting, the Number of Records Per Page setting takes precedence.

• When expanded cells used for row calculation in the template are configured with filter settings that cannot be converted to SQL statements, row height changes as a condition attribute, row hiding, or result set filtering, the final displayed data volume will be affected. Also, the page number/row count calculation will fail during preview, with an error reported in the backend: "Error code: 11100050. There are filter settings that do not support calculating total number of rows. Fail to calculate total number of rows or page number." or "Error code: 11100051. There are condition attribute/hidden row/result set filter settings that do not support calculation of total rows. In this case, the total number of rows or page number cannot be calculated precisely.".

• Regardless of whether Pagination by Fixed Row Quantity is set, the old engine is always used for exporting data.

• If calculating the total number of pages takes longer than one minute, the process will be automatically aborted. Additionally, if the process is terminated by Intelligent O&M, the calculation will not be resumed. The following figure shows the effect.

Template Preparation

1. Choose File > New General Report, and create a dataset ds1 with the database query statement SELECT * FROM OrderDetails_new.

2. Design the report, as shown in the following figure.

3. Set Data Setting to List for cells A2, B2, C2, D2, and E2. The configuration method is the same for all. The following figure takes cell A2 as an example.

Effect Display

1. Choose Template > Report Engine Attribute > Enable Background Pagination > Pagination by Fixed Row Quantity, and set Number of Records Per Page to 30, as shown in the following figure.

Note:

An integer from 1 to 500 is supported. Entering a number greater than 500 may result in failure to calculate page numbers.

2. Click Pagination Preview to view the template, as shown in the following figure.

Function Description

• Only detail reports with a single dataset are supported. If Row Quantity Summary is enabled for a detail table that contains multiple datasets, the backend will report an error: "Error code: 11100052. The template contains multiple datasets and is not detail table, so it is not able to calculate total number of rows or page number. Please adjust template structure.".

• If retrieving the total data takes longer than one minute, the retrieval will be automatically aborted. Additionally, if the process is terminated by intelligent operations, the retrieval will not be resumed. The following shows the effect.

Template Preparation

For details, see section "Template Preparation."

Effect Preview

1. Choose Template > Report Engine Attribute > Enable Background Pagination > Row Quantity Summary, as shown in the following figure.

2. Click Pagination Preview to view the template, as shown in the following figure.