jasper reports - pass dynamic SQL or resultset

[timasmith]

Hi,

I have a report which is generated with

JasperPrint jasperPrint =
JasperFillManager.fillReport(reportFile, new HashMap(),
Database.getConnection());

The SQL is embedded in the report but based upon the parameters entered
prior to report generation I would like to either

a) pass in the new SQL

b) pass in a resultset such that I have already executed the SQL

Anyone familiar with Jasper reports?

thanks!

Tim

 

[Axel Hallez]

In the documentation
(http://jasperreports.sourceforge.net/api/index.html) you will find that
the JasperFillManager has a method with this signature:
fillReport(java.lang.String sourceFileName, java.util.Map parameters,
JRDataSource dataSource)

Axel Hallez