I need some help with creating reports in SIMS. I don't know haw to get a report with several grades per pupil grouped togetrher.
I want to define a report that groups pupil's results all together that has a pupil's grades grouped together, like this:
Jane Green
Reading 1b
Writing 1a
Speaking 2b
Listening 1a
Number 1c
etc
and also a report thnat does this:
Reading Writing Speaking Listening Number......
Jane Green 1b 1a 2b 1a 1c
Helen Jones 1a 2c 1a etc
John Smith 1a 1a etc
Jane Smith 2a 3a
At the moment all I can get is a list:
Student Subject Grade
Jane Green Reading 1c
Jane Green Writing 1c
Jane Green Speaking 1c
Jane Green Listening 1c
Jane Green Number 1c
Jane Green SSM 1c
Jane Green etc 1c
Jane Green etc 1c
Jane Green etc 1c
Jane Green etc 1c
Helen Jones Reading 1a
Helen Jones etc
Helen Jones etc
Helen Jones etc
Helen Jones etc
Helen Jones etc
Helen Jones etc
Helen Jones etc
Helen Jones etc
Helen Jones etc
I have SIM.net set up with marksheets, each markeheet is a classlist with 1 grade per pupil, eg:
Class 1
Student Reading
Jane Green 1b
Helen Jones 1c
John Smith 2c
Jane Smith 1a
These are repeated for each class. Then there are other subjects:
Class 1
Student Number
Jane Green 1c
Helen Jones 1a
John Smith 1a
Jane Smith 2a
So there are about 10 per class and about 20 lasses, so 200 altogether.
Hope someone can help, thanks.