{"id":3468,"date":"2016-05-26T03:00:22","date_gmt":"2016-05-25T19:00:22","guid":{"rendered":"http:\/\/www.finereport.com\/en\/?p=3468"},"modified":"2018-09-11T19:19:37","modified_gmt":"2018-09-11T11:19:37","slug":"finereport-grouping-report-parent-child-cell","status":"publish","type":"post","link":"https:\/\/frg.fineres.com\/en\/2016\/05\/26\/finereport-grouping-report-parent-child-cell\/","title":{"rendered":"FineReport Grouping Report – Parent-Child Cell"},"content":{"rendered":"

We will introduce Grouping Report – Parent-Child Cell of FineReport reporting tool<\/span><\/a> 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.<\/p>\n

1. Description<\/h3>\n

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:<\/p>\n

\"\"<\/p>\n

2. Creating steps<\/h3>\n

2.1 Create a new report and add data set<\/strong><\/p>\n

Create a new workbook and add data set ds1 with SQL statement: SELECT * FROM [Sales Volume].<\/span><\/p>\n

2.2 Drag data column<\/strong><\/p>\n

Drag data column into the corresponding cells (displayed by groups by default without other settings), as shown below:<\/p>\n

\"\"<\/p>\n

Set the data column of Sales Volume as Summary – Sum, and as Default for the rest. Preview to see the grouping effect above.<\/p>\n

For completed templates, refer to %FR_HOME%\\WebReport\\WEB-INF\\reportlets\\doc\\Primary\\GroupReport\\Group.cpt.<\/span><\/p>\n

Click Group.cpt.<\/span><\/a>to check template effect online.<\/p>\n

3. Summary<\/h3>\n

As shown in the example:<\/p>\n

the dragged data column is displayed by groups by default and combines duplicates;<\/p>\n

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;<\/p>\n

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.<\/p>\n

For the address of online video in the section of Grouping Report, please refer to[Grouping Report]<\/span><\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"

We will introduce Grouping Report – Parent-Child …<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[111],"tags":[117],"_links":{"self":[{"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/posts\/3468"}],"collection":[{"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/comments?post=3468"}],"version-history":[{"count":1,"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/posts\/3468\/revisions"}],"predecessor-version":[{"id":3469,"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/posts\/3468\/revisions\/3469"}],"wp:attachment":[{"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/media?parent=3468"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/categories?post=3468"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/tags?post=3468"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}