Some time ago Jonathan Hambrook has written an article about Designing a new Report in SCOM 2007 . Although this is great article you need to have some prerequisites ready to get started with Designing your new OpsMgr 2007 Reports. Here are the prerequisites:
