Access 97 report charts duplicate in print preview
Posted on 2004-08-18
I have an Access 97 database that does some reporting. This particular report involves charts.
The design of the report has 1 detail section, and within the detail section is a group footer which groups the data. The data is grouped and displayed on a chart. When this report printed to the printer, it has four pages of charts. On pages 2 and 3, two different charts print on each page - one on the top half of the page and a different one on the bottom half of the page. The problem is that when the same pages are viewed in print preview, the same chart at the top of page 2 is duplicated on the bottom half of page 2. On page 3 in print preview, the same thing occurs...the first chart on page 3 is repeated (duplicated) on the bottom half of page 3. However, when the report prints to the printer, the correct, different charts print.
I believe the problem lies with the group footer and may have something to do with the OnFormat event. But after spending nearly three days trying everything under the sun to make the correct charts print in both print preview and on the printer, the only resolution I have been able to come up with is to do NewRowOrCol Before Section which forces each chart to print on a separate page. When each chart prints on its own page, the print preview and hard copy printing are fine. I would like to see if I can come up with something that would allow two charts to print to a page.
Any ideas would be appreciated as I am stuck as to what may be causing this. Thanks.