[AccessD] Linking Graph to Report

Following up on yesterday's question, I know that there was a bug with A97 
and linked charts but I am not aware of it still being an issue with AXP.

David

At 22/06/2005, you wrote:
>Access XP adp, SQL2000.
>
>I have a report with a graph on it.  The graph is to show the number of 
>days it took to process client information.  Each month should have its 
>own graph on a separate page.  The reports source is a stored procedure 
>which provides the months as an integer in the form yyyymm.
>
>SELECT ttmpPlanTrackGraph.ConsultPlanFranchise, ttmpPlanTrackGraph.YrMth
>FROM ttmpPlanTrackGraph
>GROUP BY ttmpPlanTrackGraph.ConsultPlanFranchise, ttmpPlanTrackGraph.YrMth
>
>The graphs source is also a stored procedure which includes a field with 
>the month in the same format.
>
>SELECT ttmpPlanTrackGraph.ClientName, ttmpPlanTrackGraph.FranDays AS [Work 
>Days in Fran], ttmpPlanTrackGraph.BurDays AS [Work Days in Bureau], 
>ttmpPlanTrackGraph.ConsultPlanFranchise, ttmpPlanTrackGraph.YrMth
>FROM ttmpPlanTrackGraph
>
>I have set the Link Child Field and Link Master fields both to YrMth.  The 
>report shows a different page for each month, however each graph shows all 
>records, not just the one for the pages month.
>
>How do I get only the relevant month's data showing on each page?
>
>Regards
>
>David Emerson
>Dalyn Software Ltd
>25 Cunliffe St, Churton Park
>Wellington, New Zealand
>Ph/Fax (04) 478-7456
>Mobile 027-280-9348 --