I am trying to show the following data from one table in a summary report:
Grade (this is generated by a calculation, result is A, B, C, D, E)
sGradesCount (summary field - count of grade, summarise repetitions together)
The report should show how many grades were given in each year ie Yr 10 - A =4, B=6 etc but when i run the script created by the wizard i have the year, the grade field is displayed but only showing one grade if at all and the count is a total count for that year group. This information is in a subsummary when sorted by Year.
Any help greatly appreciated