{"id":3478,"date":"2016-05-28T03:00:19","date_gmt":"2016-05-27T19:00:19","guid":{"rendered":"http:\/\/www.finereport.com\/en\/?p=3478"},"modified":"2018-09-11T19:18:14","modified_gmt":"2018-09-11T11:18:14","slug":"summary-by-groups","status":"publish","type":"post","link":"https:\/\/frg.fineres.com\/en\/2016\/05\/28\/summary-by-groups\/","title":{"rendered":"Summary by groups"},"content":{"rendered":"<p>We will introduce Summary by groups function of FineReport <a href=\"\/en\/\" title=\"reporting tools\" target=\"_blank\"><span style=\"color: blue;\">reporting tool<\/span><\/a> in this article.In grouping reports, it is often necessary to summarize data by groups.<\/p>\n<h3>1. Description<\/h3>\n<p>In grouping reports, it is often necessary to summarize data by groups. For example, summarize sales of each region:<\/p>\n<p><img src=\"http:\/\/www.finereport.com\/en\/wp-content\/themes\/fanruan\/images\/20165256.png\" alt=\"\" \/><\/p>\n<h3>2. Creating steps<\/h3>\n<p><strong>2.1 Open report<\/strong><\/p>\n<p>Open the report of <span style=\"color: blue;\">%FR_HOME%\\WebReport\\WEB-INF\\reportlets\\docdoc\\Primary\\GroupReport\\Group_1.cpt<\/span>.<\/p>\n<p><strong>2.2 Set summary of parent cell<\/strong><\/p>\n<p>Add a row of summary below to sum up sales volume, and set the cell of Region as the left parent cell of the cell of \u201cSubtotal\u201d:<\/p>\n<p><img src=\"http:\/\/www.finereport.com\/en\/wp-content\/themes\/fanruan\/images\/20165257.png\" alt=\"\" \/><\/p>\n<p>As shown in the preview template, the row of \u201cSubtotal\u201d is copied following the extension of the parent cell Region, i.e., subtotaling each extended region, shown in blue.<\/p>\n<p><strong>2.3 Summary of parent cell with no setting<\/strong><\/p>\n<p>Add a row of summary again, and set no parent cell, i.e., the cell of \u201cSubtotal\u201d has no parent cell:<\/p>\n<p><img src=\"http:\/\/www.finereport.com\/en\/wp-content\/themes\/fanruan\/images\/20165258.png\" alt=\"\" \/><\/p>\n<p>As shown in the preview template, the row of \u201cSubtotal\u201d remains at the bottom and is displayed after extension of all cells above, shown in red.<\/p>\n<p><strong>2.4 Save and issue reports<\/strong><\/p>\n<p>For completed templates, refer to <span style=\"color: blue;\">%FR_HOME%\\WebReport\\WEB-INF\\reportlets\\doc\\Primary\\GroupReport\\Group_2.cpt<\/span>.<\/p>\n<p>Click <a href=\"http:\/\/www.finereporthelp.com:8889\/demo\/ReportServer?reportlet=doc\/Primary\/GroupReport\/Group_2.cpt\" target=\"_blank\"><span style=\"color: blue;\">Group_2.cpt<\/span><\/a> to check template effect online.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>We will introduce Summary by groups function of FineRep&#8230;<\/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\/3478"}],"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=3478"}],"version-history":[{"count":1,"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/posts\/3478\/revisions"}],"predecessor-version":[{"id":3479,"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/posts\/3478\/revisions\/3479"}],"wp:attachment":[{"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/media?parent=3478"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/categories?post=3478"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/tags?post=3478"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}