[AccessD] Linking Graph to Report

David Emerson newsgrps at dalyn.co.nz
Tue Jun 21 20:24:57 CDT 2005


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 


More information about the AccessD mailing list