Link to home
Start Free TrialLog in
Avatar of DavidLeeding
DavidLeeding

asked on

Charts that don't display the correct values *on screen*

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)

Thanks!
Avatar of TheNextStep
TheNextStep

I have not come across that one yet, and I do not know of any service release/patch/fix/tweaks that address that issue.  My reports seem to work fine in Access 2000.  Have you tried re-installing Access?

I have always found the charting portion of Access to be cumbersome and awkward to work with.  I prefer to create my charts automatically through Excel, the charting of Excel is far easier to work with and has more formatting capability.  This article explains how to do this automatically through Access2000:
http://support.microsoft.com/support/kb/articles/Q202/1/69.ASP?LN=EN-US&SD=gn&FR=0&qry=charts&rnk=1&src=DHCS_MSPSS_gn_SRCH&SPR=ACC2000
Hi David,

I've had my share of trouble with the graphs too.
I would try in this sequence:
1) Compact & repair database
2) Export the report (File/save as) to another database, delete the report and import it again (File/Get externaldata/Import)
3) Just rebuild the report from scratch ;-(

Nic;o)
Avatar of DavidLeeding

ASKER

All,
Thanks for the suggestions. Sadly, I've already tried:

* Reinstalling Access 2000
* Compacting/repairing
* Rebuilding the database by exporting tables/reports etc
* Rebuilding the reports from scratch

Sigh.

I might explore the Excel option...but this application is for use by unskilled operators who want to click a button and see a pretty picture!

Thanks again.


At least that shows we are on the same wave length.  If you would like to send me a copy of your database by e-mail, I would be happy to take a look.  I've got some extra time on my hands anyway.
the_next_step@hotmail.com
The excel option can create the charts at the click of a button.  I have an app that does just that, the operators do not have to do any tweaking of the charts.
for DavidLeeding

It's time to clean up this TA, so I will leave a recommendation in Community Support that this question is:
 - PAQ'd and pts refunded
Please leave any comments here within the
next seven days.

PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER !

Nic;o)
ASKER CERTIFIED SOLUTION
Avatar of Netminder
Netminder

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial