I have a suite of reports that are grouped on one field (let's call it "Region"), and include header and footer bands. In the group Footer, I have a chart object that represents values displayed in the "table" generated by the Detail band. (I'll refer to this as the "table of values").
There are often many Regions selected for the report, so there are usually two or three charts per page.
While the first page is always fine, the charts in subsequent pages often don't match the table of values at all. Sometimes it seems that the chart is sourcing data from a different table of values (ie another region); other times the chart seems to be just a duplication of the first chart on the page.
Here's the odd bit: if I *print* a hard copy of these reports with "wrong" charts, the printed result is *perfect*. No errors at all! The charts are exactly as they should be.
This occurs consistently in several reports. Given that the charts *print* correctly, I have theorised that there is something buggy in the charting components used by Access 2000, and I'm wondering if anyone else has come across this too.
Does anyone know of any service release/patch/fix/tweak that will cure this?
PS I'm using Access 2000 (9.0.3821 SR-1)