Group summary in pagination

1. Version 

2. Problem description

In the fixed number of lines displayed on each page of the document  , the fixed number  of lines displayed on each page is realized through "Conditional Properties > Pagination After Line", but when the  total number of pages is realized based on  it, use "Repeat End Line" to set "Page Total", There will be a problem of repeated page totals. As shown below:

Group Summary:

Total summary:

So how to realize the normal display of page totals, combined totals, and total totals in a fixed-line report?

3. Solutions

Use advanced grouping to write grouping formulas, set "Pagination before row" in the conditional formatting, and then perform totals.

1. Design report

Design the report style as follows:

2. Group setting

In cell A5, enter the formula: =ds1.group (int ($$group_ result_ Sequence-1)/5), extending vertically, with left parent set to A4 and set the parent cell of B5 to A5 ( or the default).

Explanation: the meaning of the formula is to group every 5 records in the parent shipmethod group. The value of the formula is group number, starting from 0. If you want to group every n order records in each shipmethod, the formula is changed to =ds1.group (int (($$group))_ result_ Sequence-1)/n).

3. Summary settings

1) Page summary:

The order record of each group under the shipmethod is one page, and the summary within the page is the summary of each group.

Set the left parent cell of page summary cell A6 to A5, and enter the formula = sum (E5) in cell E6 to sum each group.

2) Group Summary:

Set the left parent cell of group summary cell A7 as A4, and enter the formula= sum (E5) in cell E7.

3) Total summary:

The parent cell should be non3, and enter the formula = sum (E5) in the cell E8.

4. Pagination settings

Right click cell A5, select conditional formatting, add pagination, select pagination before row, select common condition type, select not equal to 0 in operator, that is, pagination before row starts from the second group in each shipmethod, as shown in the following figure:

5. Save and preview

1) PC

Save the template. Pagination preview, the effect is as above I.Description.

2) Mobile

Both App and HTML5 are supported, and the effect is shown in the following figure:

6. Page number setting

The template is paginated by the shipmethod, with 5 lines per page. At this time, you want to know which page is in a certain shipmethod and how many pages there are in this shipmethod, so what should you do?

Two formulas representing page numbers are set at the bottom of the report:

Cell D10 is = {A5} + 1, which indicates the current number of pages in a region. 

Cell E10 is = "/" + count (A5), which indicates how many pages there are to obtain the page numbers of the shipmethod, as shown in the figure below:

The left parent cells of D10 and E10 are set to A4, and the 10th row is set to duplicate (select 10th row, left-click, and select set duplicate end rows .

Note: due to the influence of repeating the ending line, after setting the page number, you need to set the parent cell of A8 and E8 to A11, and set the parent cell of A11 to none.

After saving and previewing, you can see the page number of the current region:

For completed template, please refer to %fr_HOME%\webapps\webroot\WEB-INF\reportlets\doc-EN\ReportApplication\FeaturesApplication\PagSum1.cpt

Click to download the template: 

PagSum1.cpt