We have a client with a requirement to have an ad-hoc reporting system. We were going to use Microsoft Reporting Services but the Report Builder for 2005 and 2008 will not allow us to save a report with headers/footers as a template. The client wants to be able to open the tool and already have their header/footer in the report with the ability to drag data fields onto the report. Are there any other reporting tools with the below requirements?
- Creating templates ( to include headers, footers, logos)
- Have simple user interface to create reports
- Integrates with Sql Server 2005
- Ad-hoc reporting
- Export capabilities (ability to export the report to pdf and excel)
Any help is appreciated.
Many Thanks for your time.