i want to create few Reports which picks data from few SQL tables, So instead of creating different report's i want to create (or use any Open source) reporting framework, I googled about it but still didn't find enough information to try one.
Following are my requirements:
Filters : Support for different types of Filtering mechanism for the End User
DataSource : SQL Table
UI : user Defined UI for every user (user specific information can be persisted in DB)
Number of concurrent users : 10 (Max)
server : tomcat
Support for graph/Charts
javascript support for customizable UI
i have heard about Jasper / birt framework but dont have working knowledge for any 1 of them so can some one suggest if there exists a opensource framework which i can use for the above mentioned requirements
There are the tools around the JasperReports library like iReport and JasperServer all from JasperSoft. The tools around Eclipse Birt. And then there are the tools from Pentaho.
All three are very powerful and open source and can do what you need. There is plenty of tooling and documentation available and you can buy commercial support for them. Your decision will be based a bit around licensing and potential need for features that are only in the commercial version (e.g. of JasperServer).
Your requirements can be met with both JasperReports and BIRT frameworks.
Consider trying iReport, which is a very mature graphical designer for JasperReports. I must warn you though, iReport is highly addictive ... :-)
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With