Jimmy Harper has written some really cool reports for making ACS data more useful, and these can be used as templates for creating your own similar reports. Get them here:
For a primer on writing your own reports – check our Ryan Andorfer’s site “Living with SCOM”. He has a picture filled walkthrough of using the version of visual studio that comes with SQL to easily write your own custom report. This is a blog that shows a lot of promise.