My present project need is to have an Open Source Java based reporting tool, which would allow the users to customize the fields to be chosen at runtime. The chosen fields are used to build a dynamic SQL query and the subsequent results will be used to fill the report for the chosen columns. The application being used in WebSphere Portals.
Though my search in google for the same gave many tools like JasperReports, JFreeChart, BIRT etc., i found JasperReports to be the best fit as it has got a GUI tool (iReports).
But now the issue is iReports is a standalone GUI tool where the users can customize the reports by dragging and dropping the components/sections of the Reports.
My question now is : Is there any other Java based Reporting tool which would allow the the dynamic selection of fields while embedding the tool within a web-based J2EE Application?