Yes, you can have more than one query in jrxml although you can run only one query. You can have a condition based on which you want you want to fire the query during run time and I think this is what you want. Take a look at the follwing: <parameter name="param" class="java.lang.String"> <defaultValueExpression><![CDATA[]]></defaultValueExpression></parameter><parameter name="query" class="java.lang.String" isForPrompting="false"> <defaultValueExpression><![CDATA[(new String("postgres").equals($P{param}) ? "select * from employee limit 5" : "select * from employee where ROWNUM>=1")]]></defaultValueExpression></parameter><queryString> <![CDATA[$P!{dbType}]]></queryString>Here's the explanation:Use the first parameter(param) for entering the value based on which you want your query to be picked during run time. Based on this value the query is picked and gets set in the second parameter(query). You can see the conditional operator being used in the second parameter. This checks the conditionand returns the query. I hope this helps.