[Last Call] Learn how to a build a cloud-first strategyRegister Now


Ad-hoc Reporting Tools

Posted on 2009-04-24
Medium Priority
Last Modified: 2013-11-28

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.
Question by:pnadakuditi

Accepted Solution

louislietaer earned 504 total points
ID: 24226623
This one may help you

LVL 74

Assisted Solution

by:Jeffrey Coachman
Jeffrey Coachman earned 498 total points
ID: 24230058
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.


Assisted Solution

cthulthu earned 498 total points
ID: 24244786
Also check out R&R Report Writer (ReportWorks) http://www.livewarepub.com/summaryfeatures.htm

Author Comment

ID: 24263114
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.


Expert Comment

ID: 33225876
There is also eWebReports. Look at www.exagoinc.com

Featured Post

NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
Windows Explorer let you handle zip folders nearly as any other folder: Copy, move, change, and delete, etc. In VBA you can also handle normal files and folders, but zip folders takes a little more - and that you'll find here.
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

825 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question