SSRS nested report query

[toksoladuti]

Hi, I'm trying to create a single report (please see attached mock-up), which takes data about our students, issued penalties and issued detentions, and displays them, grouped by Form, then Student and showing a list of penalties and then a list of detentions. I've zipped up a mock-up, the SQL query I'm using and a sanitised query result. Any help would be greatly appreciated.

Thanks.

 

[Patty201]

Do you need it in SSRS, create your connection an buitl your dataset base on your query...