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