Duplicate Names on Label Report

[Mah77]

Created FSA mailing label report. How do you remove duplicate names of those who have more than one FSA?

 

[CharlesCook]

You could use Database Grouping to compress the data down to 1 record per person.

Take a look at this:

http://charlescook.com/PPS/ADP/ReportSmith/PCPW/DatabaseGrouping.pps

http://CharlesCook.com

Specializing in ReportSmith Training and Consulting

 

[Mah77]

Thanks for MOTM guide to ReportSmith. But, apparently, I am missing a vital piece of the puzzle. I have database grouping on and still have duplicate address labels.

Maybe it is because the labels are using derived fields which concatenates the LASTNAME and FIRSTNAME, address fields and city, state and zip.

I have tried writing SUM(DISTINCT"NAMEMERGE")) and I get an error message.

 

[CharlesCook]

More then likely you have something setup for "Include in Report" and then Database Grouping that has a value that changes and then makes each record different.

Do this:

1. Turn Off Database Grouping.
2. Make all of the data fields "Query Only" inless the data is directly displayed on the label. If the datafield is in a derived field and the derived field is displayed in the label make it "Query Only".
3. Turn On Database Grouping

http://CharlesCook.com

Specializing in ReportSmith Training and Consulting

 

[Mah77]

Thanks for all your help, I am now duplicate free.