CMIS Teacher and Student Class Data

[danIT]

I need some help, I need to reports to pull out some data for Students and Teachers.

 

For Teachers it needs to include:

Title

Forename

Surname

TeacherInitials or DFES No

Year

Reggroup

SubjectCode

Class

 

Pupils:

Gender

Forename

Surname

Admission Number

RegGroup

Year

SubjectCode

Class

 

I've got some reports which do portions of this but not all, any chance anybody has anything existing with a screen shot or example of the result?