Parameters in an in clause

[nagibeni]

I'm new at jasperstudio i need to pass a parameter to a query where i need to select values from another query

Example

Table:

doc   nom

EF   description EF

ET   description ET

ER  description ER

My query is select doc,nom from table where tpo in ('EF','ET)

the values EF, ET i get it from this query (select tpo from tabla) and pick those values in the jasperserver

How i define those parameters?

I try with $P!{Parameter} but i cant make it work, i dont know how to define those values as parameters and pick them when y call the report in jasperreport

Sorry my english, not very good.

Thank you very much

 

Hope you can help me

 

 

[dprogrammer]

Can you use your second query in your IN clause?

select doc,nom from table where tpo in (select distinct(tpo) from tabla));

If not, do you except the values from second query to popup in parameter drop down?