jasper reports - pass dynamic SQL or resultset

Thread view:

timasmith@hotmail.com - 23 May 2006 00:10 GMT

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

Reply to this Message

Axel Hallez - 23 May 2006 09:53 GMT

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

> Hi,
>
[quoted text clipped - 16 lines]
>
> Tim

Reply to this Message

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...