John Marcum MVP wrote an awesome beginners guide to generating ConfigMgr 2007 reports using SQL 2008.
Well, I did something like this a while back, and the only reason I bring it up, is not to steal some of Mr Marcums thunder, but because I wrote it for SMS2003 using SQL 2000!
http://wmug.co.uk/blogs/r0b/archive/2008/04/15/sms2003-how-to-easily-create-reports-for-reporting-first-timers-and-the-like.aspx
To make it even more exciting (challening) I put the article into a Word document, zipped it up and put it on the WMUG website ... don't ask!
Read the complete post at http://wmug.co.uk/blogs/r0b/archive/2011/05/20/configmgr-2007-sql-2008-reporting-made-easy-by-john-marcum.aspx