• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 216
  • Last Modified:

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!
0
DavidLeeding
Asked:
DavidLeeding
  • 3
  • 2
  • 2
  • +2
1 Solution
 
TheNextStepCommented:
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?

0
 
PsychoDazeyCommented:
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
0
 
nico5038Commented:
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)
0
Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

 
DavidLeedingAuthor Commented:
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.


0
 
TheNextStepCommented:
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.
0
 
TheNextStepCommented:
the_next_step@hotmail.com
0
 
PsychoDazeyCommented:
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.
0
 
nico5038Commented:
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)
0
 
NetminderCommented:
Per recommendation, points refunded and question closed by
Netminder
CS Moderator
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

  • 3
  • 2
  • 2
  • +2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now