grantj

I have the same requirement as described here. Before the report query is executed, I need to invoke an Oracle PL/SQL package that preps my data and stores it in a temp table. Based on some other posts and information from the JasperReports and iReports PDF's, I implemented a beforeReportInit() scriptlet. The good news is this works perfectly! It runs the pl/sql, loads up the temp table. Bad news is that it is executed AFTER the report query is executed. So the report query, which is going against the temp table, has no data. Is there some other "place" to put my code that will be executed before the report query? One alternative would be to execute the pl/sql in my own Java first, then pass the prep'd SQL Connection to JasperReports. While that would work for the deployed version, it doesn't help when trying to use iReports during the design phase.