Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

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

Posted on 2001-08-06
9
Medium Priority
?
211 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
NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

 
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

Enroll in October's Free Course of the Month

Do you work with and analyze data? Enroll in October's Course of the Month for 7+ hours of SQL training, allowing you to quickly and efficiently store or retrieve data. It's free for Premium Members, Team Accounts, and Qualified Experts!

Question has a verified solution.

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

Code that checks the QuickBooks schema table for non-updateable fields and then disables those controls on a form so users don't try to update them.
Instead of error trapping or hard-coding for non-updateable fields when using QODBC, let VBA automatically disable them when forms open. This way, users can view but not change the data. Part 1 explained how to use schema tables to do this. Part 2 h…
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

618 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