Multi-page report generation

  • Thread starter Thread starter Bill Stanton
  • Start date Start date
B

Bill Stanton

Before I paint myself into a corner, would someone
offer a little sanity check on how to approach the
following.

I have a table containing names, addresses, etc.of
individuals that has a one-to-many relationship with dated
events in another table. The number of dated events for
any given year will range from just a few to no more
than 60 or so.

I need to click a single switchboard choice and generate
as many pages as there are names (records) in the parents
RecordSource. E.g., like a monthly billing statement.

Is the preferred approach to create a parent report
wherein the names, addresses appear and a sub-report
that contains the related events? How does one cause
a new page with each record of the parent?

Thanks,
Bill
 
I would create a single report that groups by the names and page breaks
before each new group.
 
Duane,
Thanks for the suggestion.

Only one problem remains. Where to place the page-break?
When I put it in the group footer, the group appears as desired
but shifts on the page as I advance from one group to the next.
When I put it in the group header, the group positioning on the
page is constant as desired, but, as you would expect, I get a
blank page at the beginning. How do I get rid of the blank
page?

Thanks again,
Bill
 
Got it! the page-break has to be at the VERY bottom of
the group footer, as any white space remaining will transfer
to the next page.

Thanks again,
Bill
 
Back
Top