{"id":683,"date":"2020-03-03T10:32:29","date_gmt":"2020-03-03T17:32:29","guid":{"rendered":"http:\/\/bekerman.com\/blog\/?p=683"},"modified":"2020-03-03T10:35:50","modified_gmt":"2020-03-03T17:35:50","slug":"subreports-2-2","status":"publish","type":"post","link":"http:\/\/bekerman.com\/blog\/subreports-2-2\/","title":{"rendered":"Subreports 2.2"},"content":{"rendered":"\n<p>Picking up from the previous article, there are some changes we need to make to the linked subreport we just created.<\/p>\n\n\n\n<!--more-->\n\n\n\n<p>From the Design tab right-click on the subreport and select Edit Subreport.  This will open the subreport on a new tab (to the right of the Design and Preview tabs).<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" width=\"491\" height=\"219\" src=\"http:\/\/bekerman.com\/blog\/wp-content\/uploads\/2020\/02\/subphonesedit.jpg\" alt=\"\" class=\"wp-image-687\" srcset=\"http:\/\/bekerman.com\/blog\/wp-content\/uploads\/2020\/02\/subphonesedit.jpg 491w, http:\/\/bekerman.com\/blog\/wp-content\/uploads\/2020\/02\/subphonesedit-300x134.jpg 300w\" sizes=\"(max-width: 491px) 100vw, 491px\" \/><\/figure><\/div>\n\n\n\n<p>Just like the first subreport we created the Print Date field was added by default.  This time, instead deleting the field we will just hide the Report Header sections (right-click on the Report Header text and select Hide).  This will also hide the field headers that were added when we added the Constituent ID and Phone Number fields in the Subreport Wizard.<\/p>\n\n\n\n<p>If you previewed the report at the end of the previous article it probably included duplicate phone numbers and emails.  To fix this we need to group our subreport by the Phone Number field.<\/p>\n\n\n\n<p>Click on the Group Expert button (or the Report menu then select Group Expert).  Double-click on the Phone Number field to move it to the Group By window.  Click the OK button to return to the subreport preview.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" width=\"578\" height=\"330\" src=\"http:\/\/bekerman.com\/blog\/wp-content\/uploads\/2020\/02\/groupbyphone.jpg\" alt=\"\" class=\"wp-image-690\" srcset=\"http:\/\/bekerman.com\/blog\/wp-content\/uploads\/2020\/02\/groupbyphone.jpg 578w, http:\/\/bekerman.com\/blog\/wp-content\/uploads\/2020\/02\/groupbyphone-300x171.jpg 300w, http:\/\/bekerman.com\/blog\/wp-content\/uploads\/2020\/02\/groupbyphone-500x285.jpg 500w\" sizes=\"(max-width: 578px) 100vw, 578px\" \/><\/figure><\/div>\n\n\n\n<p>On the subreport preview right-click on the Details, Group Footer and Report Footer sections and hide them.  Also remove the bold format from the Group #1 Name field.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" width=\"498\" height=\"233\" src=\"http:\/\/bekerman.com\/blog\/wp-content\/uploads\/2020\/02\/subphonesfinish.jpg\" alt=\"\" class=\"wp-image-693\" srcset=\"http:\/\/bekerman.com\/blog\/wp-content\/uploads\/2020\/02\/subphonesfinish.jpg 498w, http:\/\/bekerman.com\/blog\/wp-content\/uploads\/2020\/02\/subphonesfinish-300x140.jpg 300w\" sizes=\"(max-width: 498px) 100vw, 498px\" \/><\/figure><\/div>\n\n\n\n<p>Return to the main report&#8217;s Preview tab to see the results of our hard work.  Our example from earlier now shows four phone numbers and email addresses, without causing duplicate gift rows.  <\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" width=\"489\" height=\"206\" src=\"http:\/\/bekerman.com\/blog\/wp-content\/uploads\/2020\/02\/diresta.jpg\" alt=\"\" class=\"wp-image-696\" srcset=\"http:\/\/bekerman.com\/blog\/wp-content\/uploads\/2020\/02\/diresta.jpg 489w, http:\/\/bekerman.com\/blog\/wp-content\/uploads\/2020\/02\/diresta-300x126.jpg 300w\" sizes=\"(max-width: 489px) 100vw, 489px\" \/><\/figure><\/div>\n\n\n\n<p>As I mentioned earlier, keep subreports in mind if you have duplicate records on your report.  It&#8217;s usually the answer to removing the duplicates.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Picking up from the previous article, there are some changes we need to make to the linked subreport we just created.<\/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\/683"}],"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=683"}],"version-history":[{"count":11,"href":"http:\/\/bekerman.com\/blog\/wp-json\/wp\/v2\/posts\/683\/revisions"}],"predecessor-version":[{"id":699,"href":"http:\/\/bekerman.com\/blog\/wp-json\/wp\/v2\/posts\/683\/revisions\/699"}],"wp:attachment":[{"href":"http:\/\/bekerman.com\/blog\/wp-json\/wp\/v2\/media?parent=683"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/bekerman.com\/blog\/wp-json\/wp\/v2\/categories?post=683"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/bekerman.com\/blog\/wp-json\/wp\/v2\/tags?post=683"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}