Sub-Report Data Times 4

[Ed S.]

I've got a sub-report that is pulling information from a related, but
different table from the main report. The master/child link is correct, I've
checked it ten times. When I pull up the sub-report by itself, the
information is correct. However, when I pull up the report, it shows every
record on the sub-report 4 times, as if each item has been entered 4 times.

Has anyone encountered this or do you have any suggestions?

Thanks!

 

[Marshall Barton]

I've got a sub-report that is pulling information from a related, but
different table from the main report. The master/child link is correct, I've
checked it ten times. When I pull up the sub-report by itself, the
information is correct. However, when I pull up the report, it shows every
record on the sub-report 4 times, as if each item has been entered 4 times.

That's the kind of thing that can happen if the main
report's query includes the table used by the subreport.
Try opening the main report's query by itself and check if
this is what's causing it.

 

[Ed S.]

Nope, the query for the main report is based on one table, the subreport is
based on the other. Any other ideas?

Thanks!

 

[Marshall Barton]

I still think the likely cause is that the linking field in
the main report occurs more often than you expect. The best
way to check if that's the case is to open the main report's
record source in sheet view and carefully inspect the
records.

If that's not it, then all I can suggest is look at what
else is different when the report is used as a subreport.
The obvious things are that page related actions are not
invoked in a subreport and the Link Master/Child properties
are introduced into the equation.