Pagination by Group

Expected Effect

Pagination by group means that data is paginated and displayed by group, where each group occupies a separate page.

For example, a report was originally paginated by paper size, but you now want it to paginate by shipper region, displaying all data for one region on the same page.

Implementation Method

You can set Paginate Before Row before each group of data or Paginate After Row after each group of data.

Template Preparation

For details, you can download the template Repeating Header Rows on Every Page.cpt.

Pagination by Group Configuration

To set up group pagination by ShipperRegion in cell A4, since it is in the middle of the table, you cannot directly set pagination on the ShipperRegion cell. Instead, you need to set Paginate Before Row along with the header.

1. Parent Cell Setting

Because repeated header rows are set, each group of data starts from the header. You need to set Left Parent Cell of cell A1 to cell A4 (where ShipperRegion is located), as shown in the following figure.

2. Paginate Before Row Setting

Proceed as follows if you want to achieve pagination before each group of data. Select cell A1, choose Cell Attribute > Others, and tick Paginate Before Row, as shown in the following figure.

Page Setting

To prevent data already paginated by group from being split again due to page height limitations, you need to adjust the page size to maximize the page height.

Choose Template > Page Setting from the menu bar, and set Paper Size to A1 [594x841 mm], as shown in the following figure.

Effect Display

Save the template, and click Pagination Preview. The following figure shows the effect.

The template can be previewed on the DataAnalyst app and HTML5 terminal.

Template Download

For details, you can download the template Pagination by Group.cpt.

Template Preparation

For details, you can download the template Cross Report.cpt.

Pagination by Group Configuration

Repeat Title Row and Repeat End Row Setting

1. Select the first line row to the third line, right-click the mouse, and select Repeat Title Row, as shown in the following figure.

2 Select the fifth row, right-click the mouse, and select Repeat End Row, as shown in the following figure.

Grouping and Pagination Setting

1. Parent Cell Setting

Select cell A5, choose Cell Attribute > Expansion, set Left Parent Cell to A4, and set Expansion Direction to No Expansion, as shown in the following figure.

Note:

Paginate Before Row means the page paginates before the selected row, making the current row the first row of the second page.

2. Pagination After Row Setting

Select the fifth row, choose Cell Attribute > Others, and tick Paginate After Row, as shown in the following figure.

Note:

Paginate After Row means starting a new page from the line following the selected row, making the current row the last line of the first page.

Effect Display

Save the template, and click Pagination Preview. The following figure shows the effect.

The template can be previewed on the DataAnalyst app and HTML5 terminal.

Page Setting and Paginate Before Row/After Row Taking Effect Simultaneously

Paginate Before Row, Paginate After Row, and Page Setting take effect simultaneously. When table data exceeds the current page size, the table will first paginate according to the page size set in Page Setting, then paginate according to Paginate Before Row or Paginate After Row. Page Setting must ensure the complete display of the set number of paginated rows to achieve the expected group pagination effect.