John Marcum has created a nice blog post for how to get started creating your own SQL based web reports. 

Read his full post here.

There are often questions on the forums about writing reports and SQL queries for SCCM. These are often people who have no SQL experience at all. There’s no easy way to learn to write these reports but I’m going to show you how I learned to do it and how I still do many of my reports today.