Custom reports in SQL 2005 SP2
You may have come across the fact that in SP2 you can
deploy custom reports that are accessible in management studio. This reports can
be run from any context in the object explorer tree.
Whilst I think this is really interesting, I haven't played with it much, but
Anthony has read his blog post on how to
configure a report to run in management studio
-