I have an online tool that stores activity data in SQL Server on the backend. I want to give my users access to that data in a controlled way, so that they can mine the data and build any type of reports that they like. However, I am going to presume that the users have little to no technical capabilities and certainly don't know how to write SQL queries. I also don't want to force the users to install anything other than a browser.
I need a tool that is completely web-based, that can be used to visually create and design reports -- table-based, charts are not required -- based on a backend SQL database. Think of it as web-based Access or SSRS. Preferably, this would be an open source solution that uses Java.
I have looked at things like JasperReports, but that seems to assume that the user can build a SQL query. I want the users to be able to see a list of the tables available and then build their own reports visually.
Btw, if you were wondering, I am not going to give users direct access to the production tables, but instead copy and "flatten" the data into more of a warehouse on a daily basis and allow users to generate reports against the warehouse.