Multiple Graphs from a Pivot table

[ChrisProg]

Hi All,

I have a query which produces data for creating graphs:-

TRANSFORM Avg(GraphSelect1.AScore) AS AvgOfAScore
SELECT GraphSelect1.SubjectGroupText, GraphSelect1.AMonth
FROM GraphSelect1
GROUP BY GraphSelect1.SubjectGroupText, GraphSelect1.AMonth
PIVOT GraphSelect1.AYear;


The graph works correctly in a report for the first value of GraphSelect1.SubjectGroupText but does not produce subsequent graphs for other values of this grouping.

Looking at the report detail heading in design, there is no values in the 'sorting and grouping' control and no values in the record source. I think that these controls need to be populated in order to produce a report page for each value of GraphSelect1.SubjectGroupText.

The pivot table can I think have up to 3 levels of row heading and I can only think that these row headings are provided to enable reports to have grouping.

Can anyone advise how to make this work?

Thanks in advance.

Chrisprog.