agtjazz Posted June 17, 2006 Share Posted June 17, 2006 (edited) 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 Link to comment Share on other sites More sharing options...
Matt Klein Posted June 17, 2006 Share Posted June 17, 2006 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. Link to comment Share on other sites More sharing options...
agtjazz Posted June 20, 2006 Author Share Posted June 20, 2006 Thank you for pointing me in the right direction. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6514 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now