Parameter Report with a Chart in the footer

[JimAA]

I have a Report that displays Job Name, Job Cost and Fiscal Year in the
Detail Section. There is a Sales Rep header and a Sales Rep footer. The
header displays the Sales Rep's name and the Sales Rep footer displays a
chart showing their sales over a selected period of time. The report is
based on a query and is opened by a form where the user enters a Start Year
and an End Year. The detail section gets filtered properly but the chart
ignores the selected period of time and displays the sales from all records.
How do I get the chart to use the same records that the Detail uses? I've
played around with the chart's SQL and can't figure it out.
This is the chart's row source:
TRANSFORM Sum([SumOfSum Of TOTAL CONTRACT AMOUNT]) AS [SumOfSumOfSum Of
TOTAL CONTRACT AMOUNT] SELECT [Fiscal Year] FROM [Jobs By Sales Rep (fiscal
year total only)1] GROUP BY [Fiscal Year] PIVOT [Sales Rep];

Thanks

 

[Duane Hookom]

Make sure your Chart Row Source uses the "form where the user enters a Start
Year and an End Year". Also make sure the form isn't being closed by any code
in the report.