Subreports repeating on a page

  • Thread starter Thread starter MGregory
  • Start date Start date
M

MGregory

I have built a report with subreports. The subreports for the same record
repeat 2, 3 even 4 times in the printout. What is causing this?
 
MGregory said:
I have built a report with subreports. The subreports for the same record
repeat 2, 3 even 4 times in the printout. What is causing this?
Click to expand...


That's almost always because the main report's record source
query joins to the same table as the subreport's record
source. Change the main report's record source so it only
retrieves data that belongs in the main report, This is
usually easiest if you work with the query alone so the
report doesn't confuse things.
 
I had one query that gathered info from the various tables, and the main
report and the subreport were all based on that one query.

So, I created a new query that just gathered the info for the main report,
but now none of the subreports are showing.

Should each subreport be built on a separate query? Is that where I'm going
wrong? Thanks.
 
MGregory said:
I had one query that gathered info from the various tables, and the main
report and the subreport were all based on that one query.

So, I created a new query that just gathered the info for the main report,
but now none of the subreports are showing.

Should each subreport be built on a separate query? Is that where I'm going
wrong?
Click to expand...


That depends on what the subreport are supposed to display,
but it is common for different subreports to use different
record source queries.

Check the subreport controls' LinkMaster/Child properties.
They may have been cleared or maybe you forgot to include
the linking field(s) in some of the queries.
 
Back
Top