Chart within report

[CC]

I have created a chart that shows % of productivity for
about 13 people - each report has details of the data
within the chart. When you move from page to page you
have a different rep with detailed information as well as
his/her chart. Linking field between the report and the
chart is by DataRep (firstname and lastname)-- I know that
is completely incorrect but it was set up that way before
I got this position.
My issue is that when the department head runs the reports
the charts or not for the individual in the actual report -
but when I open the report on my PC the charts match with
the datarep on report. Any ideas?
I did recreate the chart and my next step is to re-create
the query behind the report as well as the report. CC

 

[SA]

CC:

Yes, the problem is that the chart is not properly refreshing data; its
actually a timing problem that can be solved by adding the following code to
your report in the On Print event of the section that contains the chart:

Dim objChart as Object
Set objChart = Me!NameOfTheChartControl
objChart.Refresh
Set objChart = Nothing