I got sent an article the other day which is on Twynham School who have implemented SharePoint 2007 in their school and used SQL Server 2005 Reports to give students and teachers live access to reports, timetables and grades etc
Have a look at the article and leave any comments you may have.
I personally think that have done a great job and look forward to meeting up with the guys from the school.
Download and view it here. Click Here