{"id":3475,"date":"2016-05-28T03:00:16","date_gmt":"2016-05-27T19:00:16","guid":{"rendered":"http:\/\/www.finereport.com\/en\/?p=3475"},"modified":"2019-10-24T14:47:28","modified_gmt":"2019-10-24T06:47:28","slug":"vertical-grouping-report","status":"publish","type":"post","link":"https:\/\/frg.fineres.com\/en\/2016\/05\/28\/vertical-grouping-report\/","title":{"rendered":"Vertical Grouping Report"},"content":{"rendered":"

We will introduce Vertical Grouping Report of FineReport reporting software<\/span><\/a>in this article.Data are grouped by the field of Region, after which it takes one row as group header. Reports of this kind are called vertical grouping reports.<\/p>\n

1. Description<\/h3>\n

Reports in the section of Grouping Report<\/span> can be called the simplest grouping reports. There are also variations in grouping reports; one common style, for example, is a group header residing above or below other than on the left.As shown in the figure below, data are grouped by the field of Region, after which it takes one row as group header. Reports of this kind are called vertical grouping reports.<\/p>\n

\"\"<\/p>\n

2. Realization ideas<\/h3>\n

As explained in the section of Parent-Child Cell<\/span><\/a>, data columns on the same row automatically form parent-child relations; data columns from the same data set automatically form subordinate relations and produce grouping effect.<\/p>\n

For vertical grouping reports, headers take one separate row. If data columns are not on the same row, there is no parent cell relation between headers and data, meaning other data columns will not take the field of Region as a filter condition.<\/p>\n

Therefore, in such grouping reports, simply resetting the parent cells of data fields as header fields will produce grouping effect.<\/p>\n

3. Creating steps<\/h3>\n

3.1 Open report<\/strong><\/p>\n

Open the report of %FR_HOME%\\WebReport\\WEB-INF\\reportlets\\doc\\Primary\\GroupReport\\Group.cpt<\/span>.<\/p>\n

3.2 Change report style<\/strong><\/p>\n

Cut fields of Sales Staff and Sales Volume to the next row to find no subordinate relation between data and headers in preview.<\/p>\n

\"\"<\/p>\n

3.3 Set parent cell<\/strong><\/p>\n

To display data by groups, select the cell of data column Sales Staff and set the cell of Region as its left parent cell.<\/p>\n

As the field of Region is a group header, it is possible to highlight the header by changing the background color of the row of Region field: click Cell Attribute Table – Style, select the option of Background and set background color as yellow, as shown below:<\/p>\n

\"\"<\/p>\n

3.4 Save to preview<\/strong><\/p>\n

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

Click Group_1.cpt1<\/span><\/a> to check template effect online.<\/p>\n","protected":false},"excerpt":{"rendered":"

We will introduce Vertical Grouping Report of FineRepor…<\/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\/3475"}],"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=3475"}],"version-history":[{"count":3,"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/posts\/3475\/revisions"}],"predecessor-version":[{"id":8471,"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/posts\/3475\/revisions\/8471"}],"wp:attachment":[{"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/media?parent=3475"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/categories?post=3475"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/tags?post=3475"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}