Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    Jan 2002
    Location
    Wisconsin
    Posts
    9
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Report Charts not 'Keeping Up' (2000)

    Hello gurus...we have a relatively large (20MB) database that is very "calculation-intensive" that produces some fancy looking reports complete with graphs. In Access 97, it worked well without a hitch. However, we have recently made the leap to Office 2000 and when it got converted, something strange is happening. When I print the report, it appears that the graphs cannot keep up with the raw data displayed. For instance, the numbers may range from 4-5 on the report, but the graph MAY show the numbers from the previous record, which could range from 65-75 (the report is ~700 pages). I say MAY show previous data because I could simply close the report, open it up again, and the same page could be correct this time. So, page 2 and 3 could be wrong one time, but right the next time when page 7 and 8 are wrong. Sorry for the long note, it's a tough one to explain.

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Report Charts not 'Keeping Up' (2000)

    I've seen a lot of strange behavior with graphs in Access, and Access 2000 doesn't appear any more prone to that than Access 97. One question is whether the chart that prints for those pages is the same as what you see on the screen. I've seen Access 97 charts come up displaying the default data and print the correct information!
    Charlotte

  3. #3
    4 Star Lounger SteveH's Avatar
    Join Date
    Jan 2001
    Location
    Chelsea, Gtr London, United Kingdom
    Posts
    587
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Report Charts not 'Keeping Up' (2000)

    I found exactly this problem with Report Charts which was down to the Operating System.
    On Windows 98 and NT4 the Report Charts worked perfectly but on Windows 2000 they were displaying wrong data or no data.
    It seemed random as to which record's Reports were wrong. <img src=/S/scratch.gif border=0 alt=scratch width=25 height=29>
    I found no way of overcoming this behaviour so ended up re-creating the Charts using code. <img src=/S/surrender.gif border=0 alt=surrender width=31 height=23>
    (I haven't tested on WindowsXP)
    Steve H
    IT Lecturer/Access Developer
    O2K SR3/O2010; Win7Pro

  4. #4
    New Lounger
    Join Date
    Jan 2002
    Location
    Wisconsin
    Posts
    9
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Report Charts not 'Keeping Up' (2000)

    Thanks much for your help...I'll give it a try on an NT machine and see if that helps.

    Take care!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •