Chart averages in report

[ivica31]

I've created a report that calculates averages on certain scores based on certain tests. The averages are created within the report (eg average text box =Avg[Score]). This all works fine.

I don't understand how to create a bar graph based on the averages. Whith the chart wizard, it only allows me to select fields from a table or query. I need to select it based on the report itself. Because the report is based on parameter query that uses a form to enter the criteria I am unable to use the same query because of an error message that appears on the query( Something to do with Between[Form]![Name]![Start_Date] And [Form]![Name]![End_Date]

If anyone has any ideas, I would be very grateful

Thanks

 

[richary]

The approach I would use is to desgin a sub-report containing your chart. Base teh charts information on a query which gnerates the averages you need. You can base yoru averaging query on the query you used for the main report.