need to limit report to one person/page

[shiner]

My report lists equipment that is checked out by individuals belonging to athletic teams. I am trying to print a report for an entire team. When I run the query, the results are correct, but the report shows them all on one page rather than each person having their own page.

The individual's information is contained in the header, and then the line items are in the body. What is happening is all of the returned line items just continue down the page - reguardless of who checked them out, and when that page is full, it carries over to the next page - with a new person's name at the top.

How do I get the equipment that is listed on that page (items checked out) to match up with who's information is at the top of the page?

The report is based on a query. The query is filtering between 3 tables - people info, equipment info, and what's checked out. The criteria fields sort the gender matching the request and the team name matching the request. So, the idea is to print a report that lists what varsity females have out - and generates one page per person with what they have.

I think I am close, because the query returns what I am looking for, it is simply a matter of me setting the form up correctly.

Thanks!

 

[ddmcn]

Grouping

Shiner,

I 'presume' that your report is grouped on player. Try putting a page break in the group footer. That should do the trick.

 

[shiner]

Dennis,
Thanks for pointing me towards grouping. After I posted, I attempted to mess with a sub report, linked to the header data - but no luck there.

After your suggestion, I grouped the info based on personnel_ID - and now I am closer. I am having trouble with where in the report to set the page break. The info now is generated in a continuous format, and is broken up by player, but there is still not a seperate page per person. Closer, but not there yet.

 

[shiner]

Ok,
The KEEP TOGETHER property is what needed to change next. This fixed my problem. Thanks for tipping me off to groupings!