This is an adventurous project and not one I would tackle as a beginner...!
Your biggest difficulty here is that the Registration data is held entirely independently of the Timetable data.
There's an easyish way to achieve your example output (Name, P1, P2, P3) with set names in the columns, but tying that to room information is trickier.
You might normally think to tie various tables together based on the txtRegistrationGroupName in vwRegistrationSchoolRegistrationAttendance, and look up which set code matches that in a table like TblTimetableManagerSchedule (e.g. txtCode) .. but classes can be timetabled into different rooms over the course of a week, so that won't work.
I've not got a solution for you, but I can see many of the hurdles you are facing. Whatever the solution is, I'm afraid it extends far beyond any beginners guide on SSRS/SQL.
Have you had any further luck this half term?
