Chart not synced with data

[Jim]

I have a report based on a query that shows customer number, year, total
sales, grouped by customer number. In the footer of the customer number
I have a graph created using the graph wizard.

It usually works BUT sometimes it shows data from a prior or future
customer numbers. Sometimes it repeats the same chart twice then goes
on to sync back up again.

The link child and master is customer number.

I've tried putting the chart else where in the report. I've started
from scratch all the way back to the query and still get the same results.

Jim

 

[Guest]

From www.groupacg.com -> Tips

1) Problem: When the report is previewed or printed, Graph doesn't display
the proper data from its record source, instead it displays either the data
from a prior record or the sample data in the Graph data sheet:

Solution:

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

 

[Al Campagna]

Jim,
This is a known problem. Something to do with Access data update versus
the chart update.
I usually don't get too concerned about it, as long as the chart displays
correctly in Print Preview.
But, every once in a while I...
Run the query behind the Chart.
Select ALL in the query result table.
Paste that into the spreadsheet associated with your chart.
That will re-sync them.
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

 

[Jim]

Thanks you guys are great!! Works!

From www.groupacg.com -> Tips

1) Problem: When the report is previewed or printed, Graph doesn't display
the proper data from its record source, instead it displays either the data
from a prior record or the sample data in the Graph data sheet:

Solution:

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

-- Duane Hookom Microsoft Access MVP