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".