you mean a matrix? i have already put that together (couple of years RS exp.). The issue is to do with the length of the period
This is what i want . ...........9.............10...........11..........12...........1...........2..........3............4...........5.........6
Mon maths english
Tue SSRS tutorial
Wed French
Thur science
Fri tutorial
- Student may only have lessons on Mon, Tue, Fri (got this to work by unioning data from a timetable setup table
- Sessions might not be hour based eg Monday period 2 starts at 10 but oon a friday it starts at 1020
Matrix seems to work but if a student has a 15 min tutorial, this fills a whole column the same as a hour eg
..........9.............10.........1045.........11..........1115......12...........1...........2........
Mon maths english
Tue SSRS tutorial
Wed French
Thur science
Fri tutorial