Microsoft recently released SQL Reporting Services, a reporting tool that comes free with SQL Server 2000.
I've been dabbling in SRS recently. It's a fairly robust reporting tool. Designing reports is done in Visual Studio .NET, and reports are deployed to the web.
Using the Report Wizard, I was able to quickly build a report based on some data in my SQL Server database. I did find it rather difficult to make changes to the report once the wizard created it. For that reason, when I needed to make changes, I found it easier to just create a new report with the Wizard and included the changes there.
The next step will be to deploy the reports to our production web server (instead of my laptop).