OK
I have several Pivot Chart forms which I wish to display in a single Report.
So, I open my report and drag and drop the forms onto the Report design view - so far, so good.
I would like each one to appear on a new page and so I have placed Page Breaks between the sub charts.
But this is giving me some really weird results. When I view my report, the first page and chart is OK, the second page with the second chart is OK, but then I get about 8 pages all showing the second chart - but each page shows it progressively smaller as if it is being crushed towards the top of the report page.
Finally, I then get my 3rd chart on about page 11.
Why is this happening? I am going out of my mind.
I have several Pivot Chart forms which I wish to display in a single Report.
So, I open my report and drag and drop the forms onto the Report design view - so far, so good.
I would like each one to appear on a new page and so I have placed Page Breaks between the sub charts.
But this is giving me some really weird results. When I view my report, the first page and chart is OK, the second page with the second chart is OK, but then I get about 8 pages all showing the second chart - but each page shows it progressively smaller as if it is being crushed towards the top of the report page.
Finally, I then get my 3rd chart on about page 11.
Why is this happening? I am going out of my mind.