I am having trouble creating a report that has people grouped by dept. I also don’t know how to insert a page break when the group changes. Any help will be greatly appreciated.

For example:

BHS

John Smith

Jane Doe

Page break

Dance

Dean Brown

Lucy Meer

Thanks again

Edited June 17, 200619 yr by Guest

Look into adding a leading sub-summary layout part sorted by department name with the people(ie. BHS) in a body part that follows the sub-summary. Make sure you sort by the department name field. If you have multiple records in the found set with the same person's name in the people name field, use a trailing sub-summary following the department name sub-summary part that is sorted by the person name field and sort by both the department name field AND the person name field.

Thank you for pointing me in the right direction.