Second sub report duplicates

[kbestle]

I have a report that has three sub reports based on the same data. I would add that there is no master child links between the data. This is not a one to many representation of the data. The first two sub reports are actually forms consisting of pivot charts. The third is a standard report that shows the data that the two preceding charts represent. These all reside in the detail section of the report.

The problem I am having is the second chart prints multiple times. Each time getting squished vertically more each time. The third sub reports prints correctly.

What I want is chart one on page one, chart two on page two and pages three on show the detail data.

Thanks

 

[dhookom]

It sounds like the report has a record source with multiple records. If so, try remove it.

If that doesn't fix the issue, please tell us more about your report record source and sections.

Duane
Hook'D on Access
MS Access MVP