Blank page problem

[Ray Cacciatore]

I have a main report with three subreports. The problem is that the first
subreport shows up with a blank first page. When I ran the subreport alone, I
noticed that Access forces a new page because there is a section where I have
KeepTogether="Entire group" in the Sorting and Grouping window of the report.
Which is what I want...When I look at the data, it's because the details of
the section does not fit on the first page so Access forces a page break.
Whay does Access do that on the first page? I tried changing the property to
"With first Detail". That solves the problem but the section's footer appears
alone at the top of the page later in the report, which is the reason why I
put "Entire group" in the first place.

Any suggestions?

Ray

 

[Marshall Barton]

I have a main report with three subreports. The problem is that the first
subreport shows up with a blank first page. When I ran the subreport alone, I
noticed that Access forces a new page because there is a section where I have
KeepTogether="Entire group" in the Sorting and Grouping window of the report.
Which is what I want...When I look at the data, it's because the details of
the section does not fit on the first page so Access forces a page break.
Whay does Access do that on the first page? I tried changing the property to
"With first Detail". That solves the problem but the section's footer appears
alone at the top of the page later in the report, which is the reason why I
put "Entire group" in the first place.

Most likely, the blank page is caused by something on the
first page. Maybe the report header section? Check if the
report header section is visible and its Height is > 0.

It might also be that you have a section with ForceNewPage
set.

An easy way to see what's using what part of a peage is to
set each section's BackColor to a different color.