Solved

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

Posted on 2001-08-06
9
208 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
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
 
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

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
Access custom database properties are useful for storing miscellaneous bits of information in a format that persists through database closing and reopening.  This article shows how to create and use them.
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
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