Overview
Version
| Report Server Version | Function Changes |
|---|---|
| 11.0 | - |
| 11.0.1 | Supported displaying the total page count after enabling Pagination by Fixed Row Quantity. For details, see the section "Pagination by Fixed Row Quantity." Supported displaying the total data volume after enabling Row Quantity Summary. For details, see the section "Row Quantity Summary." |
Application Scenario
This document describes how to use the new calculation engine. The settings page of the new calculation engine is shown in the following figure.
Note:
Enabling the New Calculation Engine
(1) Open a CPT template, for example, FineReport installation directory\webroot\WEB-INF\reportlets\GettingStarted.cpt.
Choose Template > Report Engine Attribute, as shown in the following figure.
(2) Select Enable Background Pagination, select New Calculation Engine, and click OK to enable the new calculation engine, as shown in the following figure.
(3) Save the template and click Pagination Preview to preview the template.
Pagination by Fixed Row Quantity
Function Description
After selecting Pagination by Fixed Row Quantity, you can set Number of Records Per Page. The value must be an integer in the range of 1 to 500. A value exceeding 500 may cause page count retrieval to fail.
This function is available only for single-dataset detail tables, and Data Setting needs to be set to List for all data column cells in the detail table. If this function is enabled for other detail tables, the following error is reported in the backend:
Error Code: 11100052. The current template is not a single-dataset detail table, so calculating the total row or page count is not supported. Adjust the template structure.
Number of Records Per Page only counts the rows generated by vertically expanded data column cells. If there are no such cells in the template, horizontal paging and self-adaptive settings will no longer be supported. Note that frozen title rows are also included in the total row count.
If the display row count per page configured (see Fixed Row Quantity Per Page) in the template differs from the value set in Number of Records Per Page, the latter prevails.
When the expansion cells used to calculate the row count are configured with non-SQL-convertible filters (i.e., filter attributes that cannot be executed at the database level), Row Height in condition attributes, hidden rows, or dataset filtering, the final displayed data volume will be affected. In this case, during preview, the page count or row count retrieval fails, and the following error is reported in the backend: Error Code: 11100050. Unsupported filter settings for the total row count calculation are configured. The total row count or page count cannot be calculated accurately. or Error Code: 11100051. Unsupported condition attributes, hidden rows, or result set filtering settings for total row count calculation are configured. The total row count or page count cannot be calculated accurately.
Regardless of whether pagination by row count is set, export always uses the legacy engine.
If the retrieval of the total page count exceeds one minute, or if the process is interrupted by Intelligent O&M, the retrieval will be automatically terminated, as shown in the following figure.
Template Preparation
(1) Create a general report with the following database query: 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 to List display. The configuration method is the same for all cells. Cell A2 is used as an example, as shown in the following figure.
Effect Display
(1) Choose Template > Report Engine Attribute. In the popped-up Report Engine Attribute window, select Enable Background Pagination and Pagination by Fixed Row Quantity, and set Number of Records Per Page to 30, as shown in the following figure.
Note:
(2) Click Pagination Preview to preview the template, as shown in the following figure.
Total Row Count Statistics
Function Description
This function is available only for single-dataset detail tables. If this function is enabled for other detail tables, the following error is reported in the backend: Error Code: 11100052. The current template is not a single-dataset detail table, so calculating the total row or page count is not supported. Adjust the template structure.
If the retrieval of the total row count exceeds one minute, or if the process is interrupted by Intelligent O&M, the retrieval will be automatically terminated, as shown in the following figure.
Template Preparation
See "Pagination by Fixed Row Quantity" > "Template Preparation" in this document.
Effect Display
(1) Choose Template > Report Engine Attribute. In the popped-up Report Engine Attribute window, select Enable Background Pagination and Row Quantity Summary, as shown in the following figure.
(2) Click Pagination Preview to preview the template, as shown in the following figure.
