r_praveen Posted June 12, 2007 Share Posted June 12, 2007 Hi I am using jasper report in my WEB application through java code. when i export my report in PDf then report displays properly with logo. but when i export my report in Excel then report displays without logo. rest data is displayed properly. please tell me what i have to do to display logo in excel report also. Code that i am using is : private void fillReport(String reportName, JasperPrint jasperPrint, String format, OutputStream outStream) throws JRException { JRXlsExporter exporterXLS = new JRXlsExporter(); exporterXLS.setParameter(JRExporterParameter.JASPER_PRINT, jasperPrint); exporterXLS.setParameter(JRExporterParameter.OUTPUT_STREAM, outStream); exporterXLS.setParameter( JRXlsExporterParameter.IS_WHITE_PAGE_BACKGROUND, Boolean.TRUE); exporterXLS.setParameter( JRXlsExporterParameter.IS_AUTO_DETECT_CELL_TYPE, Boolean.TRUE); exporterXLS.setParameter( JRXlsExporterParameter.IS_REMOVE_EMPTY_SPACE_BETWEEN_ROWS, Boolean.FALSE); exporterXLS.exportReport(); } /* here Output stream is already created and passed here to show report on client side in my web application. Jasper print is already created after compiling my jasper report. */ please help me how logo can be displayed in my excel report along with data. thanks & regards Praveen Link to comment Share on other sites More sharing options...
szaharia Posted June 12, 2007 Share Posted June 12, 2007 Hi, JRXlsExporter is based on the jakarta POI APIs, which does not represent the best choice at this moment, especially for complex report structures, or for the latest image formats. A better practice would be to use the JExcelApiExporter, based on the jxl library. HTH,sanda Link to comment Share on other sites More sharing options...
r_praveen Posted June 13, 2007 Author Share Posted June 13, 2007 Hi Thanks for replyI have tried your solution.after changing my code toJExcelApiExporter exporterXLS=new JExcelApiExporter(); exporterXLS.setParameter(JExcelApiExporterParameter.JASPER_PRINT, jasperPrint); exporterXLS.setParameter(JExcelApiExporterParameter.OUTPUT_STREAM, outStream); exporterXLS.setParameter( JExcelApiExporterParameter.IS_WHITE_PAGE_BACKGROUND, Boolean.TRUE); exporterXLS.setParameter( JExcelApiExporterParameter.IS_AUTO_DETECT_CELL_TYPE, Boolean.TRUE); exporterXLS.setParameter( JExcelApiExporterParameter.IS_REMOVE_EMPTY_SPACE_BETWEEN_ROWS, Boolean.FALSE); exporterXLS.exportReport(); and Adding new jar file png-encoder-1.5.jarjxl-2.6.jar It is still showing error while filling report. Exception trace is : NESTED BY :java.lang.NoSuchMethodError: com.keypoint.PngEncoderB.loadImageDataFromAWTImage(Ljava/awt/image/BufferedImage;)[b at net.sf.jasperreports.engine.export.JExcelApiExporter.exportImage(JExcelApiExporter.java:588) at net.sf.jasperreports.engine.export.JRXlsAbstractExporter.exportPage(JRXlsAbstractExporter.java:370) at net.sf.jasperreports.engine.export.JRXlsAbstractExporter.exportReportToStream(JRXlsAbstractExporter.java:293) at net.sf.jasperreports.engine.export.JRXlsAbstractExporter.exportReport(JRXlsAbstractExporter.java:137) at com.klgsystel.vidushi.beans.QueryDataModel.fillReport(QueryDataModel.java:839) at com.klgsystel.vidushi.beans.QueryDataModel.showExcelReport(QueryDataModel.java:791) at com.klgsystel.vidushi.beans.QueryDataModel.createReport(QueryDataModel.java:650) at com.klgsystel.vidushi.beans.QueryDataModel.showReport(QueryDataModel.java:470) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:324) at org.apache.myfaces.el.MethodBindingImpl.invoke(MethodBindingImpl.java:129) at org.apache.myfaces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:63) at javax.faces.component.UICommand.broadcast(UICommand.java:106) at javax.faces.component.UIViewRoot._broadcastForPhase(UIViewRoot.java:90) at javax.faces.component.UIViewRoot.processApplication(UIViewRoot.java:164) at org.apache.myfaces.lifecycle.LifecycleImpl.invokeApplication(LifecycleImpl.java:271) at org.apache.myfaces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:86) at javax.faces.webapp.FacesServlet.service(FacesServlet.java:94) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:284) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:204) at org.apache.myfaces.component.html.util.ExtensionsFilter.doFilter(ExtensionsFilter.java:92) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:233) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:204) at com.klgsystel.vidushi.common.UserAuthorizationFilter.doFilter(UserAuthorizationFilter.java:60) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:233) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:204) at org.apache.myfaces.component.html.util.ExtensionsFilter.doFilter(ExtensionsFilter.java:92) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:233) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:204) at org.apache.myfaces.component.html.util.ExtensionsFilter.doFilter(ExtensionsFilter.java:122) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:233) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:204) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:257) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:151) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:567) at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:245) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:199) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:151) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:567) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:184) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:151) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:164) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:149) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:567) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:156) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:151) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:567) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:972) at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:206) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:833) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:732) at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:619) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:688) at java.lang.Thread.run(Thread.java:534) NESTED BY :net.sf.jasperreports.engine.JRException: The cell cannot be added at net.sf.jasperreports.engine.export.JExcelApiExporter.exportImage(JExcelApiExporter.java:603) at net.sf.jasperreports.engine.export.JRXlsAbstractExporter.exportPage(JRXlsAbstractExporter.java:370) at net.sf.jasperreports.engine.export.JRXlsAbstractExporter.exportReportToStream(JRXlsAbstractExporter.java:293) at net.sf.jasperreports.engine.export.JRXlsAbstractExporter.exportReport(JRXlsAbstractExporter.java:137) at com.klgsystel.vidushi.beans.QueryDataModel.fillReport(QueryDataModel.java:839) at com.klgsystel.vidushi.beans.QueryDataModel.showExcelReport(QueryDataModel.java:791) at com.klgsystel.vidushi.beans.QueryDataModel.createReport(QueryDataModel.java:650) at com.klgsystel.vidushi.beans.QueryDataModel.showReport(QueryDataModel.java:470) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:324) at org.apache.myfaces.el.MethodBindingImpl.invoke(MethodBindingImpl.java:129) at org.apache.myfaces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:63) at javax.faces.component.UICommand.broadcast(UICommand.java:106) at javax.faces.component.UIViewRoot._broadcastForPhase(UIViewRoot.java:90) at javax.faces.component.UIViewRoot.processApplication(UIViewRoot.java:164) at org.apache.myfaces.lifecycle.LifecycleImpl.invokeApplication(LifecycleImpl.java:271) at org.apache.myfaces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:86) at javax.faces.webapp.FacesServlet.service(FacesServlet.java:94) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:284) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:204) at org.apache.myfaces.component.html.util.ExtensionsFilter.doFilter(ExtensionsFilter.java:92) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:233) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:204) at com.klgsystel.vidushi.common.UserAuthorizationFilter.doFilter(UserAuthorizationFilter.java:60) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:233) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:204) at org.apache.myfaces.component.html.util.ExtensionsFilter.doFilter(ExtensionsFilter.java:92) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:233) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:204) at org.apache.myfaces.component.html.util.ExtensionsFilter.doFilter(ExtensionsFilter.java:122) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:233) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:204) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:257) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:151) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:567) at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:245) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:199) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:151) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:567) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:184) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:151) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:164) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:149) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:567) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:156) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:151) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:567) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:972) at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:206) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:833) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:732) at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:619) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:688) at java.lang.Thread.run(Thread.java:534) can u tell me what is wrong here Thanks Praveen Link to comment Share on other sites More sharing options...
szaharia Posted June 13, 2007 Share Posted June 13, 2007 I see something certainly goes wrong here.What exactly is your logo's image format? Is it a PNG? a GIF one? ...I think it would be very useful if you'd attach your jrxml sample and image file here, because such a method as PngEncoderB.loadImageDataFromAWTImage should be never called by JasperReports. What JasperReports version are you using? Thank you,sanda Link to comment Share on other sites More sharing options...
r_praveen Posted June 13, 2007 Author Share Posted June 13, 2007 Hi i am using .jpg type file in my report. I am calling image through subreport.and my jasper report version is ireport 1.2.7 and i am suppling path through Parameter in report $P{reportPath}+"/Images/logo.jpg" i think it is sufficient and reportPath work is ok here because logo is displayed when report is generated through PDF. and my JRXML is : <?xml version="1.0" encoding="UTF-8" ?><!-- Created with iReport - A designer for JasperReports --><!DOCTYPE jasperReport PUBLIC "//JasperReports//DTD Report Design//EN" "http://jasperreports.sourceforge.net/dtds/jasperreport.dtd"><jasperReport name="Cosumers_Detail" columnCount="1" printOrder="Vertical" orientation="Landscape" pageWidth="960" pageHeight="614" columnWidth="959" columnSpacing="0" leftMargin="1" rightMargin="0" topMargin="0" bottomMargin="7" whenNoDataType="NoPages" isTitleNewPage="false" isSummaryNewPage="false"> <property name="ireport.scriptlethandling" value="0" /> <property name="ireport.encoding" value="UTF-8" /> <import value="java.util.*" /> <import value="net.sf.jasperreports.engine.*" /> <import value="net.sf.jasperreports.engine.data.*" /> <parameter name="Subdivision_Name" isForPrompting="false" class="java.lang.String"/> <parameter name="Division_Name" isForPrompting="false" class="java.lang.String"/> <parameter name="Circle_Name" isForPrompting="false" class="java.lang.String"/> <parameter name="SUBREPORT_DIR" isForPrompting="true" class="java.lang.String"/> <parameter name="REPORT_DATE" isForPrompting="true" class="java.util.Date"/> <queryString><![CDATA[selectrownumber() over() as srlno,(select name from p_subdivision where id=c.subdivisionid) subdivision,c.accountNo,c.name,c.fhname,c.dateofConnection,c.villagename,(select code from p_feedertype where id=cmr.feedertypeid) feedertype,c.feederCode,(select code from p_motortype where id=cmr.motortypeid) motortype,(select code from p_areatype where id=cmr.areatypeid) areatypeid,(select code from p_cropType where id=cmr.croptypeid ) croptypeid,cmr.motiveload,cmr.dateOfReading prev_readingdate,cmr.dateOfReading curr_readingdate,cmr.currentReading prev_reading,cmr.currentReading curr_reading,(cmr.currentReading - cmr.currentReading )consumption,(select code from p_meterStatus where id=cmr.meterStatusId ) meterStatus,cmr.meterNo meterNo,(select code from p_MeterType where id=cmr.meterTypeId) meterType,(case when cmr.meterInCircuit is null then 'false' when cmr.meterInCircuit='0' then 'false' else 'true' end) meterInCircuit ,cmr.remarks remarks from p_customermeterreading cmr inner join p_customer c on c.id=cmr.customerid]]></queryString> <field name="SRLNO" class="java.lang.Long"/> <field name="SUBDIVISION" class="java.lang.String"/> <field name="ACCOUNTNO" class="java.lang.String"/> <field name="NAME" class="java.lang.String"/> <field name="FHNAME" class="java.lang.String"/> <field name="DATEOFCONNECTION" class="java.sql.Date"/> <field name="VILLAGENAME" class="java.lang.String"/> <field name="FEEDERTYPE" class="java.lang.String"/> <field name="FEEDERCODE" class="java.lang.String"/> <field name="MOTORTYPE" class="java.lang.String"/> <field name="AREATYPEID" class="java.lang.String"/> <field name="CROPTYPEID" class="java.lang.String"/> <field name="MOTIVELOAD" class="java.math.BigDecimal"/> <field name="PREV_READINGDATE" class="java.sql.Date"/> <field name="CURR_READINGDATE" class="java.sql.Date"/> <field name="PREV_READING" class="java.math.BigDecimal"/> <field name="CURR_READING" class="java.math.BigDecimal"/> <field name="CONSUMPTION" class="java.math.BigDecimal"/> <field name="METERSTATUS" class="java.lang.String"/> <field name="METERNO" class="java.lang.String"/> <field name="METERTYPE" class="java.lang.String"/> <field name="METERINCIRCUIT" class="java.lang.String"/> <field name="REMARKS" class="java.lang.String"/> <background> <band height="0" isSplitAllowed="true" > </band> </background> <title> <band height="0" isSplitAllowed="true" > </band> </title> <pageHeader> <band height="54" isSplitAllowed="true" > <staticText> <reportElement x="59" y="9" width="773" height="21" key="staticText-198"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Left" verticalAlignment="Top"> <font pdfFontName="Helvetica-Bold" size="12" isBold="true" isUnderline="true"/> </textElement> <text><![CDATA[Report of Sample Energy Meter Installed at the Premises of AP Consumer Submitted by KLG Systel Ltd. For the Month of ]]></text> </staticText> <image scaleImage="RetainShape" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="0" y="0" width="50" height="36" key="image-1" stretchType="RelativeToBandHeight" positionType="Float"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <graphicElement stretchType="RelativeToBandHeight"/> <imageExpression class="java.lang.String"><![CDATA[$P{SUBREPORT_DIR}+"\images\logo.jpg"]]></imageExpression> </image> <staticText> <reportElement x="0" y="36" width="129" height="15" key="staticText-1"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement verticalAlignment="Middle"> <font pdfFontName="Helvetica-Bold" size="9" isBold="true"/> </textElement> <text><![CDATA[Name of Sub-Division]]></text> </staticText> <staticText> <reportElement x="287" y="36" width="111" height="15" key="staticText-2"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement verticalAlignment="Middle"> <font pdfFontName="Helvetica-Bold" size="9" isBold="true"/> </textElement> <text><![CDATA[Name of Division]]></text> </staticText> <staticText> <reportElement x="595" y="36" width="102" height="15" key="staticText-3"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement verticalAlignment="Middle"> <font pdfFontName="Helvetica-Bold" size="9" isBold="true"/> </textElement> <text><![CDATA[Name of Circle]]></text> </staticText> <textField isStretchWithOverflow="true" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="136" y="36" width="145" height="15" key="textField"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="1Point" bottomBorderColor="#000000"/> <textElement verticalAlignment="Middle"> <font/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$P{Subdivision_Name}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="403" y="36" width="174" height="15" key="textField"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="1Point" bottomBorderColor="#000000"/> <textElement textAlignment="Left" verticalAlignment="Middle"> <font/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$P{Division_Name}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="701" y="36" width="197" height="15" key="textField"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="1Point" bottomBorderColor="#000000"/> <textElement verticalAlignment="Middle"> <font size="10"/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$P{Circle_Name}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" pattern="MMM-yyyy" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="833" y="9" width="67" height="21" key="textField"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Left" verticalAlignment="Top"> <font pdfFontName="Helvetica-Bold" size="12" isBold="true" isUnderline="true"/> </textElement> <textFieldExpression class="java.util.Date"><![CDATA[$P{REPORT_DATE}]]></textFieldExpression> </textField> </band> </pageHeader> <columnHeader> <band height="47" isSplitAllowed="true" > <staticText> <reportElement x="911" y="0" width="48" height="12" key="staticText-100"/> <box topBorder="1Point" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#000000" rightBorder="1Point" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font pdfFontName="Helvetica-Bold" size="8" isBold="true"/> </textElement> <text><![CDATA[Remarks]]></text> </staticText> <staticText> <reportElement x="230" y="0" width="45" height="12" key="staticText-101"/> <box topBorder="1Point" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font pdfFontName="Helvetica-Bold" size="8" isBold="true"/> </textElement> <text><![CDATA[Date]]></text> </staticText> <staticText> <reportElement x="275" y="0" width="52" height="12" key="staticText-102"/> <box topBorder="1Point" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font pdfFontName="Helvetica-Bold" size="8" isBold="true"/> </textElement> <text><![CDATA[Village]]></text> </staticText> <staticText> <reportElement x="327" y="0" width="35" height="12" key="staticText-103"/> <box topBorder="1Point" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font pdfFontName="Helvetica-Bold" size="8" isBold="true"/> </textElement> <text><![CDATA[Feeder]]></text> </staticText> <staticText> <reportElement x="416" y="0" width="32" height="12" key="staticText-104"/> <box topBorder="1Point" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font pdfFontName="Helvetica-Bold" size="8" isBold="true"/> </textElement> <text><![CDATA[Motor]]></text> </staticText> <staticText> <reportElement x="448" y="0" width="38" height="12" key="staticText-105"/> <box topBorder="1Point" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font pdfFontName="Helvetica-Bold" size="8" isBold="true"/> </textElement> <text><![CDATA[Area]]></text> </staticText> <staticText> <reportElement x="486" y="0" width="33" height="12" key="staticText-106"/> <box topBorder="1Point" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font pdfFontName="Helvetica-Bold" size="8" isBold="true"/> </textElement> <text><![CDATA[Type ]]></text> </staticText> <staticText> <reportElement x="519" y="0" width="31" height="12" key="staticText-107"/> <box topBorder="1Point" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font pdfFontName="Helvetica-Bold" size="8" isBold="true"/> </textElement> <text><![CDATA[Load]]></text> </staticText> <staticText> <reportElement x="550" y="0" width="83" height="12" key="staticText-108"/> <box topBorder="1Point" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font pdfFontName="Helvetica-Bold" size="8" isBold="true"/> </textElement> <text><![CDATA[Reading dt.]]></text> </staticText> <staticText> <reportElement x="633" y="0" width="72" height="12" key="staticText-110"/> <box topBorder="1Point" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font pdfFontName="Helvetica-Bold" size="8" isBold="true"/> </textElement> <text><![CDATA[Readings]]></text> </staticText> <staticText> <reportElement x="705" y="0" width="46" height="12" key="staticText-112"/> <box topBorder="1Point" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font pdfFontName="Helvetica-Bold" size="8" isBold="true"/> </textElement> <text><![CDATA[Cons.]]></text> </staticText> <staticText> <reportElement x="751" y="0" width="40" height="12" key="staticText-113"/> <box topBorder="1Point" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font pdfFontName="Helvetica-Bold" size="8" isBold="true"/> </textElement> <text><![CDATA[Meter]]></text> </staticText> <staticText> <reportElement x="362" y="0" width="54" height="12" key="staticText-114"/> <box topBorder="1Point" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font pdfFontName="Helvetica-Bold" size="8" isBold="true"/> </textElement> <text><![CDATA[Feeder]]></text> </staticText> <staticText> <reportElement x="0" y="0" width="21" height="12" key="staticText-115"/> <box topBorder="1Point" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font pdfFontName="Helvetica-Bold" size="8" isBold="true"/> </textElement> <text><![CDATA[srl.]]></text> </staticText> <staticText> <reportElement x="21" y="0" width="30" height="12" key="staticText-116"/> <box topBorder="1Point" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font pdfFontName="Helvetica-Bold" size="8" isBold="true"/> </textElement> <text><![CDATA]></text> </staticText> <staticText> <reportElement x="51" y="0" width="36" height="12" key="staticText-117"/> <box topBorder="1Point" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font pdfFontName="Helvetica-Bold" size="8" isBold="true"/> </textElement> <text><![CDATA[Consum.]]></text> </staticText> <staticText> <reportElement x="87" y="0" width="72" height="12" key="staticText-118"/> <box topBorder="1Point" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font pdfFontName="Helvetica-Bold" size="8" isBold="true"/> </textElement> <text><![CDATA[Consum.]]></text> </staticText> <staticText> <reportElement x="159" y="0" width="71" height="12" key="staticText-119"/> <box topBorder="1Point" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font pdfFontName="Helvetica-Bold" size="8" isBold="true"/> </textElement> <text><![CDATA[Father's]]></text> </staticText> <staticText> <reportElement x="911" y="12" width="48" height="12" key="staticText-120"/> <box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#000000" rightBorder="1Point" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font pdfFontName="Helvetica-Bold" size="8" isBold="true"/> </textElement> <text><![CDATA[]]></text> </staticText> <staticText> <reportElement x="230" y="12" width="45" height="12" key="staticText-121"/> <box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font pdfFontName="Helvetica-Bold" size="8" isBold="true"/> </textElement> <text><![CDATA[of]]></text> </staticText> <staticText> <reportElement x="275" y="12" width="52" height="12" key="staticText-122"/> <box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font pdfFontName="Helvetica-Bold" size="8" isBold="true"/> </textElement> <text><![CDATA[name]]></text> </staticText> <staticText> <reportElement x="327" y="12" width="35" height="12" key="staticText-123"/> <box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font pdfFontName="Helvetica-Bold" size="8" isBold="true"/> </textElement> <text><![CDATA[type]]></text> </staticText> <staticText> <reportElement x="416" y="12" width="32" height="12" key="staticText-124"/> <box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font pdfFontName="Helvetica-Bold" size="8" isBold="true"/> </textElement> <text><![CDATA[type]]></text> </staticText> <staticText> <reportElement x="448" y="12" width="38" height="12" key="staticText-125"/> <box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font pdfFontName="Helvetica-Bold" size="8" isBold="true"/> </textElement> <text><![CDATA[type]]></text> </staticText> <staticText> <reportElement x="486" y="12" width="33" height="12" key="staticText-126"/> <box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font pdfFontName="Helvetica-Bold" size="8" isBold="true"/> </textElement> <text><![CDATA[of]]></text> </staticText> <staticText> <reportElement x="519" y="12" width="31" height="12" key="staticText-127"/> <box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font pdfFontName="Helvetica-Bold" size="8" isBold="true"/> </textElement> <text><![CDATA[bHP]]></text> </staticText> <staticText> <reportElement x="550" y="12" width="41" height="12" key="staticText-128"/> <box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font pdfFontName="Helvetica-Bold" size="8" isBold="true"/> </textElement> <text><![CDATA[Old]]></text> </staticText> <staticText> <reportElement x="591" y="12" width="42" height="12" key="staticText-129"/> <box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font pdfFontName="Helvetica-Bold" size="8" isBold="true"/> </textElement> <text><![CDATA[New]]></text> </staticText> <staticText> <reportElement x="633" y="12" width="37" height="12" key="staticText-130"/> <box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font pdfFontName="Helvetica-Bold" size="8" isBold="true"/> </textElement> <text><![CDATA[Old]]></text> </staticText> <staticText> <reportElement x="670" y="12" width="35" height="12" key="staticText-131"/> <box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font pdfFontName="Helvetica-Bold" size="8" isBold="true"/> </textElement> <text><![CDATA[New]]></text> </staticText> <staticText> <reportElement x="705" y="12" width="46" height="12" key="staticText-132"/> <box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font pdfFontName="Helvetica-Bold" size="8" isBold="true"/> </textElement> <text><![CDATA[]]></text> </staticText> <staticText> <reportElement x="751" y="12" width="40" height="12" key="staticText-133"/> <box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font pdfFontName="Helvetica-Bold" size="8" isBold="true"/> </textElement> <text><![CDATA[status]]></text> </staticText> <staticText> <reportElement x="362" y="12" width="54" height="12" key="staticText-134"/> <box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font pdfFontName="Helvetica-Bold" size="8" isBold="true"/> </textElement> <text><![CDATACode:]></text> </staticText> <staticText> <reportElement x="0" y="12" width="21" height="12" key="staticText-135"/> <box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font pdfFontName="Helvetica-Bold" size="8" isBold="true"/> </textElement> <text><![CDATA[No.]]></text> </staticText> <staticText> <reportElement x="21" y="12" width="30" height="12" key="staticText-136"/> <box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font pdfFontName="Helvetica-Bold" size="8" isBold="true"/> </textElement> <text><![CDATA[Divn.]]></text> </staticText> <staticText> <reportElement x="51" y="12" width="36" height="12" key="staticText-137"/> <box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font pdfFontName="Helvetica-Bold" size="8" isBold="true"/> </textElement> <text><![CDATA[A/c no.]]></text> </staticText> <staticText> <reportElement x="87" y="12" width="72" height="12" key="staticText-138"/> <box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font pdfFontName="Helvetica-Bold" size="8" isBold="true"/> </textElement> <text><![CDATA[Name]]></text> </staticText> <staticText> <reportElement x="159" y="12" width="71" height="12" key="staticText-139"/> <box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font pdfFontName="Helvetica-Bold" size="8" isBold="true"/> </textElement> <text><![CDATA[Name]]></text> </staticText> <staticText> <reportElement x="911" y="24" width="48" height="12" key="staticText-140"/> <box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#000000" rightBorder="1Point" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font pdfFontName="Helvetica-Bold" size="8" isBold="true"/> </textElement> <text><![CDATA[]]></text> </staticText> <staticText> <reportElement x="230" y="24" width="45" height="12" key="staticText-141"/> <box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font pdfFontName="Helvetica-Bold" size="8" isBold="true"/> </textElement> <text><![CDATA[Connec.]]></text> </staticText> <staticText> <reportElement x="275" y="24" width="52" height="12" key="staticText-142"/> <box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font pdfFontName="Helvetica-Bold" size="8" isBold="true"/> </textElement> <text><![CDATA[]]></text> </staticText> <staticText> <reportElement x="327" y="24" width="35" height="12" key="staticText-143"/> <box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font pdfFontName="Helvetica-Bold" size="8" isBold="true"/> </textElement> <text><![CDATA[AP/R/U]]></text> </staticText> <staticText> <reportElement x="416" y="24" width="32" height="12" key="staticText-144"/> <box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font pdfFontName="Helvetica-Bold" size="8" isBold="true"/> </textElement> <text><![CDATA[M/S]]></text> </staticText> <staticText> <reportElement x="448" y="24" width="38" height="12" key="staticText-145"/> <box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font pdfFontName="Helvetica-Bold" size="8" isBold="true"/> </textElement> <text><![CDATA[K/W/X]]></text> </staticText> <staticText> <reportElement x="486" y="24" width="33" height="12" key="staticText-146"/> <box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font pdfFontName="Helvetica-Bold" size="8" isBold="true"/> </textElement> <text><![CDATA[Crop]]></text> </staticText> <staticText> <reportElement x="519" y="24" width="31" height="12" key="staticText-147"/> <box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font pdfFontName="Helvetica-Bold" size="8" isBold="true"/> </textElement> <text><![CDATA[]]></text> </staticText> <staticText> <reportElement x="550" y="24" width="41" height="12" key="staticText-148"/> <box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font pdfFontName="Helvetica-Bold" size="8" isBold="true"/> </textElement> <text><![CDATA[]]></text> </staticText> <staticText> <reportElement x="591" y="24" width="42" height="12" key="staticText-149"/> <box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font pdfFontName="Helvetica-Bold" size="8" isBold="true"/> </textElement> <text><![CDATA[]]></text> </staticText> <staticText> <reportElement x="633" y="24" width="37" height="12" key="staticText-150"/> <box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font pdfFontName="Helvetica-Bold" size="8" isBold="true"/> </textElement> <text><![CDATA[]]></text> </staticText> <staticText> <reportElement x="670" y="24" width="35" height="12" key="staticText-151"/> <box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font pdfFontName="Helvetica-Bold" size="8" isBold="true"/> </textElement> <text><![CDATA[]]></text> </staticText> <staticText> <reportElement x="705" y="24" width="46" height="12" key="staticText-152"/> <box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font pdfFontName="Helvetica-Bold" size="8" isBold="true"/> </textElement> <text><![CDATA[]]></text> </staticText> <staticText> <reportElement x="751" y="24" width="40" height="12" key="staticText-153"/> <box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font pdfFontName="Helvetica-Bold" size="8" isBold="true"/> </textElement> <text><![CDATA[]]></text> </staticText> <staticText> <reportElement x="362" y="24" width="54" height="12" key="staticText-154"/> <box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font pdfFontName="Helvetica-Bold" size="8" isBold="true"/> </textElement> <text><![CDATA[]]></text> </staticText> <staticText> <reportElement x="0" y="24" width="21" height="12" key="staticText-155"/> <box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font pdfFontName="Helvetica-Bold" size="8" isBold="true"/> </textElement> <text><![CDATA[]]></text> </staticText> <staticText> <reportElement x="21" y="24" width="30" height="12" key="staticText-156"/> <box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font pdfFontName="Helvetica-Bold" size="8" isBold="true"/> </textElement> <text><![CDATA[]]></text> </staticText> <staticText> <reportElement x="51" y="24" width="36" height="12" key="staticText-157"/> <box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font pdfFontName="Helvetica-Bold" size="8" isBold="true"/> </textElement> <text><![CDATA[]]></text> </staticText> <staticText> <reportElement x="87" y="24" width="72" height="12" key="staticText-158"/> <box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font pdfFontName="Helvetica-Bold" size="8" isBold="true"/> </textElement> <text><![CDATA[]]></text> </staticText> <staticText> <reportElement x="159" y="24" width="71" height="12" key="staticText-159"/> <box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font pdfFontName="Helvetica-Bold" size="8" isBold="true"/> </textElement> <text><![CDATA[]]></text> </staticText> <staticText> <reportElement x="230" y="36" width="45" height="11" key="staticText-160"/> <box topBorder="1Point" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="1Point" bottomBorderColor="#000000"/> <textElement textAlignment="Cen Link to comment Share on other sites More sharing options...
r_praveen Posted June 13, 2007 Author Share Posted June 13, 2007 Hi i am using .jpg type file in my report. I am calling image through subreport.and my jasper report version is ireport 1.2.7 and i am suppling path through Parameter in report $P{reportPath}+"/Images/logo.jpg" i think it is sufficient and reportPath work is ok here because logo is displayed when report is generated through PDF. and my JRXML is : <?xml version="1.0" encoding="UTF-8" ?><!-- Created with iReport - A designer for JasperReports --><!DOCTYPE jasperReport PUBLIC "//JasperReports//DTD Report Design//EN" "http://jasperreports.sourceforge.net/dtds/jasperreport.dtd"><jasperReport name="Cosumers_Detail" columnCount="1" printOrder="Vertical" orientation="Landscape" pageWidth="960" pageHeight="614" columnWidth="959" columnSpacing="0" leftMargin="1" rightMargin="0" topMargin="0" bottomMargin="7" whenNoDataType="NoPages" isTitleNewPage="false" isSummaryNewPage="false"> <property name="ireport.scriptlethandling" value="0" /> <property name="ireport.encoding" value="UTF-8" /> <import value="java.util.*" /> <import value="net.sf.jasperreports.engine.*" /> <import value="net.sf.jasperreports.engine.data.*" /> <parameter name="Subdivision_Name" isForPrompting="false" class="java.lang.String"/> <parameter name="Division_Name" isForPrompting="false" class="java.lang.String"/> <parameter name="Circle_Name" isForPrompting="false" class="java.lang.String"/> <parameter name="SUBREPORT_DIR" isForPrompting="true" class="java.lang.String"/> <parameter name="REPORT_DATE" isForPrompting="true" class="java.util.Date"/> <queryString><![CDATA[selectrownumber() over() as srlno,(select name from p_subdivision where id=c.subdivisionid) subdivision,c.accountNo,c.name,c.fhname,c.dateofConnection,c.villagename,(select code from p_feedertype where id=cmr.feedertypeid) feedertype,c.feederCode,(select code from p_motortype where id=cmr.motortypeid) motortype,(select code from p_areatype where id=cmr.areatypeid) areatypeid,(select code from p_cropType where id=cmr.croptypeid ) croptypeid,cmr.motiveload,cmr.dateOfReading prev_readingdate,cmr.dateOfReading curr_readingdate,cmr.currentReading prev_reading,cmr.currentReading curr_reading,(cmr.currentReading - cmr.currentReading )consumption,(select code from p_meterStatus where id=cmr.meterStatusId ) meterStatus,cmr.meterNo meterNo,(select code from p_MeterType where id=cmr.meterTypeId) meterType,(case when cmr.meterInCircuit is null then 'false' when cmr.meterInCircuit='0' then 'false' else 'true' end) meterInCircuit ,cmr.remarks remarks from p_customermeterreading cmr inner join p_customer c on c.id=cmr.customerid]]></queryString> <field name="SRLNO" class="java.lang.Long"/> <field name="SUBDIVISION" class="java.lang.String"/> <field name="ACCOUNTNO" class="java.lang.String"/> <field name="NAME" class="java.lang.String"/> <field name="FHNAME" class="java.lang.String"/> <field name="DATEOFCONNECTION" class="java.sql.Date"/> <field name="VILLAGENAME" class="java.lang.String"/> <field name="FEEDERTYPE" class="java.lang.String"/> <field name="FEEDERCODE" class="java.lang.String"/> <field name="MOTORTYPE" class="java.lang.String"/> <field name="AREATYPEID" class="java.lang.String"/> <field name="CROPTYPEID" class="java.lang.String"/> <field name="MOTIVELOAD" class="java.math.BigDecimal"/> <field name="PREV_READINGDATE" class="java.sql.Date"/> <field name="CURR_READINGDATE" class="java.sql.Date"/> <field name="PREV_READING" class="java.math.BigDecimal"/> <field name="CURR_READING" class="java.math.BigDecimal"/> <field name="CONSUMPTION" class="java.math.BigDecimal"/> <field name="METERSTATUS" class="java.lang.String"/> <field name="METERNO" class="java.lang.String"/> <field name="METERTYPE" class="java.lang.String"/> <field name="METERINCIRCUIT" class="java.lang.String"/> <field name="REMARKS" class="java.lang.String"/> <background> <band height="0" isSplitAllowed="true" > </band> </background> <title> <band height="0" isSplitAllowed="true" > </band> </title> <pageHeader> <band height="54" isSplitAllowed="true" > <staticText> <reportElement x="59" y="9" width="773" height="21" key="staticText-198"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Left" verticalAlignment="Top"> <font pdfFontName="Helvetica-Bold" size="12" isBold="true" isUnderline="true"/> </textElement> <text><![CDATA[Report of Sample Energy Meter Installed at the Premises of AP Consumer Submitted by KLG Systel Ltd. For the Month of ]]></text> </staticText> <image scaleImage="RetainShape" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="0" y="0" width="50" height="36" key="image-1" stretchType="RelativeToBandHeight" positionType="Float"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <graphicElement stretchType="RelativeToBandHeight"/> <imageExpression class="java.lang.String"><![CDATA[$P{SUBREPORT_DIR}+"\images\logo.jpg"]]></imageExpression> </image> <staticText> <reportElement x="0" y="36" width="129" height="15" key="staticText-1"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement verticalAlignment="Middle"> <font pdfFontName="Helvetica-Bold" size="9" isBold="true"/> </textElement> <text><![CDATA[Name of Sub-Division]]></text> </staticText> <staticText> <reportElement x="287" y="36" width="111" height="15" key="staticText-2"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement verticalAlignment="Middle"> <font pdfFontName="Helvetica-Bold" size="9" isBold="true"/> </textElement> <text><![CDATA[Name of Division]]></text> </staticText> <staticText> <reportElement x="595" y="36" width="102" height="15" key="staticText-3"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement verticalAlignment="Middle"> <font pdfFontName="Helvetica-Bold" size="9" isBold="true"/> </textElement> <text><![CDATA[Name of Circle]]></text> </staticText> <textField isStretchWithOverflow="true" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="136" y="36" width="145" height="15" key="textField"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="1Point" bottomBorderColor="#000000"/> <textElement verticalAlignment="Middle"> <font/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$P{Subdivision_Name}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="403" y="36" width="174" height="15" key="textField"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="1Point" bottomBorderColor="#000000"/> <textElement textAlignment="Left" verticalAlignment="Middle"> <font/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$P{Division_Name}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="701" y="36" width="197" height="15" key="textField"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="1Point" bottomBorderColor="#000000"/> <textElement verticalAlignment="Middle"> <font size="10"/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$P{Circle_Name}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" pattern="MMM-yyyy" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="833" y="9" width="67" height="21" key="textField"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Left" verticalAlignment="Top"> <font pdfFontName="Helvetica-Bold" size="12" isBold="true" isUnderline="true"/> </textElement> <textFieldExpression class="java.util.Date"><![CDATA[$P{REPORT_DATE}]]></textFieldExpression> </textField> </band> </pageHeader> <columnHeader> <band height="47" isSplitAllowed="true" > <staticText> <reportElement x="911" y="0" width="48" height="12" key="staticText-100"/> <box topBorder="1Point" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#000000" rightBorder="1Point" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font pdfFontName="Helvetica-Bold" size="8" isBold="true"/> </textElement> <text><![CDATA[Remarks]]></text> </staticText> <staticText> <reportElement x="230" y="0" width="45" height="12" key="staticText-101"/> <box topBorder="1Point" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font pdfFontName="Helvetica-Bold" size="8" isBold="true"/> </textElement> <text><![CDATA[Date]]></text> </staticText> <staticText> <reportElement x="275" y="0" width="52" height="12" key="staticText-102"/> <box topBorder="1Point" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font pdfFontName="Helvetica-Bold" size="8" isBold="true"/> </textElement> <text><![CDATA[Village]]></text> </staticText> <staticText> <reportElement x="327" y="0" width="35" height="12" key="staticText-103"/> <box topBorder="1Point" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font pdfFontName="Helvetica-Bold" size="8" isBold="true"/> </textElement> <text><![CDATA[Feeder]]></text> </staticText> <staticText> <reportElement x="416" y="0" width="32" height="12" key="staticText-104"/> <box topBorder="1Point" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font pdfFontName="Helvetica-Bold" size="8" isBold="true"/> </textElement> <text><![CDATA[Motor]]></text> </staticText> <staticText> <reportElement x="448" y="0" width="38" height="12" key="staticText-105"/> <box topBorder="1Point" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font pdfFontName="Helvetica-Bold" size="8" isBold="true"/> </textElement> <text><![CDATA[Area]]></text> </staticText> <staticText> <reportElement x="486" y="0" width="33" height="12" key="staticText-106"/> <box topBorder="1Point" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font pdfFontName="Helvetica-Bold" size="8" isBold="true"/> </textElement> <text><![CDATA[Type ]]></text> </staticText> <staticText> <reportElement x="519" y="0" width="31" height="12" key="staticText-107"/> <box topBorder="1Point" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font pdfFontName="Helvetica-Bold" size="8" isBold="true"/> </textElement> <text><![CDATA[Load]]></text> </staticText> <staticText> <reportElement x="550" y="0" width="83" height="12" key="staticText-108"/> <box topBorder="1Point" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font pdfFontName="Helvetica-Bold" size="8" isBold="true"/> </textElement> <text><![CDATA[Reading dt.]]></text> </staticText> <staticText> <reportElement x="633" y="0" width="72" height="12" key="staticText-110"/> <box topBorder="1Point" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font pdfFontName="Helvetica-Bold" size="8" isBold="true"/> </textElement> <text><![CDATA[Readings]]></text> </staticText> <staticText> <reportElement x="705" y="0" width="46" height="12" key="staticText-112"/> <box topBorder="1Point" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font pdfFontName="Helvetica-Bold" size="8" isBold="true"/> </textElement> <text><![CDATA[Cons.]]></text> </staticText> <staticText> <reportElement x="751" y="0" width="40" height="12" key="staticText-113"/> <box topBorder="1Point" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font pdfFontName="Helvetica-Bold" size="8" isBold="true"/> </textElement> <text><![CDATA[Meter]]></text> </staticText> <staticText> <reportElement x="362" y="0" width="54" height="12" key="staticText-114"/> <box topBorder="1Point" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font pdfFontName="Helvetica-Bold" size="8" isBold="true"/> </textElement> <text><![CDATA[Feeder]]></text> </staticText> <staticText> <reportElement x="0" y="0" width="21" height="12" key="staticText-115"/> <box topBorder="1Point" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font pdfFontName="Helvetica-Bold" size="8" isBold="true"/> </textElement> <text><![CDATA[srl.]]></text> </staticText> <staticText> <reportElement x="21" y="0" width="30" height="12" key="staticText-116"/> <box topBorder="1Point" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font pdfFontName="Helvetica-Bold" size="8" isBold="true"/> </textElement> <text><![CDATA]></text> </staticText> <staticText> <reportElement x="51" y="0" width="36" height="12" key="staticText-117"/> <box topBorder="1Point" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font pdfFontName="Helvetica-Bold" size="8" isBold="true"/> </textElement> <text><![CDATA[Consum.]]></text> </staticText> <staticText> <reportElement x="87" y="0" width="72" height="12" key="staticText-118"/> <box topBorder="1Point" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font pdfFontName="Helvetica-Bold" size="8" isBold="true"/> </textElement> <text><![CDATA[Consum.]]></text> </staticText> <staticText> <reportElement x="159" y="0" width="71" height="12" key="staticText-119"/> <box topBorder="1Point" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font pdfFontName="Helvetica-Bold" size="8" isBold="true"/> </textElement> <text><![CDATA[Father's]]></text> </staticText> <staticText> <reportElement x="911" y="12" width="48" height="12" key="staticText-120"/> <box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#000000" rightBorder="1Point" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font pdfFontName="Helvetica-Bold" size="8" isBold="true"/> </textElement> <text><![CDATA[]]></text> </staticText> <staticText> <reportElement x="230" y="12" width="45" height="12" key="staticText-121"/> <box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font pdfFontName="Helvetica-Bold" size="8" isBold="true"/> </textElement> <text><![CDATA[of]]></text> </staticText> <staticText> <reportElement x="275" y="12" width="52" height="12" key="staticText-122"/> <box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font pdfFontName="Helvetica-Bold" size="8" isBold="true"/> </textElement> <text><![CDATA[name]]></text> </staticText> <staticText> <reportElement x="327" y="12" width="35" height="12" key="staticText-123"/> <box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font pdfFontName="Helvetica-Bold" size="8" isBold="true"/> </textElement> <text><![CDATA[type]]></text> </staticText> <staticText> <reportElement x="416" y="12" width="32" height="12" key="staticText-124"/> <box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font pdfFontName="Helvetica-Bold" size="8" isBold="true"/> </textElement> <text><![CDATA[type]]></text> </staticText> <staticText> <reportElement x="448" y="12" width="38" height="12" key="staticText-125"/> <box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font pdfFontName="Helvetica-Bold" size="8" isBold="true"/> </textElement> <text><![CDATA[type]]></text> </staticText> <staticText> <reportElement x="486" y="12" width="33" height="12" key="staticText-126"/> <box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font pdfFontName="Helvetica-Bold" size="8" isBold="true"/> </textElement> <text><![CDATA[of]]></text> </staticText> <staticText> <reportElement x="519" y="12" width="31" height="12" key="staticText-127"/> <box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font pdfFontName="Helvetica-Bold" size="8" isBold="true"/> </textElement> <text><![CDATA[bHP]]></text> </staticText> <staticText> <reportElement x="550" y="12" width="41" height="12" key="staticText-128"/> <box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font pdfFontName="Helvetica-Bold" size="8" isBold="true"/> </textElement> <text><![CDATA[Old]]></text> </staticText> <staticText> <reportElement x="591" y="12" width="42" height="12" key="staticText-129"/> <box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font pdfFontName="Helvetica-Bold" size="8" isBold="true"/> </textElement> <text><![CDATA[New]]></text> </staticText> <staticText> <reportElement x="633" y="12" width="37" height="12" key="staticText-130"/> <box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font pdfFontName="Helvetica-Bold" size="8" isBold="true"/> </textElement> <text><![CDATA[Old]]></text> </staticText> <staticText> <reportElement x="670" y="12" width="35" height="12" key="staticText-131"/> <box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font pdfFontName="Helvetica-Bold" size="8" isBold="true"/> </textElement> <text><![CDATA[New]]></text> </staticText> <staticText> <reportElement x="705" y="12" width="46" height="12" key="staticText-132"/> <box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font pdfFontName="Helvetica-Bold" size="8" isBold="true"/> </textElement> <text><![CDATA[]]></text> </staticText> <staticText> <reportElement x="751" y="12" width="40" height="12" key="staticText-133"/> <box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font pdfFontName="Helvetica-Bold" size="8" isBold="true"/> </textElement> <text><![CDATA[status]]></text> </staticText> <staticText> <reportElement x="362" y="12" width="54" height="12" key="staticText-134"/> <box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font pdfFontName="Helvetica-Bold" size="8" isBold="true"/> </textElement> <text><![CDATACode:]></text> </staticText> <staticText> <reportElement x="0" y="12" width="21" height="12" key="staticText-135"/> <box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font pdfFontName="Helvetica-Bold" size="8" isBold="true"/> </textElement> <text><![CDATA[No.]]></text> </staticText> <staticText> <reportElement x="21" y="12" width="30" height="12" key="staticText-136"/> <box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font pdfFontName="Helvetica-Bold" size="8" isBold="true"/> </textElement> <text><![CDATA[Divn.]]></text> </staticText> <staticText> <reportElement x="51" y="12" width="36" height="12" key="staticText-137"/> <box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font pdfFontName="Helvetica-Bold" size="8" isBold="true"/> </textElement> <text><![CDATA[A/c no.]]></text> </staticText> <staticText> <reportElement x="87" y="12" width="72" height="12" key="staticText-138"/> <box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font pdfFontName="Helvetica-Bold" size="8" isBold="true"/> </textElement> <text><![CDATA[Name]]></text> </staticText> <staticText> <reportElement x="159" y="12" width="71" height="12" key="staticText-139"/> <box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font pdfFontName="Helvetica-Bold" size="8" isBold="true"/> </textElement> <text><![CDATA[Name]]></text> </staticText> <staticText> <reportElement x="911" y="24" width="48" height="12" key="staticText-140"/> <box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#000000" rightBorder="1Point" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font pdfFontName="Helvetica-Bold" size="8" isBold="true"/> </textElement> <text><![CDATA[]]></text> </staticText> <staticText> <reportElement x="230" y="24" width="45" height="12" key="staticText-141"/> <box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font pdfFontName="Helvetica-Bold" size="8" isBold="true"/> </textElement> <text><![CDATA[Connec.]]></text> </staticText> <staticText> <reportElement x="275" y="24" width="52" height="12" key="staticText-142"/> <box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font pdfFontName="Helvetica-Bold" size="8" isBold="true"/> </textElement> <text><![CDATA[]]></text> </staticText> <staticText> <reportElement x="327" y="24" width="35" height="12" key="staticText-143"/> <box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font pdfFontName="Helvetica-Bold" size="8" isBold="true"/> </textElement> <text><![CDATA[AP/R/U]]></text> </staticText> <staticText> <reportElement x="416" y="24" width="32" height="12" key="staticText-144"/> <box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font pdfFontName="Helvetica-Bold" size="8" isBold="true"/> </textElement> <text><![CDATA[M/S]]></text> </staticText> <staticText> <reportElement x="448" y="24" width="38" height="12" key="staticText-145"/> <box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font pdfFontName="Helvetica-Bold" size="8" isBold="true"/> </textElement> <text><![CDATA[K/W/X]]></text> </staticText> <staticText> <reportElement x="486" y="24" width="33" height="12" key="staticText-146"/> <box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font pdfFontName="Helvetica-Bold" size="8" isBold="true"/> </textElement> <text><![CDATA[Crop]]></text> </staticText> <staticText> <reportElement x="519" y="24" width="31" height="12" key="staticText-147"/> <box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font pdfFontName="Helvetica-Bold" size="8" isBold="true"/> </textElement> <text><![CDATA[]]></text> </staticText> <staticText> <reportElement x="550" y="24" width="41" height="12" key="staticText-148"/> <box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font pdfFontName="Helvetica-Bold" size="8" isBold="true"/> </textElement> <text><![CDATA[]]></text> </staticText> <staticText> <reportElement x="591" y="24" width="42" height="12" key="staticText-149"/> <box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font pdfFontName="Helvetica-Bold" size="8" isBold="true"/> </textElement> <text><![CDATA[]]></text> </staticText> <staticText> <reportElement x="633" y="24" width="37" height="12" key="staticText-150"/> <box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font pdfFontName="Helvetica-Bold" size="8" isBold="true"/> </textElement> <text><![CDATA[]]></text> </staticText> <staticText> <reportElement x="670" y="24" width="35" height="12" key="staticText-151"/> <box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font pdfFontName="Helvetica-Bold" size="8" isBold="true"/> </textElement> <text><![CDATA[]]></text> </staticText> <staticText> <reportElement x="705" y="24" width="46" height="12" key="staticText-152"/> <box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font pdfFontName="Helvetica-Bold" size="8" isBold="true"/> </textElement> <text><![CDATA[]]></text> </staticText> <staticText> <reportElement x="751" y="24" width="40" height="12" key="staticText-153"/> <box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font pdfFontName="Helvetica-Bold" size="8" isBold="true"/> </textElement> <text><![CDATA[]]></text> </staticText> <staticText> <reportElement x="362" y="24" width="54" height="12" key="staticText-154"/> <box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font pdfFontName="Helvetica-Bold" size="8" isBold="true"/> </textElement> <text><![CDATA[]]></text> </staticText> <staticText> <reportElement x="0" y="24" width="21" height="12" key="staticText-155"/> <box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font pdfFontName="Helvetica-Bold" size="8" isBold="true"/> </textElement> <text><![CDATA[]]></text> </staticText> <staticText> <reportElement x="21" y="24" width="30" height="12" key="staticText-156"/> <box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font pdfFontName="Helvetica-Bold" size="8" isBold="true"/> </textElement> <text><![CDATA[]]></text> </staticText> <staticText> <reportElement x="51" y="24" width="36" height="12" key="staticText-157"/> <box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font pdfFontName="Helvetica-Bold" size="8" isBold="true"/> </textElement> <text><![CDATA[]]></text> </staticText> <staticText> <reportElement x="87" y="24" width="72" height="12" key="staticText-158"/> <box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font pdfFontName="Helvetica-Bold" size="8" isBold="true"/> </textElement> <text><![CDATA[]]></text> </staticText> <staticText> <reportElement x="159" y="24" width="71" height="12" key="staticText-159"/> <box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font pdfFontName="Helvetica-Bold" size="8" isBold="true"/> </textElement> <text><![CDATA[]]></text> </staticText> <staticText> <reportElement x="230" y="36" width="45" height="11" key="staticText-160"/> <box topBorder="1Point" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="1Point" bottomBorderColor="#000000"/> <textElement textAlignment="Cen Link to comment Share on other sites More sharing options...
szaharia Posted June 13, 2007 Share Posted June 13, 2007 Hi again, I tested your sample on iReport 1.3.3 using an empty data source, a JPG file named "logo.jpg", and the JExcelAPI preview, and the image was successfully loaded (using the simple Excel preview did not load the image, as we dicussed earlier). I tested the sample using a simple java test class too, and I exported the report to Excel using the JExcelAPI. The generated xls file contained the image too. Speaking about iReport 1.2.7 I can tell you that it certainly used a png encoder version incompatible with that one used in JasperReports engine. The most safe operation you could do is to upgrade your iReport and JasperReports to their latest versions from here. HTH,sanda Link to comment Share on other sites More sharing options...
r_praveen Posted June 14, 2007 Author Share Posted June 14, 2007 Thanks For your Corporation If I change my Image type .jpg to some other, then is it possible to display image with the same version of IREPORT. If yes then, what type of image I can use to display on Excel Sheet. If No then is there any possibility of non working of Existing reports created with IReport 1.2.7 when I Migrate to IReport1.3.3 from IReport 1.2.7 Thanks & RegardsPraveen Link to comment Share on other sites More sharing options...
r_praveen Posted June 15, 2007 Author Share Posted June 15, 2007 Hi sanda According to ur suggestion , i have downloaded ireport1.3.3 and Use latest jars in my project.but still i am facing the same problem. can u pls send me Ur code that u have tested to export image in Excel report. or some other suggestion that can help me in solving my problem. ThanksPraveen Link to comment Share on other sites More sharing options...
szaharia Posted June 15, 2007 Share Posted June 15, 2007 I'm very sorry for all your troubles...So, I installed the iReport 1.3.3 in a Windows XP with jdk 1.5 environment; in the iReport main window I opened the simplified Cosumers_Detail.jrxml file (you'll see ii attached here: it contains only the page header with the incriminated image) and executed it using an empty data source, and JExcelAPI preview. The report was exported to Excel, and the image was contained in it.Speaking about testing with a simple java class, my export method had this body:Code: And all was allright again.Maybe there's something wrong with that particular image. You could try with another one, just for comparing. I really hope this to be helpful,sanda [file name=Cosumers_Detail.jrxml size=6009]http://www.jasperforge.org/components/com_joomlaboard/uploaded/files/Cosumers_Detail.jrxml[/file] ]http://www.jasperforge.org/components/com_joomlaboard/uploaded/images/logo.jpg Link to comment Share on other sites More sharing options...
r_praveen Posted June 15, 2007 Author Share Posted June 15, 2007 Hi sandaSorry , I think i Have not told u that I am using jasper report in my WEB application.I am not Saving my report anywhere during generating my report. It is totally upto user that user want to Only see the Excel report or save report. This is done by Showing a dialog box to user. according to me that This code will create a report on My accplication server.But i dont want to save any report on servers hard disk. Please help me. How this can be achieved.My report is displayed on Client Side properly but only without image. Thanks & regards Praveen Rani Link to comment Share on other sites More sharing options...
szaharia Posted June 15, 2007 Share Posted June 15, 2007 The only thing you need when exporting a report is the JasperPrint object. It doesn't matter how did you get it. Your exporter settings are well written, then:Code:exporterXLS.setParameter(JExcelApiExporterParameter.JASPER_PRINT, jasperPrint); exporterXLS.setParameter(JExcelApiExporterParameter.OUTPUT_STREAM, outStream);The only condition to successfully run the export is the jasperPrint object to be a valid one. So, I think there are 2 possibilities here:1. The jasperPrint object is wrong. To be sure that you have the appropriate version, try to recompile and refill the jrxml and generate again the jasperPrint, using the JasperReports 1.3.3 version2. Just in case: please verify that you really removed the old versions of JasperReport and iReport from your classpath and from your lib directory too (you know that searching in the classpath finishes when first occurence of the object is reached). Keep going,sanda Link to comment Share on other sites More sharing options...
r_praveen Posted June 15, 2007 Author Share Posted June 15, 2007 Hi sandaI have checked my jar files. I have completely replaced my old version of Ireport. Now i am facing some other type of exception :======================================================================javax.faces.FacesException: Error calling action method of component with id objectpanel:_id55:_id80 at org.apache.myfaces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:74) at javax.faces.component.UICommand.broadcast(UICommand.java:106) at javax.faces.component.UIViewRoot._broadcastForPhase(UIViewRoot.java:90) at javax.faces.component.UIViewRoot.processApplication(UIViewRoot.java:164) at org.apache.myfaces.lifecycle.LifecycleImpl.invokeApplication(LifecycleImpl.java:271) at org.apache.myfaces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:86) at javax.faces.webapp.FacesServlet.service(FacesServlet.java:94) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:284) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:204) at org.apache.myfaces.component.html.util.ExtensionsFilter.doFilter(ExtensionsFilter.java:92) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:233) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:204) at com.klgsystel.vidushi.common.UserAuthorizationFilter.doFilter(UserAuthorizationFilter.java:60) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:233) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:204) at org.apache.myfaces.component.html.util.ExtensionsFilter.doFilter(ExtensionsFilter.java:92) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:233) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:204) at org.apache.myfaces.component.html.util.ExtensionsFilter.doFilter(ExtensionsFilter.java:122) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:233) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:204) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:257) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:151) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:567) at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:245) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:199) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:151) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:567) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:184) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:151) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:164) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:149) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:567) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:156) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:151) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:567) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:972) at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:206) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:833) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:732) at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:619) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:688) at java.lang.Thread.run(Thread.java:534)Caused by: javax.faces.el.EvaluationException: Exception while invoking expression #{queryDataModel.showReport} at org.apache.myfaces.el.MethodBindingImpl.invoke(MethodBindingImpl.java:153) at org.apache.myfaces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:63) ... 42 moreCaused by: java.lang.IllegalAccessError: tried to access method jxl.write.biff.WritableFontRecord.setStruckout(Z)V from class net.sf.jasperreports.engine.export.JExcelApiExporter at net.sf.jasperreports.engine.export.JExcelApiExporter.getLoadedFont(JExcelApiExporter.java:886) at net.sf.jasperreports.engine.export.JExcelApiExporter.addBlankCell(JExcelApiExporter.java:240) at net.sf.jasperreports.engine.export.JRXlsAbstractExporter.exportPage(JRXlsAbstractExporter.java:446) at net.sf.jasperreports.engine.export.JRXlsAbstractExporter.exportReportToStream(JRXlsAbstractExporter.java:346) at net.sf.jasperreports.engine.export.JRXlsAbstractExporter.exportReport(JRXlsAbstractExporter.java:176) at com.klgsystel.vidushi.beans.QueryDataModel.fillReport(QueryDataModel.java:836) at com.klgsystel.vidushi.beans.QueryDataModel.showExcelReport(QueryDataModel.java:791) at com.klgsystel.vidushi.beans.QueryDataModel.createReport(QueryDataModel.java:650) at com.klgsystel.vidushi.beans.QueryDataModel.showReport(QueryDataModel.java:470) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:324) at org.apache.myfaces.el.MethodBindingImpl.invoke(MethodBindingImpl.java:129) ... 43 more========================================================================== I have checkd my JasperPrint also. It is correct.My Code for calling Jasper report is:------ private void fillReport(String reportName, JasperPrint jasperPrint, String format, OutputStream outStream) throws JRException { JExcelApiExporter exporterXLS=new JExcelApiExporter(); exporterXLS.setParameter(JExcelApiExporterParameter.JASPER_PRINT, jasperPrint); exporterXLS.setParameter(JExcelApiExporterParameter.OUTPUT_STREAM, outStream); exporterXLS.setParameter(JExcelApiExporterParameter.IS_DETECT_CELL_TYPE,Boolean.TRUE); exporterXLS.setParameter(JExcelApiExporterParameter.IS_REMOVE_EMPTY_SPACE_BETWEEN_ROWS,Boolean.TRUE); exporterXLS.setParameter(JExcelApiExporterParameter.IS_WHITE_PAGE_BACKGROUND,Boolean.TRUE); exporterXLS.exportReport(); } Plese check what wrong i am doing in this code , that result in non generation of report. Thanks & regards Praveen Link to comment Share on other sites More sharing options...
szaharia Posted June 15, 2007 Share Posted June 15, 2007 Your code's ok.IllegalAccessError means incompatible changes in a given class (in this case, the jxl.write.biff.WritableFontRecord or jxl.write.WritableFont) - see hereSo, let's check again: your jxl jar should be the jxl-2.6.jar (and this have to be the only one jxl jar you have in your /lib directory); the png encoder should be the png-encoder-1.5.jar (this also should be "alone" in /lib), and the iReport and JasperReports versions are 1.3.3?Is that correct? Link to comment Share on other sites More sharing options...
r_praveen Posted June 16, 2007 Author Share Posted June 16, 2007 Hi SandaThanks for your helpNow I am able to display Logo on my excel report. Thanks a LotPtaveen Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now