Eliminating duplicate records 1

[faush]

Hi,

On a report, I need to display a member name and their business designation.

We have two different designations, A and B. It is currently displaying the member name twice, with designation A and designation B next to each name:

John Doe "A"
John Doe "B"

I just want the name on there once, with designation B, if they have both. Therefore, if John Doe has both designations, I just want this to display:

John Doe "B"

Does this make sense? It should be easy, but I can't get it to work.

Thank you.

 

[kenhamady]

Group by person, sort by designation, put the fields to display on the group footer and suppress the details and group header. Ken Hamady, On-site/Phone Crystal Reports Training/Consulting
Quick Reference Guide to using Crystal in VB

http://www.kenhamady.com/

 

[faush]

Thanks - this worked perfectly - you guys are great.