Not wanting to use the custom label set up each time we run specialty labels I decided to write a custom report for a permanent label setup. We print 2up side by side duplicate labels because we put them on General fund and Bldg fund boxes for each Envl No. I filtered all profiles for Envl No 1-499 and sort by Envl No. I also group by envl no in the designer window.
My labels are just the way I want them The single kids still living home are coming out just fine. I test for Dir. Sequence > 2, then use the Profile First Name + Last Name, else for the parent I use the Mailing Name.
My problem is I get an extra row of labels for a Mr & Mrs because there are 2 Profile records for them. Can't hide the duplicates records because of the Dir Sequence numbers are different thus they aren't duplicate.
Does anyone know how I can eliminate or bypass one of the Profile records for a Mr & Mrs?
Please advise.
Custom labels for Envelope boxes
Moderators: Moderators, Tech Support
-
- Posts: 320
- Joined: Sun Sep 28, 2003 5:37 pm
- Location: First Cutlerville Christian Reformed Church
- Contact:
-
- Tech Support
- Posts: 3006
- Joined: Thu May 13, 2004 9:59 am
- Location: PowerChurch Software
- Contact:
Re: Custom labels for Envelope boxes
To get these down to one label per household, you would need to add data grouping in the report body. Group by envelope number. You will see this same kind of thing happen in the church directory custom reports that we have detailed on the site.
https://www.powerchurch.com/customreports/examples/
Add the group for envelope number and then move your fields down into the group footer band rather than the detail band.
https://www.powerchurch.com/customreports/examples/
Add the group for envelope number and then move your fields down into the group footer band rather than the detail band.
-
- Posts: 320
- Joined: Sun Sep 28, 2003 5:37 pm
- Location: First Cutlerville Christian Reformed Church
- Contact:
Re: Custom labels for Envelope boxes
I did the grouping but what I missed is that I didn't move the fields into the Group Footer.
Thanks much. That was an easy fix. Also thanks for the link to the examples.
John
Thanks much. That was an easy fix. Also thanks for the link to the examples.
John