{"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:\/\/www.finereport.com\/en\/product-functions\/summary-by-groups.html","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 FineReport reporting tool in this article.In grouping reports, it is often necessary to summarize data by groups. 1. Description In grouping reports, it is often necessary to summarize data by groups. For example, summarize sales of each region: 2. Creating steps 2.1 Open report Open the report&#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],"yst_prominent_words":[455,573,557],"_links":{"self":[{"href":"https:\/\/www.finereport.com\/en\/wp-json\/wp\/v2\/posts\/3478"}],"collection":[{"href":"https:\/\/www.finereport.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.finereport.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.finereport.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.finereport.com\/en\/wp-json\/wp\/v2\/comments?post=3478"}],"version-history":[{"count":1,"href":"https:\/\/www.finereport.com\/en\/wp-json\/wp\/v2\/posts\/3478\/revisions"}],"predecessor-version":[{"id":3479,"href":"https:\/\/www.finereport.com\/en\/wp-json\/wp\/v2\/posts\/3478\/revisions\/3479"}],"wp:attachment":[{"href":"https:\/\/www.finereport.com\/en\/wp-json\/wp\/v2\/media?parent=3478"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.finereport.com\/en\/wp-json\/wp\/v2\/categories?post=3478"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.finereport.com\/en\/wp-json\/wp\/v2\/tags?post=3478"},{"taxonomy":"yst_prominent_words","embeddable":true,"href":"https:\/\/www.finereport.com\/en\/wp-json\/wp\/v2\/yst_prominent_words?post=3478"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}