As I’ve posted before, (and Jay has recently concurred),  SQL Server reporting services is very cool.  Some people think that it is an extension of SQL Server.  What you may not know is that it is an ASP.NET library that installs on your web server.  It also has a designer add-in for designer reports (very simple to use like MS Access reports) for VS.  The reports are deployed to the web server, and served through a new ASP.NET HTTP Handler.  You can put .Net code in them and fully integrate a report with your web application.  One thing I plan to do in the future is take a screen where formatting has to be pretty and make a report from it.  Then I’ll automatically get the cool features like export to Excel, PDF, .tif, CSV, etc.