Download
****Refer to the improved version of the same application @ https://sourceforge.net/projects/query2report/ ****
Light weight reporter, LWR, is a simple web based reporting building and publishing application. LWR transforms bunch SQL queries to charts and displays in a report. Each report has one or more elements arranged in rows and columns. Each element has title, SQL Query, database connection pointing to database from where data is retrieved and type of graph/table renderer.
The application uses google charts (default) or jfree charts to build the charting components.
User has to define database connection by providing the username, password, driver and connection URL. We can define multiple database connection pointing to different databases building a report retrieving data from different databases.
By clicking on the desired element in the report marks the element to auto refresh every 5 minutes by default (default can be changed).
Features
- Web based reporting application
- Real Time Report - Auto Refresh
- Export report as PDF/CSV
- Role driven access to portal
- Rich user experience with HTML5 and Bootstrap CSS
- Distributed & Scalable with REST base backend and HTML5, JSP and Java Script with AJAX frontend
Project Samples
