Report Page Breaks

Forcing New Page After Each Record "Group"

Larry H wrote:

>

> I have a report that has its data "grouped" sort of like a one-to-many

> relationship, though it's not based on a query with multiple tables in

> a one-to-many relationship. The report is merely grouped that way

> under "sorting/grouping" options. The report is grouped by PROJECT

> MANAGERS, with different PROJECTS appearing under each manager's name.

>

> What I am trying to do is to have the report sort of "know" if the next

> PROJECT MANAGER has too many projects to fit on the remainder of that

> page (they average 3-7 projects per manager) and thus automatically

> trip to a new page at that point.

>

> I do NOT want it to print every project manager on his/own page, I just

> want it to force a new page at the right place as I described. Is this

> possible?

>

> --

> Larry R Harrison Jr

>

> Sent via Deja.com

Author: John Spencer <spencer@chpdm.umbc.edu>

Yes, it is possible. In the Grouping and Sorting Dialog, highlight your

Project Manager field. One of the available properties at the bottom is

"Keep Together". Use that and set it to "Whole Group".