Report Charts not ‘Keeping Up’ (2000)

Topic

New Reply

Hello gurus…we have a relatively large (20MB) database that is very “calculation-intensive” that produces some fancy looking reports complete with graphs. In Access 97, it worked well without a hitch. However, we have recently made the leap to Office 2000 and when it got converted, something strange is happening. When I print the report, it appears that the graphs cannot keep up with the raw data displayed. For instance, the numbers may range from 4-5 on the report, but the graph MAY show the numbers from the previous record, which could range from 65-75 (the report is ~700 pages). I say MAY show previous data because I could simply close the report, open it up again, and the same page could be correct this time. So, page 2 and 3 could be wrong one time, but right the next time when page 7 and 8 are wrong. Sorry for the long note, it’s a tough one to explain.

Reply | Quote

Replies

I’ve seen a lot of strange behavior with graphs in Access, and Access 2000 doesn’t appear any more prone to that than Access 97. One question is whether the chart that prints for those pages is the same as what you see on the screen. I’ve seen Access 97 charts come up displaying the default data and print the correct information!

Reply | Quote

I found exactly this problem with Report Charts which was down to the Operating System.
On Windows 98 and NT4 the Report Charts worked perfectly but on Windows 2000 they were displaying wrong data or no data.
It seemed random as to which record’s Reports were wrong.
I found no way of overcoming this behaviour so ended up re-creating the Charts using code.
(I haven’t tested on WindowsXP)

Reply | Quote

Thanks much for your help…I’ll give it a try on an NT machine and see if that helps.

Take care!

Reply | Quote