Supply Field Data Through Params

[croutledge]

Hi,

 

I have created a report in iReports and i can import and print it via JasperReports.

 

What i want to be able to do is not supply a query at design time. I would like to run my query through my Java DB layer not in the Report.

 

The only way i've found this to work is by using a simple query like "SELECT 1 FROM DUAL;" and then using params for each piece of data i want to use on the report. The params part is exactly how i want it to work but if i don't specify the query at design time when i then print the report i get a blank page because of the setting in report properties. If i don't specify this setting i get a weird Java Exception error because there is no pages.

 

So my question is really is there a way to not specify the little query at design time and have the report populated entirly by parameters.

 

I've read a couple of posts from people with similar requests but no reponses.

 

Cheers

 

Carl

Post edited by: croutledge, at: 2007/12/07 14:31

[swood]

This sounds like a custom data source. In JasperServer, you can set up a bean that deals with this. Have a look on the forums, documentation etc to see how you can set this up.

 

 

Sherman

JasperSoft