I have an online tool that stores activity data in SQL Server on the backend. I

Question

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.

Explanation / Answer

Check out QLR Manager

Relatively inexpensive when comparing with other applications

This application is completely web-based,

It works with well with MS SQL

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.