Grouped chart in report shows incorrect data

[astoch]

I have a query which shows schedule adherence data for 10 employees (planners).
I have a report based on the query, with a grouping based on planner.
I have insrted a chart into the header section of the planner group to show the weekly schedule adherence by planner. 3 planner's charts show on 1 page.

Here's the crazy thing:
On the first and last pages of the report, the correct data appears by planner. But in the middle page, the same grpah shows for all 3 planners even though the data is very different in the underlying query.

I am doing something to mess this in the grouping settings? Any help is greatly appreciated.

Thanks
Adrian

 

[Crowley16]

try putting the chart in the body of the planner section, not headder

Crowley - as in like a Crow

 

[astoch]

Yip. Had tried this - good suggestion, but to no avail.

Thanks anyway.
Any other suggestions would be greatly appreciated.

 

[dhookom]

The chart should be in the Planner header or footer and make sure you set the Link Master/Child properties correctly. If you still have issues, check ACG Soft web site for Report tips

http://ourworld.compuserve.com/homepages/attac-cg/.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.