Custom reports are not only the domain of Orion custom report writer. SQL Reporting Services also provides a valuable method of creating custom reports. This document provides an introduction to what is possible - including an example of providing graphs within your reports.
Dave.