Report Detail Section printing twice

  • Thread starter Thread starter Don Seckler
  • Start date Start date
D

Don Seckler

I have a report with 5 subreports. The report has a header. I have
got the report to the point where it's doing exactly what I want
except for one thing. When I preview or print, it produces two pages.
The first page is perfect. The second one is an exact duplicate of
the first one except the report header is not showing (which it
shouldn't, I guess).

I've checked my margins, and there isn't enough data on the report to
force a second page. And as I stated before the data on page 2 is
identical to that on page one.

I double checked the queries that feed each of the sub reports and
they are only each returning one set of data as they should.

What am I missing???
 
Don said:
I have a report with 5 subreports. The report has a header. I have
got the report to the point where it's doing exactly what I want
except for one thing. When I preview or print, it produces two pages.
The first page is perfect. The second one is an exact duplicate of
the first one except the report header is not showing (which it
shouldn't, I guess).

I've checked my margins, and there isn't enough data on the report to
force a second page. And as I stated before the data on page 2 is
identical to that on page one.

I double checked the queries that feed each of the sub reports and
they are only each returning one set of data as they should.

What am I missing???
Click to expand...


It sounds almost as if the main report's record source has
two records. I think you should look at how the main report
records are tied to the subreports. If the main report is
just a container for the subreport, make sure that its
record source property is blank.
 
Bingo! You nailed it Marshall!

Thanks!


Marshall Barton said:
It sounds almost as if the main report's record source has
two records. I think you should look at how the main report
records are tied to the subreports. If the main report is
just a container for the subreport, make sure that its
record source property is blank.
Click to expand...
 
Back
Top