{"id":610,"date":"2020-02-25T11:48:18","date_gmt":"2020-02-25T18:48:18","guid":{"rendered":"http:\/\/bekerman.com\/blog\/?p=610"},"modified":"2023-03-28T10:31:36","modified_gmt":"2023-03-28T16:31:36","slug":"subreports-1-1","status":"publish","type":"post","link":"http:\/\/bekerman.com\/blog\/subreports-1-1\/","title":{"rendered":"Subreports 1.1"},"content":{"rendered":"\n<p>Picking up from the last article we are ready to build our subreport.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" width=\"345\" height=\"224\" src=\"http:\/\/bekerman.com\/blog\/wp-content\/uploads\/2020\/02\/subreportdesign.jpg\" alt=\"\" class=\"wp-image-604\" srcset=\"http:\/\/bekerman.com\/blog\/wp-content\/uploads\/2020\/02\/subreportdesign.jpg 345w, http:\/\/bekerman.com\/blog\/wp-content\/uploads\/2020\/02\/subreportdesign-300x195.jpg 300w\" sizes=\"(max-width: 345px) 100vw, 345px\" \/><\/figure><\/div>\n\n\n\n<p>Again, building a subreport is just like building a report.  I&#8217;ll go quickly through the steps since most of it has been covered in previous articles (links the the corresponding articles are included below).  One difference is that we will only want to see the summary rows and not the details.<\/p>\n\n\n\n<!--more-->\n\n\n\n<ul><li>Click on the Print Date field and press the delete key on your keyboard.<\/li><li>Click the <a rel=\"noreferrer noopener\" aria-label=\"Group Expert (opens in a new tab)\" href=\"http:\/\/bekerman.com\/blog\/get-organized-grouping-sorting-and-totals-part-1\/\" target=\"_blank\">Group Expert<\/a> button and group by the Fund Description field.<\/li><li><a rel=\"noreferrer noopener\" aria-label=\"Insert (opens in a new tab)\" href=\"http:\/\/bekerman.com\/blog\/adding-fields\/\" target=\"_blank\">Insert<\/a> the Gift Amount field in the Details section.<\/li><li>Right-click on the Gift Amount field and <a rel=\"noreferrer noopener\" aria-label=\"insert a summary (opens in a new tab)\" href=\"http:\/\/bekerman.com\/blog\/get-organized-grouping-sorting-and-totals-part-2\/\" target=\"_blank\">insert a summary<\/a> for Group #1.<\/li><li>Click and drag the Gift Amount summary field from Group Footer #1 to Group Header #1, adjacent to the Fund Description group header field.<\/li><li><\/li><\/ul>\n\n\n\n<p>Since we only want to see the summary information we need to hide the Details section.  In the right side of the window right-click on the word &#8220;Details&#8221; and select Hide.  This will change the Details section from white to shaded (or slashes throughout).<\/p>\n\n\n\n<p>If you preview the report now you will see a blank row between each summary row.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" width=\"274\" height=\"163\" src=\"http:\/\/bekerman.com\/blog\/wp-content\/uploads\/2020\/02\/blanksummaryrows.jpg\" alt=\"\" class=\"wp-image-615\"\/><\/figure><\/div>\n\n\n\n<p>Remove the blank rows by hiding the Group Footer #1 following the same steps we used above to hide the details section.  Save the report and return to the Preview tab of the main report.  If you are following along with the sample data the beginning of your report should look something like this (I also removed the bold font):<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" width=\"404\" height=\"123\" src=\"http:\/\/bekerman.com\/blog\/wp-content\/uploads\/2020\/02\/summaryrows-1.jpg\" alt=\"\" class=\"wp-image-618\" srcset=\"http:\/\/bekerman.com\/blog\/wp-content\/uploads\/2020\/02\/summaryrows-1.jpg 404w, http:\/\/bekerman.com\/blog\/wp-content\/uploads\/2020\/02\/summaryrows-1-300x91.jpg 300w\" sizes=\"(max-width: 404px) 100vw, 404px\" \/><\/figure><\/div>\n\n\n\n<p>Congrats on creating your first subreport!  In the <a href=\"http:\/\/bekerman.com\/blog\/adding-fields-2\/\" target=\"_blank\" rel=\"noreferrer noopener\" aria-label=\"next article (opens in a new tab)\">next article<\/a> we will take a look at linked subreports.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Picking up from the last article we are ready to build our subreport. Again, building a subreport is just like building a report. I&#8217;ll go quickly through the steps since most of it has been covered in previous articles (links &hellip; <a href=\"http:\/\/bekerman.com\/blog\/subreports-1-1\/\">Continue reading <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[11],"tags":[],"_links":{"self":[{"href":"http:\/\/bekerman.com\/blog\/wp-json\/wp\/v2\/posts\/610"}],"collection":[{"href":"http:\/\/bekerman.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/bekerman.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/bekerman.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/bekerman.com\/blog\/wp-json\/wp\/v2\/comments?post=610"}],"version-history":[{"count":10,"href":"http:\/\/bekerman.com\/blog\/wp-json\/wp\/v2\/posts\/610\/revisions"}],"predecessor-version":[{"id":701,"href":"http:\/\/bekerman.com\/blog\/wp-json\/wp\/v2\/posts\/610\/revisions\/701"}],"wp:attachment":[{"href":"http:\/\/bekerman.com\/blog\/wp-json\/wp\/v2\/media?parent=610"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/bekerman.com\/blog\/wp-json\/wp\/v2\/categories?post=610"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/bekerman.com\/blog\/wp-json\/wp\/v2\/tags?post=610"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}