The more I've played with this (and made some interesting discoveries along the way, thanks for hte pointers guys!) the more I realise that trying to build a homegrown solution might not be the best approach. I keep going around in circles as to the best way to do this, I think it might be more sensible to dedicate some time to learning MS Project - trying to create my own project management solution is probably going to snowball out of control and end up with me spending ages building it rather than actually project managing!

Thanks for the feedback guys, @lowell, that's an interesting approach, something I think we pretty much achieve with SSRS either via Report Manager, file share subscriptions or email subscriptions, I keep telling people reports shouldn't really be full data dumps but it seems to work out okay!