Hi, I am trying to pass a string parameter which passes mutiple Ids to the query string, I defined the parameter TEST_IDs as String, the default vallue is: "(10072, 10110)", the query string is like: select distinct transtype_name, transtype_id from transaction_type where transtype_id in (select transtype_id from transaction where test_id in $P{TEST_IDs}) I used iReport to generate the jasper report, the generated .jxml file is like (part of it): <parameter name="TEST_IDs" isForPrompting="false" class="java.lang.String"> <defaultValueExpression ><![CDATA["(10072, 10110)"]]></defaultValueExpression> </parameter> <queryString><![CDATA[select distinct transtype_name, transtype_id from transaction_type where transtype_id in (select transtype_id from transaction where test_id in $P{TEST_IDs})]]></queryString> If I don't define the default value, the report runs, but if I define the default value, the report will not run. Anybody has any idea? Any feedback is highly appreciated! Thanks in advance. Post edited by: Meiren, at: 2008/05/08 16:03