CA SDM 17 & Jasper 6.4.3 - simple report with paramater
I tried to created a simple report (main jrxml) using Tibco jaspersoft studio with following query and Parameter
<parameter name="MyParam" class="java.lang.String"/>
<queryString>
<![CDATA[SELECT
cr.ref_num as cr_ref_num,
cr.summary as cr_summary,
...
FROM cr
WHERE cr.ref_num = '401359']]>
</queryString>
It works fine.
But if try to use the MyParam parameter in the where clausule bellow, i got an error: net.sf.jasperreports.engine.JRException: Error executing SQL statment for: RAW_TICKET.
I still do not see what is wrong...
<parameter name="MyParam" class="java.lang.String"/>
<queryString>
<![CDATA[SELECT
cr.ref_num as cr_ref_num,
cr.summary as cr_summary,
...
FROM cr
WHERE cr.ref_num = $P{MyParam}]]>
</queryString>
------------------------------
Radek Mihalik
------------------------------