detail part loops

[Ann]

We have a report,
In the detail section, there are two subreports.

The report should come out only two pages. But it comes
out about 70 pages. and every two pages look the same.


It seem the detail part(the two subreports)loop again and
again.

Can't find the reason.

Thanks for suggestions

 

[Rick Brandt]

We have a report,
In the detail section, there are two subreports.

The report should come out only two pages. But it comes
out about 70 pages. and every two pages look the same.


It seem the detail part(the two subreports)loop again and
again.

Can't find the reason.

What RecordSource is the parent report bound to? Anything in the detail section of a
report will repeat once for every record in the underlying RecordSource. If the
RecordSource has 35 records, then your subreports will each run 35 times.