Solved

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

Posted on 2001-08-06
9
201 Views
Last Modified: 2012-06-27
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
Comment
Question by:DavidLeeding
  • 3
  • 2
  • 2
  • +2
9 Comments
 
LVL 1

Expert Comment

by:TheNextStep
ID: 6359301
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
 
LVL 6

Expert Comment

by:PsychoDazey
ID: 6359500
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
 
LVL 54

Expert Comment

by:nico5038
ID: 6360933
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
 
LVL 1

Author Comment

by:DavidLeeding
ID: 6361781
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
Complete Microsoft Windows PC® & Mac Backup

Backup and recovery solutions to protect all your PCs & Mac– on-premises or in remote locations. Acronis backs up entire PC or Mac with patented reliable disk imaging technology and you will be able to restore workstations to a new, dissimilar hardware in minutes.

 
LVL 1

Expert Comment

by:TheNextStep
ID: 6362147
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
 
LVL 1

Expert Comment

by:TheNextStep
ID: 6362151
the_next_step@hotmail.com
0
 
LVL 6

Expert Comment

by:PsychoDazey
ID: 6363954
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
 
LVL 54

Expert Comment

by:nico5038
ID: 6996584
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
 
LVL 5

Accepted Solution

by:
Netminder earned 0 total points
ID: 7014494
Per recommendation, points refunded and question closed by
Netminder
CS Moderator
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Suggested Solutions

In Debugging – Part 1, you learned the basics of the debugging process. You learned how to avoid bugs, as well as how to utilize the Immediate window in the debugging process. This article takes things to the next level by showing you how you can us…
Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

707 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now