Looking for end-user web-based ad-hoc query/reporting tool - SharePoint or Web-forms

Question

Hi,
I'm looking for a database query/reporting solution whereby the user can select (via a web-page) database tables (or lists of data), data fields on the tables/list and values or value ranges. The solution generates the query (i.e. CAML/SQL statements), executes the query and provides the resulting data in a report, on the screen, and can be downloaded as well.

Option 1 - SharePoint - if the data is stored in SharePoint, then ideally is a SharePoint web-part/feature to query data in SharePoint Lists

Option 2 - Web-forrms + MS SQL - this is one-or-more web-control's that provide the ad-hoc features.

Update: I have found one candidate for web-forms here:
http://ajax.easyquerydemo.com/Default.aspx

Thanks in advance.

Answer 1

Have you looked at SQL Server Reporting Services for SharePoint?

Answer 2

Here is a link to a demo of a web based ad-hoc reporting tool.

Answer 3

Just to note. The demo above is based on EasyQuery.NET library.