We will introduce Grouping Report – Parent-Child Cell of FineReport reporting tool in this article.A grouping report shows the report data by groups, meaning the duplicates in a data column are shown in a combined group.

1. Description

A grouping report shows the report data by groups, meaning the duplicates in a data column are shown in a combined group. The following is a simple grouping report:

2. Creating steps

2.1 Create a new report and add data set

Create a new workbook and add data set ds1 with SQL statement: SELECT * FROM [Sales Volume].

2.2 Drag data column

Drag data column into the corresponding cells (displayed by groups by default without other settings), as shown below:

Set the data column of Sales Volume as Summary – Sum, and as Default for the rest. Preview to see the grouping effect above.

For completed templates, refer to %FR_HOME%\WebReport\WEB-INF\reportlets\doc\Primary\GroupReport\Group.cpt.

Click Group.cpt.to check template effect online.

3. Summary

As shown in the example:

the dragged data column is displayed by groups by default and combines duplicates;

When data columns are on the same row, default parent cell relations occur: For cells on the same row, one cell takes another extension cell adjacent on the left as its parent cell; for example, the cell of Region is the default parent cell for the cell of Sales Staff, and the cell of Sales Staff for the cell of Sales Volume;

When data columns are on the same row and from the same data set, the child cells will automatically take parent cells as filter conditions and form subordinate relations; for example, the cell of Sales Staff is automatically listed under the cell of Region.

For the address of online video in the section of Grouping Report, please refer to[Grouping Report].