I am creating a desktop application for database management , and using oracle 10g as my back end. Now i need to generate reports on button press after specifying the necessary details. I used the ireports and able to generate reports too, but i dont knw how to bring that into a java frame and do the coding and generate reports dynamically on button click.
You cannot read from a table to make your life a little easier?
OK, here is how it's done:
1 - make the PL/SQL query you need to create your recordset, yes, as ugly and complicated as it needs to be to supply you with all of the data you you will need in your report.
2 - make a form that you want that gives you the layout for the report you need.
3 - poplulate the form from your recordset preduced by the query in step #1.
4 - print the populated form.