[sims] Creating a report for a year group showing subjects, teachers, rooms for diff periods

[JoeS]

I need to create a report showing the following data, with one row for each student in the year.

[TABLE=width: 1623]

[TR]

[TD=class: xl65, width: 186]Student Name[/TD]

[TD=class: xl66, width: 64]Form[/TD]

[TD=class: xl66, width: 118]Subject P1 Tues[/TD]

[TD=class: xl66, width: 118]Teacher P1 Tues[/TD]

[TD=class: xl66, width: 174]Room P1 Tues[/TD]

[TD=class: xl66, width: 125]Subject P2 Weds[/TD]

[TD=class: xl66, width: 181]Teacher P2 Weds[/TD]

[TD=class: xl66, width: 181]Room P2 Weds[/TD]

[TD=class: xl66, width: 140]Subject P5 Monday[/TD]

[TD=class: xl66, width: 140]Teacher P5 Monday[/TD]

[TD=class: xl66, width: 196]Room P5 Monday[/TD]

[/TR]

[/TABLE]

 

I can get a report showing the Room and Teacher like this:

But the Lessons subreport doesn't have any information on subject, and if I try and add a sub sub subreport with this:

It is impossible to filter the classes of the teacher subreport using period, and anyway Sims just crashes if I try and run it unfiltered.

I have always been confused by sub sub sub reports. How can I achieve what I need?

Many thanks.

Edited September 16, 2020 by JoeS

[coolhands]

I’m not on sims now, but doesn’t it have ‘name of the subject’ or something? I’m sure it does

[coolhands]

try this or some version of. seems to have what you want and you can maybe sort out in excel?

 

 

anyway, might help.

[skinsley]

Try this.

I have put the report definition for it if you need it in the attached zip fileStudent Timetable check.zipStudent Timetable check.zip

[JoeS]

Thank you both very much for your help, it was a slight variation on skinsleys report that did it. I needed to filter both the subreport and the sub subreport with the same period and bingo! One line per student.

[coolhands]

go on put a screenshot up so I can try it! If any use I might then save it

[skinsley]

Me too!