grouping & inserting page breaks

[agtjazz]

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, 2006 by Guest

[Matt Klein]

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.

[agtjazz]

Thank you for pointing me in the right direction.