Problem with Mailing Labels

[Klssri]

We are having a problem printing mailing labels. We need to print mailing labels for foster homes for voucher payments. The report is based on kids placed in the home meeting certain date parameters. The problem is that the report is printing a label for every kid in the home that meets that criteria. We only need one label per home. We tried to suppress duplicates, which works but leaves the spot where the label would have been blank and wastes a lot of labels. I also tried to use select distinct records under database and this does alter the report somehow but there are still duplicate labels. Any other ideas of what I could try.

 

[rosemaryl]

Dear Klssri,

I am assuming that there is no field for the home on which to group.

In that case, since you said you were able to suppress the duplicates but not the space they occupied, you need to suppress the section if it is blank.

Right click (gray area on left) on the section that is showing the blank space and then choose, Suppress Blank Section checkbox.

Hope this helps...

ro Rosemary Lieberman
rosemary@microflo.com,

http://www.microflo.com

Microflo provides expert consulting on MagicTSD and Crystal Reports.

 

[Klssri]

Thanks, I did go back and look and for some reason there were some extra detail sections which I suppressed and it works fine now.