Dynamic Query Selection

[Thomas Devan]

Hello Ranchers,

I am new to iReport. I request you guys to guide (assist) me to solve the problem.

Scenario:
I am using jasper to generate reports.
I want to have 2 queries inside the jrxml file. Depends on the parameter one of the query has to be selected and report has to be generated.
The parameters are also dynamic..

    

<parameter name="Name" class="java.lang.String"/>
<parameter name="Number" class="java.lang.String"/>
<parameter name="City" class="java.lang.String"/>

<parameter name="SelectQuery" class="java.lang.String" >
<defaultValueExpression><![CDATA[($P{Number}!=null ? query1 : query2)]]></defaultValueExpression>
</parameter>

<queryString>
		<![CDATA[ $P{SelectQuery}]]>
</queryString>

With this above i couldnot make it.. i donot know how to proceed... Any help would be appreciated!!!

Thanks