Bar chart using parameters

[dref]

Hellos.


Am working on a database that uses class and stream aggregates in a school to make bar charts.
However, when i run the main report which has a few subforms and charts filtered thru a parameter unbound form, it gives me errors.
Someone help me please. I have attached a sample file.
Thx

Note:
A)The main report is MONTHLYREPORTUPPER
B)Graph subreports:
1.GraphContD1C3
2.GraphContC6F9

C)Graph Tables
1.TRANSFERGRAPHUPPERC6F9
2.TRANSFERGRAPHUPPERD1

D)Graph Queries
1.QryGraphTESTUPPERD1
2.QryGraphTESTUPPERC6F9

E)Form
frmReports

UPLOAD.zip

[June7]

Opening report in ReportView does not error - the graphs Don't render, PrintPreview errors. Also odd that only two of the combobox references cause error. When these subreports are not included, the report opens without error.

Because the graph RowSource is a CROSSTAB using dynamic parameterized SELECT query, the parameters must be declared with PARAMETER clause in the query or column headings must be specified. Be sure to declare the parameters as integer type. Review http://allenbrowne.com/ser-67.html

[dref]

Thanks but even my charts are not picking the right information. Not even in report view. Could you help with that?
Thx

[June7]

Not without more info on what is wrong. Graphs look fine to me.