I'm working on building a report that pulls name data based on a specific report identification number. I have the information grouped by the report number and want to display names related to the report. The problem is that each report number can/often does have subsequent reports written that are attached to the same number which include the same names, thus giving me duplicate names in the group, but not listed consecutively. The report looks like this currently:
Report # Name
170001 Smith, Bob
170002 Jones, Mike
170003 White, James
I want to suppress all instances where there are duplicate names under the same report number.
Thanks in advance for any help!