How do I set up input parameters for query?

[burferd]

Newbie question:

 

 

I need to find out how to set up the query in iReport so I can pass parameters from a Java program call. All the examples I have found so far for iReport seem to deal with self contained queries. I need to set up something that accepts parameters.

 

 

If I were writing a stored procedure,it might look like:

sp_get_userdata( IN id )

begin

select * from usertable where userId = id;

end;

 

 

How would the iReport query look for something like this, or can I use database stored procedures?

 

 

How do I set things up in iReport so the parameter 'id' can be passed in from the Java HashMap containing parameters?

[csbac]

Hi!

Have a look at

http://www.jasperforge.org/images/stories/Documentation/ireports/swf/Parameters_viewlet_swf.htm

It describes how to setup parameters in iReport.

They can then be set from the Java calling app.

 

Yours,

Sebastian

[e_kannan]

hai!

sebastian your swf presentation for, how to execute parameterized queries in iReport is superb.

 

we are awaiting for the same report explanation.

thanks a lot.

 

I have a doubt. can you tell me, what is the difference between iReport & Jasper reports? what is the purpose of those two elements?

 

regards,

kannan.

[csbac]

e_kannan wrote:

hai! sebastian your swf presentation for, how to execute parameterized queries in iReport is superb.

Hey - it's not mine, I just posted the link.

 

I have a doubt. can you tell me, what is the difference between iReport & Jasper reports? what is the purpose of those two elements?

iReport is a designer, to create reports, and to run them test-wise.

Jasper reports is part of the JasperServer installation, to run these reports in production settings.

 

Yours,

Sebastian