Suppress duplicates when creating mailing labels 1

[yatesk]

I am trying to create mailing labels. I have multiple cases for one defendant. I want to generate one label for each defendant not multiple labels for each case. Can this be done? Thanks in advance for your help

 

[MrBillSC]

Create your label using the label wizard.
Insert a group on "defendant" and suppress the group header and group footer.

Open the select expert, click "show formula", click "group", click "formula editor".

Enter:
{table.CaseNumber} = Maximum({table.CaseNumber},{table.defendant})

Save and close.

MrBill