Ad-hoc Reporting Tools


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
-          Web-based
-          Export capabilities (ability to export the report to pdf and excel)

Any help is appreciated.

Many Thanks for your time.
Who is Participating?
louislietaerConnect With a Mentor Commented:
This one may help you
Jeffrey CoachmanConnect With a Mentor MIS LiasonCommented:
You have some pretty strict crieria here.

My guess is that you will have trouble finding one product that will do them all.

Have you looked into all the products and versions that Crystal Reports (Business Objects) has to offer?

I know for certain they meet criterias 2-6.

cthulthuConnect With a Mentor Commented:
Also check out R&R Report Writer (ReportWorks)
pnadakuditiAuthor Commented:
Hello Experts,

Many thanks for all your inputs and time. We have decided to go with the Report Builder itself that comes with SQL Server as we have very little time available and since Report Builder already meets all the other requirements except the creation of templates.

There is also eWebReports. Look at
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.