jasper reports, multi select query checkbox type parameter is showing An error has occurred. Please contact your system administrator. (5321) -
i using jasper report 6. here jrxml
<?xml version="1.0" encoding="utf-8"?> <jasperreport xmlns="http://jasperreports.sourceforge.net/jasperreports" xmlns:xsi="http://www.w3.org/2001/xmlschema-instance" xsi:schemalocation="http://jasperreports.sourceforge.net/jasperreports http://jasperreports.sourceforge.net/xsd/jasperreport.xsd" name="testtestmultiquery" pagewidth="595" pageheight="842" columnwidth="555" leftmargin="20" rightmargin="20" topmargin="20" bottommargin="20" uuid="90abb488-1239-4b84-865e-291aa3094758"> <property name="com.jaspersoft.studio.data.defaultdataadapter" value="mysql_db"/> <parameter name="source" class="java.util.collection"/> <parameter name="p_source" class="java.lang.string" isforprompting="false"> <defaultvalueexpression><![cdata[(($p{source}.isempty() && $p{source}==null)?"":$p{source}.tostring().replaceall("[\\[\\]]", "'").replaceall(", ", "', '"))]]></defaultvalueexpression> </parameter> <querystring> <![cdata[select id,title,creator_id need n ($x{in,n.source,p_source})]]> </querystring> <field name="id" class="java.lang.long"> <fielddescription><![cdata[]]></fielddescription> </field> <field name="title" class="java.lang.string"> <fielddescription><![cdata[]]></fielddescription> </field> <field name="creator_id" class="java.lang.long"> <fielddescription><![cdata[]]></fielddescription> </field> <background> <band splittype="stretch"/> </background> <detail> <band height="125" splittype="stretch"/> </detail> </jasperreport> here source param non-required param. ran report giving me an error has occurred. please contact system administrator. (5321) when make manditory field working fine me. might issue?
remove () around in..
$x{in you.
i
just build sql know have clause works.
