I have a report that groups records first by room number, then by student name and must stay in this order. A student may appear in multiple rooms and I would like to show each student only once in the entire report regardless of how many rooms they appear in.
Example:
Room 1
Student 1
Student 2
Room 2
Student 7
Student 10
Room 3
Student 2 (This record should be suppressed)
Student 8
Room 4
Student 8 (This record should be suppressed)
Student 11
How can I accomplish this task? Any ideas?
Thanks
Example:
Room 1
Student 1
Student 2
Room 2
Student 7
Student 10
Room 3
Student 2 (This record should be suppressed)
Student 8
Room 4
Student 8 (This record should be suppressed)
Student 11
How can I accomplish this task? Any ideas?
Thanks