I recently wrote up a review of my experience with OfficeWriter – an easy to use and powerful tool for writing reports with Excel and Word.
One of my largest projects last year was a data warehouse and reporting solution build entirely with SQL Server and SQL Server Reporting Services. SQL Reports is really easy to work with (if you can build an report with Access you can use SQL Reports) but I wish I knew about OfficeWriter during the project.
This tool is what I would have recommended the business users learn for writing ad-hoc reports.
If you are building reports for your solutions, I think this article will be worth your time.