Data Entry Pagination 

1. Problem description

When data entry preview, all the data are displayed on one page. If the amount of data is too large, due to the performance limitations of the front-end browser, it will be very slow to display all the data, which will greatly affect the user experience.

So can data entry preview be displayed in pages like pagination preview, so as to improve the speed? The effect is as follows:

2. Solution

Under data entry preview (op = write), use__ cutpage__ =vparameter (i.e. add after URL)&__ cutpage__ =v) To enable pagination.

Note 1: This method does not support new fill preview and mobile terminal, does not support column paging (post-column paging and pre-column paging) , and does not support page number functions $$page_number and $$totalPage_number after paging.

Note 2: __ is two underscores

1. Data preparation

Create a new general report and a new database query dataset. The SQL statement is: select * from orders limit 200

2. Design template

Design the data entry form, drag the data set fields to the corresponding cells, and add text controls to A2 ~ F2 cells, as shown in the following figure:

3. Setting Pagination after row

Pagination after row is set to limit how many rows of data are displayed on each page, which is realized by pagination > pagination after row condition attribute. The formula is: (row () - 1)% 20 = 0, where the 20 can be adjusted to any number you want to display on one page, as shown in the following figure:

Note: The -1 in this formula is because there is a row header title in the example, so it needs to be subtracted and not involved in the calculation. In actual application, please reduce the row according to the number of rows in your own report header!

4. Effect preview

Save the template, click data entry peview, and add parameters after the URL&__ cutpage__ =v and refresh the page, the result is as shown in the figure below:

Completed template, please refer to

%fr_HOME%\webapps\webroot\WEB-INF\reportlets\doc-EN\DataEntry\DataEntryApplication\Pagination.cpt

Click download template: 

Pagination.cpt

1. The platform is mounted to open the data entry pagination

If paging is required to mount the pagination template in the platform, it can be implemented in the parameter settings. parameter name is__cutpage__=v, type is string, value is v

2. Freeze the header row

If you want the title part to remain unchanged after turning the page, you can set the freeze, as shown in the following figure: