jasper reports - Error Executing SQL Statement:data -
i'm new jasperreports.
i'm using ireport 5.1.0 , i'm trying fetch data tables done when try fetch of columns when try fetch whole columns(complete table) not generate preview when view in design, gone editor , checked there error in executing query
error:net.sf.jasperreports.engine.jrexception:error executing sql statement:data
my template:
<?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="test5" language="groovy" pagewidth="595" pageheight="842" columnwidth="555" leftmargin="20" rightmargin="20" topmargin="20" bottommargin="20" uuid="c0460b6f-54ff-4c1b-8166-849444c39ebc"> <querystring> <![cdata[select academicperiod_ape.`id_ape` academicperiod_ape_id_ape, academicperiod_ape.`idacy_ape` academicperiod_ape_idacy_ape, academicperiod_ape.`name_ape` academicperiod_ape_name_ape, academicperiod_ape.`shortname_ape` academicperiod_ape_shortname_ape, academicperiod_ape.`countable_ape` academicperiod_ape_countable_ape, academicperiod_ape.`order_ape` academicperiod_ape_order_ape, academicperiod_ape.`is_active_ape` academicperiod_ape_is_active_ape, academicperiod_ape.`is_deleted_ape` academicperiod_ape_is_deleted_ape, academicperiod_ape.`log_date_created_ape` academicperiod_ape_log_date_created_ape, academicperiod_ape.`log_idpsn_ape` academicperiod_ape_log_idpsn_ape `academicperiod_ape` academicperiod_ape]]> </querystring> <field name="academicperiod_ape_shortname_ape" class="java.lang.string"/> <field name="academicperiod_ape_is_deleted_ape" class="java.lang.integer"/> <field name="academicperiod_ape_is_active_ape" class="java.lang.integer"/> <background> <band splittype="stretch"/> </background> <title> <band height="79" splittype="stretch"/> </title> <pageheader> <band height="35" splittype="stretch"/> </pageheader> <columnheader> <band height="77" splittype="stretch"> <statictext> <reportelement uuid="d6f6f737-d03c-4098-b855-eaaabbec26dc" x="14" y="41" width="100" height="20"/> <textelement/> <text><![cdata[academicperiod_ape_shortname_ape]]></text> </statictext> <statictext> <reportelement uuid="1c2aecca-818c-40d8-ac0f-b82f813ef121" x="138" y="41" width="100" height="20"/> <textelement/> <text><![cdata[academicperiod_ape_is_deleted_ape]]></text> </statictext> <statictext> <reportelement uuid="ef5d3dc3-ac4b-479b-b423-ec007af4063d" x="255" y="41" width="100" height="20"/> <textelement/> <text><![cdata[academicperiod_ape_is_active_ape]]></text> </statictext> </band> </columnheader> <detail> <band height="125" splittype="stretch"> <textfield> <reportelement uuid="543cb201-2468-4006-935d-ae57592d8a12" x="14" y="18" width="100" height="20"/> <textelement/> <textfieldexpression><![cdata[$f{academicperiod_ape_shortname_ape}]]></textfieldexpression> </textfield> <textfield> <reportelement uuid="e7a93748-c368-4b0c-a360-87c24536d49d" x="138" y="18" width="100" height="20"/> <textelement/> <textfieldexpression><![cdata[$f{academicperiod_ape_is_deleted_ape}]]></textfieldexpression> </textfield> <textfield> <reportelement uuid="696bc20f-b99a-423e-ba7d-2b59f7f14ceb" x="255" y="18" width="100" height="20"/> <textelement/> <textfieldexpression><![cdata[$f{academicperiod_ape_is_active_ape}]]></textfieldexpression> </textfield> <line> <reportelement uuid="cc1d1c52-bcb5-483e-94ff-0d43b35a9ab4" x="123" y="0" width="1" height="125"/> </line> <line> <reportelement uuid="5a2cf9f5-6070-49ce-afc8-dc189a64b20e" x="0" y="0" width="100" height="1"/> </line> </band> </detail> <columnfooter> <band height="45" splittype="stretch"/> </columnfooter> <pagefooter> <band height="54" splittype="stretch"/> </pagefooter> <summary> <band height="42" splittype="stretch"/> </summary> </jasperreport>
any kind of appreciable friends.
Comments
Post a Comment