I have a report that contains a cumulative bar chart, based upon the results of a crosstab query. It ought to be a one page report containing one chart.
However, when printing this report it appears to print multiple copies of the same page. Having redesigned the report to incorporate "Page X of Y" notation I see that the report does indeed contain multiple pages of the same chart.
By some spooky coincidence the number of pages is the same as the number of rows in the crosstab query.
Could the report be displaying a chart for each row of the query ?
If so, how do I stop it from doing this ?
However, when printing this report it appears to print multiple copies of the same page. Having redesigned the report to incorporate "Page X of Y" notation I see that the report does indeed contain multiple pages of the same chart.
By some spooky coincidence the number of pages is the same as the number of rows in the crosstab query.
Could the report be displaying a chart for each row of the query ?
If so, how do I stop it from doing this ?