different query

[alvintkl]

<parameter name="co_id" class="java.lang.String"/>
    <parameter name="para" class="java.lang.String"/>
    <queryString>
        <![CDATA[if($P{para}=1,(select *, company.co_name from contactmst, company where contactmst.co_id=company.co_id and contactmst.co_id=$P{co_id} and is_supplier='t'),(select *, company.co_name from contactmst, company where contactmst.co_id=company.co_id and contactmst.co_id=$P{co_id} and is_customer='t'))]]>
    </queryString>

 

can any one help me to solve this problem

[baggypants]

select *, company.co_name
from contactmst, company
where contactmst.co_id=company.co_id
and contactmst.co_id=$P{co_id}
and $P!{OrderByClause}='t'

 

Where $P!{OrderByClause} can be 'is_customer' or 'is_supplier' selected by what ever report generation system you use.