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

Popular posts from this blog

curl - PHP fsockopen help required -

HTTP/1.0 407 Proxy Authentication Required PHP -

c# - Resource not found error -