Report using MS Graph 2000 - graph not updating for each record

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a report on benefits for each employee. The report shows lots of data
and has a graph (pie chart). It is grouped by employee so each employee
receives a 2 page printout. When opening the report and printing the report,
all the data shows up correctly, but sometimes (not always), the graph gets
hung and the report will print the same graph for each employee. There are
about 2000 employees, so the report might get the first 1000 correct, then
the rest of the pages printed contain the wrong graph. The only fix is to
look at each report page individually before printing and to run the report
again if it hangs. Any ideas for me on how to fix this?
 
There are some tips at http://ourworld.compuserve.com/homepages/attac-cg/.
Code sample from their site:

Add the following Visual Basic code to the On Print event of the section of
the report that contains the Graph object.

On Error Resume Next
Dim objGraph As Object
Set objGraph = Me!TheNameOfYourGraph.Object
objGraph.Refresh
DoEvents
Set objGraph = Nothing
 
Back
Top