How to compress multiple values to only one in a view.

[cbaker10]

I have 2 tables I have created a view to combine. One table is a list of teacher names and the other list is a list of enrollments. They are tied together by a teacher ID. I want to get just the teacher name from the teacher table and just the course from the enrollments table. The problem comes in because there maybe 20 enrollments for a certian course and there fore it will list the teacher and course 20 times. Is there a way to compress the multiples to just list it once?

I.E.

Bob Biology

Chris English

Liz Math

Any ideas would be greatly appreciated.

Thanks,

Chris

[MayMusic]

You can get the teacher name in the header of the report page instead of including the field in the report. If you enable advanced options and parameters you can add header and select the teacher name field to show in the header.