Unwanted Page Breaks in Report

C

chammock

I see this topic brought up a lot and I typically can resolve issues in
this area. But after a few hours of troubleshooting I need to see if
anyone else has any ideas. Here is my setup.

Tail Number
Panel
Status
Details
aaa bbbb ccccc ddd
vvvv asds ljkjjljlj ljljjlj
===============================
Totals for this status
Page Footer


Report with Subreport details

Report Header <empty
Page Header < Text only
TaiNumber Group Header < Tail number here <Filtering by Tail, so report
is for one TailNumber
Detail <empty
TailNumberFooter <subreport
Subreport
Panel Group Header <Panel number here
Status Group Header <status here
Detail <test info that is used to derive status for Status Group
Status Footer <total tests for each status
Panel Footer <empty
End Subreport
Page Footer <date and page info
Report Footer <empty

I need to have each page show the Page Header, TailNumber, Panel,
Status and Detail for each Status. I have page breaks setup and it is
working, except that I get an extra break after the Panel.

So on the first page I get:

Fastener Inspection Status
Tail: 111111
Panel: Left
THIS IS WHERE IT BREAKS

Next Page I get
Fastener Inspection Status (text)
Tail: 111111
Panel: Left
Status: Complete
Detailed info is here
Total inspections for this Status
Page Footer
PAGE BREAK, which is what I want.

I only have 2 Panels, Left and Right, but on the first page for each
Panel, I am getting the extra page break.

Thanks for any ideas on solving this.
 
M

Marshall Barton

I see this topic brought up a lot and I typically can resolve issues in
this area. But after a few hours of troubleshooting I need to see if
anyone else has any ideas. Here is my setup.

Tail Number
Panel
Status
Details
aaa bbbb ccccc ddd
vvvv asds ljkjjljlj ljljjlj
===============================
Totals for this status
Page Footer


Report with Subreport details

Report Header <empty
Page Header < Text only
TaiNumber Group Header < Tail number here <Filtering by Tail, so report
is for one TailNumber
Detail <empty
TailNumberFooter <subreport
Subreport
Panel Group Header <Panel number here
Status Group Header <status here
Detail <test info that is used to derive status for Status Group
Status Footer <total tests for each status
Panel Footer <empty
End Subreport
Page Footer <date and page info
Report Footer <empty

I need to have each page show the Page Header, TailNumber, Panel,
Status and Detail for each Status. I have page breaks setup and it is
working, except that I get an extra break after the Panel.

So on the first page I get:

Fastener Inspection Status
Tail: 111111
Panel: Left
THIS IS WHERE IT BREAKS

Next Page I get
Fastener Inspection Status (text)
Tail: 111111
Panel: Left
Status: Complete
Detailed info is here
Total inspections for this Status
Page Footer
PAGE BREAK, which is what I want.

I only have 2 Panels, Left and Right, but on the first page for each
Panel, I am getting the extra page break.
Click to expand...


Check Each section's ForceNewPage property.

Check each group's KeepTogether property.

You may be able to avoid the use of a PageBreak control by
using ForceNewPage in the Status group's Footer section.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Section and Page numbering 0
A03 - count in report footer gives me #Error? 0
MS Word Page Layout/Break/Margin Issues, help 0
"Continued" in Header and Repeat Footers 3
Report/Subreport Problems with Sorting/Grouping, Access 2003 2
Book formatting: need to alternate page number on left and right margin for only first page of each 2
Prevent skip to new page after last page prints 3
Strange page breaks in report 0

Top