Parameter with Query

[pferban]

Hi,

I'm new in JasperReports and now i'm working wiht parameters. Can I do a parameter with a Select?

I need a parameter with the result of Query Custumer, and when I select a Customer only print a report with sale of this customer.

Thanks

[despec]

Yes, you can use Ireport parameters within a SELECT statement...here's an example

 

Ireport parameter is CUST_NO

 

select

cust_name,

cust_sales

 

from

cust_db

 

where

cust_no = $P{CUST_NO}

 

 

Pretty simple stuff, but this should get you started.

 

David

[pferban]

Hi,

Thanks, sorry I have not explained.
What I want is that the parameter values ​​are the values ​​returned by a select.

Thanks