Just had a call from McKesson (a pharmaceutical company). They had a requirement for the creation of fairly complicated multi-section end user reports by non-technical people. My final recommendation was to use the development tools that come with SQL Server Express Edition to design the reports.
One thing to note: To have full design functionality for reports, the SQL Express Toolkit also needs to be installed on the developer machines. You can get this toolkit from
For more information, see: