Hi, You need to use the P!{param_name} syntax. Check the supplied "/demo/samples/query" sample.
If you have furter questions, please log into www.jasperforge.org forums and post them there. Soon this mailing list will be made read-only as we moved our project home to JasperForge. Thank you, Teodor Marty Phee wrote: > I have a query like below: > > select * > from table1 > where field1 in( $P{subselect} ) > > I'd like to pass in the $P{} a select field2 from table2, but it's not > working. I'm guessing that it's putting in "select field2 from table2" > with the quotes and it's failing. > > Is there a way to pass in a string that won't be quoted? > > ------------------------------------------------------------------------- > Take Surveys. Earn Cash. Influence the Future of IT > Join SourceForge.net's Techsay panel and you'll get the chance to share your > opinions on IT & business topics through brief surveys -- and earn cash > http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV > _______________________________________________ > jasperreports-questions mailing list > jasperreports-questions@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/jasperreports-questions > > ------------------------------------------------------------------------- Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys -- and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV _______________________________________________ jasperreports-questions mailing list jasperreports-questions@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jasperreports-questions