Detail data gets replicated

[rich.barry]

I have a report which has 3 sub reports in the detail section.
Each sub report is just a different view of the same set of records, i.e. Count, Volume and %. Each sub report is based on an individual query to generate data in the right units.

I'm finding that on once the report extends to the second page, it repeats all the detail a second time.

Is anyone able to enlighten me as to the cause and the fix?

Thanks

Richard

 

[rich.barry]

Good work Pat. It's functioning fine now.
Actual cause was a totally unrelated query in the record source for the main report, there due to my taking a copy of an existing report and modifying it to this new one.

Thank you very much

Richard