Report Page Breaks

[Paul Axelrod]

I am having some difficulty to get data details to break to the next
page in a report.
I have a Label in the Report Header section, Field Headers in the Page
Header section, a field in a the VendorNumber section, I grouped the
report by this field, and five fields in the Details section. Each
VendorNumber has multiple rows in Details.
As you look down the page, if the row by row details have not finished
at the bottom of the page, they break to the next page. I would like
to have data for each VendorNumber remain on the same page. I have
played around with the Page Break tool in the ToolBox but cant get
that to work.
How can I keep the detail data together, such that if it is not
complete at the bottom of the page, the entire data set for that
VendorNumber will go to the next page. No Vendor data set is to large
to fit on one page.
Thanks for any guidance.
Paul

 

[MacDermott]

Look at the KeepTogether property of each section of your report.

HTH
- Turtle

 

[Rolls]

In situations like this I leave the report header blank and put my headers
on each page. It sounds like you want to force a new page break after each
[VendorNumber] so that the detail for each new vendor starts on a new page.

To do this in report design view right-click on the horizontal bar above the
detail line > Properties > Format > Force new page > select "After section."

 

[George]

Take a look at the book called "Access Cookbook" put out
by O'Reilly. Chapter 3 has a section that may answer your
question, "Keep a Report from Breaking at an
Inappropriate Place". There a probably other solutions as
well but at least the records are separated by page
breaks.

 

[Evi]

Have you tried this?

Click the Grouping Button in Report Design. Click on your VenderNumber,
which should be in there.
Look down and next to where it says Keep Together choose Whole Group.
Evi