problem while exporting jasper report in EXCEL

Posted on June 12, 2007 at 5:12am

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

JasperReports® Library

r_praveen

576

Joined: Oct 2 2006 - 11:16pm

Last seen: 16 years 11 months ago

14 Answers:

Posted on June 12, 2007 at 8:36am

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

shertage

22172

Joined: Sep 26 2006 - 8:06pm

Last seen: 2 months 2 weeks ago

Posted on June 13, 2007 at 7:49am

Hi
Thanks for reply
I have tried your solution.
after changing my code to
JExcelApiExporter 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.jar
jxl-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

r_praveen

576

Joined: Oct 2 2006 - 11:16pm

Last seen: 16 years 11 months ago

Posted on June 13, 2007 at 8:48am

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

shertage

22172

Joined: Sep 26 2006 - 8:06pm

Last seen: 2 months 2 weeks ago

Posted on June 13, 2007 at 9:52am

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" ?>

<!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[select
rownumber() 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">

</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">

</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">

</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">

</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">

</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">

</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">

</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">

</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">

</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">

</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">

</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">

</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">

</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">

</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">

</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">

</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">

</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">

</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">

</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">

</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">

</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">

</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">

</textElement>
<text><![CDATA[Sub]]></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">

</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">

</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">

</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">

</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">

</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">

</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">

</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">

</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">

</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">

</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">

</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">

</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">

</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">

</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">

</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">

</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">

</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">

</textElement>
<text><![CDATA

Code:

]></text><br />
				</staticText><br />
				<staticText><br />
					<reportElement<br />
						x="0"<br />
						y="12"<br />
						width="21"<br />
						height="12"<br />
						key="staticText-135"/><br />
					<box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/><br />
					<textElement textAlignment="Center" verticalAlignment="Middle"><br />
						<font pdfFontName="Helvetica-Bold" size="8" isBold="true"/><br />
					</textElement><br />
				<text><![CDATA[No.]]></text><br />
				</staticText><br />
				<staticText><br />
					<reportElement<br />
						x="21"<br />
						y="12"<br />
						width="30"<br />
						height="12"<br />
						key="staticText-136"/><br />
					<box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/><br />
					<textElement textAlignment="Center" verticalAlignment="Middle"><br />
						<font pdfFontName="Helvetica-Bold" size="8" isBold="true"/><br />
					</textElement><br />
				<text><![CDATA[Divn.]]></text><br />
				</staticText><br />
				<staticText><br />
					<reportElement<br />
						x="51"<br />
						y="12"<br />
						width="36"<br />
						height="12"<br />
						key="staticText-137"/><br />
					<box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/><br />
					<textElement textAlignment="Center" verticalAlignment="Middle"><br />
						<font pdfFontName="Helvetica-Bold" size="8" isBold="true"/><br />
					</textElement><br />
				<text><![CDATA[A/c no.]]></text><br />
				</staticText><br />
				<staticText><br />
					<reportElement<br />
						x="87"<br />
						y="12"<br />
						width="72"<br />
						height="12"<br />
						key="staticText-138"/><br />
					<box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/><br />
					<textElement textAlignment="Center" verticalAlignment="Middle"><br />
						<font pdfFontName="Helvetica-Bold" size="8" isBold="true"/><br />
					</textElement><br />
				<text><![CDATA[Name]]></text><br />
				</staticText><br />
				<staticText><br />
					<reportElement<br />
						x="159"<br />
						y="12"<br />
						width="71"<br />
						height="12"<br />
						key="staticText-139"/><br />
					<box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/><br />
					<textElement textAlignment="Center" verticalAlignment="Middle"><br />
						<font pdfFontName="Helvetica-Bold" size="8" isBold="true"/><br />
					</textElement><br />
				<text><![CDATA[Name]]></text><br />
				</staticText><br />
				<staticText><br />
					<reportElement<br />
						x="911"<br />
						y="24"<br />
						width="48"<br />
						height="12"<br />
						key="staticText-140"/><br />
					<box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#000000" rightBorder="1Point" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/><br />
					<textElement textAlignment="Center" verticalAlignment="Middle"><br />
						<font pdfFontName="Helvetica-Bold" size="8" isBold="true"/><br />
					</textElement><br />
				<text><![CDATA[]]></text><br />
				</staticText><br />
				<staticText><br />
					<reportElement<br />
						x="230"<br />
						y="24"<br />
						width="45"<br />
						height="12"<br />
						key="staticText-141"/><br />
					<box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/><br />
					<textElement textAlignment="Center" verticalAlignment="Middle"><br />
						<font pdfFontName="Helvetica-Bold" size="8" isBold="true"/><br />
					</textElement><br />
				<text><![CDATA[Connec.]]></text><br />
				</staticText><br />
				<staticText><br />
					<reportElement<br />
						x="275"<br />
						y="24"<br />
						width="52"<br />
						height="12"<br />
						key="staticText-142"/><br />
					<box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/><br />
					<textElement textAlignment="Center" verticalAlignment="Middle"><br />
						<font pdfFontName="Helvetica-Bold" size="8" isBold="true"/><br />
					</textElement><br />
				<text><![CDATA[]]></text><br />
				</staticText><br />
				<staticText><br />
					<reportElement<br />
						x="327"<br />
						y="24"<br />
						width="35"<br />
						height="12"<br />
						key="staticText-143"/><br />
					<box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/><br />
					<textElement textAlignment="Center" verticalAlignment="Middle"><br />
						<font pdfFontName="Helvetica-Bold" size="8" isBold="true"/><br />
					</textElement><br />
				<text><![CDATA[AP/R/U]]></text><br />
				</staticText><br />
				<staticText><br />
					<reportElement<br />
						x="416"<br />
						y="24"<br />
						width="32"<br />
						height="12"<br />
						key="staticText-144"/><br />
					<box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/><br />
					<textElement textAlignment="Center" verticalAlignment="Middle"><br />
						<font pdfFontName="Helvetica-Bold" size="8" isBold="true"/><br />
					</textElement><br />
				<text><![CDATA[M/S]]></text><br />
				</staticText><br />
				<staticText><br />
					<reportElement<br />
						x="448"<br />
						y="24"<br />
						width="38"<br />
						height="12"<br />
						key="staticText-145"/><br />
					<box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/><br />
					<textElement textAlignment="Center" verticalAlignment="Middle"><br />
						<font pdfFontName="Helvetica-Bold" size="8" isBold="true"/><br />
					</textElement><br />
				<text><![CDATA[K/W/X]]></text><br />
				</staticText><br />
				<staticText><br />
					<reportElement<br />
						x="486"<br />
						y="24"<br />
						width="33"<br />
						height="12"<br />
						key="staticText-146"/><br />
					<box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/><br />
					<textElement textAlignment="Center" verticalAlignment="Middle"><br />
						<font pdfFontName="Helvetica-Bold" size="8" isBold="true"/><br />
					</textElement><br />
				<text><![CDATA[Crop]]></text><br />
				</staticText><br />
				<staticText><br />
					<reportElement<br />
						x="519"<br />
						y="24"<br />
						width="31"<br />
						height="12"<br />
						key="staticText-147"/><br />
					<box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/><br />
					<textElement textAlignment="Center" verticalAlignment="Middle"><br />
						<font pdfFontName="Helvetica-Bold" size="8" isBold="true"/><br />
					</textElement><br />
				<text><![CDATA[]]></text><br />
				</staticText><br />
				<staticText><br />
					<reportElement<br />
						x="550"<br />
						y="24"<br />
						width="41"<br />
						height="12"<br />
						key="staticText-148"/><br />
					<box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/><br />
					<textElement textAlignment="Center" verticalAlignment="Middle"><br />
						<font pdfFontName="Helvetica-Bold" size="8" isBold="true"/><br />
					</textElement><br />
				<text><![CDATA[]]></text><br />
				</staticText><br />
				<staticText><br />
					<reportElement<br />
						x="591"<br />
						y="24"<br />
						width="42"<br />
						height="12"<br />
						key="staticText-149"/><br />
					<box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/><br />
					<textElement textAlignment="Center" verticalAlignment="Middle"><br />
						<font pdfFontName="Helvetica-Bold" size="8" isBold="true"/><br />
					</textElement><br />
				<text><![CDATA[]]></text><br />
				</staticText><br />
				<staticText><br />
					<reportElement<br />
						x="633"<br />
						y="24"<br />
						width="37"<br />
						height="12"<br />
						key="staticText-150"/><br />
					<box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/><br />
					<textElement textAlignment="Center" verticalAlignment="Middle"><br />
						<font pdfFontName="Helvetica-Bold" size="8" isBold="true"/><br />
					</textElement><br />
				<text><![CDATA[]]></text><br />
				</staticText><br />
				<staticText><br />
					<reportElement<br />
						x="670"<br />
						y="24"<br />
						width="35"<br />
						height="12"<br />
						key="staticText-151"/><br />
					<box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/><br />
					<textElement textAlignment="Center" verticalAlignment="Middle"><br />
						<font pdfFontName="Helvetica-Bold" size="8" isBold="true"/><br />
					</textElement><br />
				<text><![CDATA[]]></text><br />
				</staticText><br />
				<staticText><br />
					<reportElement<br />
						x="705"<br />
						y="24"<br />
						width="46"<br />
						height="12"<br />
						key="staticText-152"/><br />
					<box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/><br />
					<textElement textAlignment="Center" verticalAlignment="Middle"><br />
						<font pdfFontName="Helvetica-Bold" size="8" isBold="true"/><br />
					</textElement><br />
				<text><![CDATA[]]></text><br />
				</staticText><br />
				<staticText><br />
					<reportElement<br />
						x="751"<br />
						y="24"<br />
						width="40"<br />
						height="12"<br />
						key="staticText-153"/><br />
					<box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/><br />
					<textElement textAlignment="Center" verticalAlignment="Middle"><br />
						<font pdfFontName="Helvetica-Bold" size="8" isBold="true"/><br />
					</textElement><br />
				<text><![CDATA[]]></text><br />
				</staticText><br />
				<staticText><br />
					<reportElement<br />
						x="362"<br />
						y="24"<br />
						width="54"<br />
						height="12"<br />
						key="staticText-154"/><br />
					<box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/><br />
					<textElement textAlignment="Center" verticalAlignment="Middle"><br />
						<font pdfFontName="Helvetica-Bold" size="8" isBold="true"/><br />
					</textElement><br />
				<text><![CDATA[]]></text><br />
				</staticText><br />
				<staticText><br />
					<reportElement<br />
						x="0"<br />
						y="24"<br />
						width="21"<br />
						height="12"<br />
						key="staticText-155"/><br />
					<box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/><br />
					<textElement textAlignment="Center" verticalAlignment="Middle"><br />
						<font pdfFontName="Helvetica-Bold" size="8" isBold="true"/><br />
					</textElement><br />
				<text><![CDATA[]]></text><br />
				</staticText><br />
				<staticText><br />
					<reportElement<br />
						x="21"<br />
						y="24"<br />
						width="30"<br />
						height="12"<br />
						key="staticText-156"/><br />
					<box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/><br />
					<textElement textAlignment="Center" verticalAlignment="Middle"><br />
						<font pdfFontName="Helvetica-Bold" size="8" isBold="true"/><br />
					</textElement><br />
				<text><![CDATA[]]></text><br />
				</staticText><br />
				<staticText><br />
					<reportElement<br />
						x="51"<br />
						y="24"<br />
						width="36"<br />
						height="12"<br />
						key="staticText-157"/><br />
					<box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/><br />
					<textElement textAlignment="Center" verticalAlignment="Middle"><br />
						<font pdfFontName="Helvetica-Bold" size="8" isBold="true"/><br />
					</textElement><br />
				<text><![CDATA[]]></text><br />
				</staticText><br />
				<staticText><br />
					<reportElement<br />
						x="87"<br />
						y="24"<br />
						width="72"<br />
						height="12"<br />
						key="staticText-158"/><br />
					<box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/><br />
					<textElement textAlignment="Center" verticalAlignment="Middle"><br />
						<font pdfFontName="Helvetica-Bold" size="8" isBold="true"/><br />
					</textElement><br />
				<text><![CDATA[]]></text><br />
				</staticText><br />
				<staticText><br />
					<reportElement<br />
						x="159"<br />
						y="24"<br />
						width="71"<br />
						height="12"<br />
						key="staticText-159"/><br />
					<box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/><br />
					<textElement textAlignment="Center" verticalAlignment="Middle"><br />
						<font pdfFontName="Helvetica-Bold" size="8" isBold="true"/><br />
					</textElement><br />
				<text><![CDATA[]]></text><br />
				</staticText><br />
				<staticText><br />
					<reportElement<br />
						x="230"<br />
						y="36"<br />
						width="45"<br />
						height="11"<br />
						key="staticText-160"/><br />
					<box topBorder="1Point" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="1Point" bottomBorderColor="#000000"/><br />
					<textElement textAlignment="Cen

r_praveen

576

Joined: Oct 2 2006 - 11:16pm

Last seen: 16 years 11 months ago

Posted on June 13, 2007 at 9:56am

Code:

]></text><br />
				</staticText><br />
				<staticText><br />
					<reportElement<br />
						x="0"<br />
						y="12"<br />
						width="21"<br />
						height="12"<br />
						key="staticText-135"/><br />
					<box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/><br />
					<textElement textAlignment="Center" verticalAlignment="Middle"><br />
						<font pdfFontName="Helvetica-Bold" size="8" isBold="true"/><br />
					</textElement><br />
				<text><![CDATA[No.]]></text><br />
				</staticText><br />
				<staticText><br />
					<reportElement<br />
						x="21"<br />
						y="12"<br />
						width="30"<br />
						height="12"<br />
						key="staticText-136"/><br />
					<box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/><br />
					<textElement textAlignment="Center" verticalAlignment="Middle"><br />
						<font pdfFontName="Helvetica-Bold" size="8" isBold="true"/><br />
					</textElement><br />
				<text><![CDATA[Divn.]]></text><br />
				</staticText><br />
				<staticText><br />
					<reportElement<br />
						x="51"<br />
						y="12"<br />
						width="36"<br />
						height="12"<br />
						key="staticText-137"/><br />
					<box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/><br />
					<textElement textAlignment="Center" verticalAlignment="Middle"><br />
						<font pdfFontName="Helvetica-Bold" size="8" isBold="true"/><br />
					</textElement><br />
				<text><![CDATA[A/c no.]]></text><br />
				</staticText><br />
				<staticText><br />
					<reportElement<br />
						x="87"<br />
						y="12"<br />
						width="72"<br />
						height="12"<br />
						key="staticText-138"/><br />
					<box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/><br />
					<textElement textAlignment="Center" verticalAlignment="Middle"><br />
						<font pdfFontName="Helvetica-Bold" size="8" isBold="true"/><br />
					</textElement><br />
				<text><![CDATA[Name]]></text><br />
				</staticText><br />
				<staticText><br />
					<reportElement<br />
						x="159"<br />
						y="12"<br />
						width="71"<br />
						height="12"<br />
						key="staticText-139"/><br />
					<box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/><br />
					<textElement textAlignment="Center" verticalAlignment="Middle"><br />
						<font pdfFontName="Helvetica-Bold" size="8" isBold="true"/><br />
					</textElement><br />
				<text><![CDATA[Name]]></text><br />
				</staticText><br />
				<staticText><br />
					<reportElement<br />
						x="911"<br />
						y="24"<br />
						width="48"<br />
						height="12"<br />
						key="staticText-140"/><br />
					<box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#000000" rightBorder="1Point" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/><br />
					<textElement textAlignment="Center" verticalAlignment="Middle"><br />
						<font pdfFontName="Helvetica-Bold" size="8" isBold="true"/><br />
					</textElement><br />
				<text><![CDATA[]]></text><br />
				</staticText><br />
				<staticText><br />
					<reportElement<br />
						x="230"<br />
						y="24"<br />
						width="45"<br />
						height="12"<br />
						key="staticText-141"/><br />
					<box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/><br />
					<textElement textAlignment="Center" verticalAlignment="Middle"><br />
						<font pdfFontName="Helvetica-Bold" size="8" isBold="true"/><br />
					</textElement><br />
				<text><![CDATA[Connec.]]></text><br />
				</staticText><br />
				<staticText><br />
					<reportElement<br />
						x="275"<br />
						y="24"<br />
						width="52"<br />
						height="12"<br />
						key="staticText-142"/><br />
					<box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/><br />
					<textElement textAlignment="Center" verticalAlignment="Middle"><br />
						<font pdfFontName="Helvetica-Bold" size="8" isBold="true"/><br />
					</textElement><br />
				<text><![CDATA[]]></text><br />
				</staticText><br />
				<staticText><br />
					<reportElement<br />
						x="327"<br />
						y="24"<br />
						width="35"<br />
						height="12"<br />
						key="staticText-143"/><br />
					<box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/><br />
					<textElement textAlignment="Center" verticalAlignment="Middle"><br />
						<font pdfFontName="Helvetica-Bold" size="8" isBold="true"/><br />
					</textElement><br />
				<text><![CDATA[AP/R/U]]></text><br />
				</staticText><br />
				<staticText><br />
					<reportElement<br />
						x="416"<br />
						y="24"<br />
						width="32"<br />
						height="12"<br />
						key="staticText-144"/><br />
					<box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/><br />
					<textElement textAlignment="Center" verticalAlignment="Middle"><br />
						<font pdfFontName="Helvetica-Bold" size="8" isBold="true"/><br />
					</textElement><br />
				<text><![CDATA[M/S]]></text><br />
				</staticText><br />
				<staticText><br />
					<reportElement<br />
						x="448"<br />
						y="24"<br />
						width="38"<br />
						height="12"<br />
						key="staticText-145"/><br />
					<box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/><br />
					<textElement textAlignment="Center" verticalAlignment="Middle"><br />
						<font pdfFontName="Helvetica-Bold" size="8" isBold="true"/><br />
					</textElement><br />
				<text><![CDATA[K/W/X]]></text><br />
				</staticText><br />
				<staticText><br />
					<reportElement<br />
						x="486"<br />
						y="24"<br />
						width="33"<br />
						height="12"<br />
						key="staticText-146"/><br />
					<box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/><br />
					<textElement textAlignment="Center" verticalAlignment="Middle"><br />
						<font pdfFontName="Helvetica-Bold" size="8" isBold="true"/><br />
					</textElement><br />
				<text><![CDATA[Crop]]></text><br />
				</staticText><br />
				<staticText><br />
					<reportElement<br />
						x="519"<br />
						y="24"<br />
						width="31"<br />
						height="12"<br />
						key="staticText-147"/><br />
					<box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/><br />
					<textElement textAlignment="Center" verticalAlignment="Middle"><br />
						<font pdfFontName="Helvetica-Bold" size="8" isBold="true"/><br />
					</textElement><br />
				<text><![CDATA[]]></text><br />
				</staticText><br />
				<staticText><br />
					<reportElement<br />
						x="550"<br />
						y="24"<br />
						width="41"<br />
						height="12"<br />
						key="staticText-148"/><br />
					<box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/><br />
					<textElement textAlignment="Center" verticalAlignment="Middle"><br />
						<font pdfFontName="Helvetica-Bold" size="8" isBold="true"/><br />
					</textElement><br />
				<text><![CDATA[]]></text><br />
				</staticText><br />
				<staticText><br />
					<reportElement<br />
						x="591"<br />
						y="24"<br />
						width="42"<br />
						height="12"<br />
						key="staticText-149"/><br />
					<box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/><br />
					<textElement textAlignment="Center" verticalAlignment="Middle"><br />
						<font pdfFontName="Helvetica-Bold" size="8" isBold="true"/><br />
					</textElement><br />
				<text><![CDATA[]]></text><br />
				</staticText><br />
				<staticText><br />
					<reportElement<br />
						x="633"<br />
						y="24"<br />
						width="37"<br />
						height="12"<br />
						key="staticText-150"/><br />
					<box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/><br />
					<textElement textAlignment="Center" verticalAlignment="Middle"><br />
						<font pdfFontName="Helvetica-Bold" size="8" isBold="true"/><br />
					</textElement><br />
				<text><![CDATA[]]></text><br />
				</staticText><br />
				<staticText><br />
					<reportElement<br />
						x="670"<br />
						y="24"<br />
						width="35"<br />
						height="12"<br />
						key="staticText-151"/><br />
					<box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/><br />
					<textElement textAlignment="Center" verticalAlignment="Middle"><br />
						<font pdfFontName="Helvetica-Bold" size="8" isBold="true"/><br />
					</textElement><br />
				<text><![CDATA[]]></text><br />
				</staticText><br />
				<staticText><br />
					<reportElement<br />
						x="705"<br />
						y="24"<br />
						width="46"<br />
						height="12"<br />
						key="staticText-152"/><br />
					<box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/><br />
					<textElement textAlignment="Center" verticalAlignment="Middle"><br />
						<font pdfFontName="Helvetica-Bold" size="8" isBold="true"/><br />
					</textElement><br />
				<text><![CDATA[]]></text><br />
				</staticText><br />
				<staticText><br />
					<reportElement<br />
						x="751"<br />
						y="24"<br />
						width="40"<br />
						height="12"<br />
						key="staticText-153"/><br />
					<box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/><br />
					<textElement textAlignment="Center" verticalAlignment="Middle"><br />
						<font pdfFontName="Helvetica-Bold" size="8" isBold="true"/><br />
					</textElement><br />
				<text><![CDATA[]]></text><br />
				</staticText><br />
				<staticText><br />
					<reportElement<br />
						x="362"<br />
						y="24"<br />
						width="54"<br />
						height="12"<br />
						key="staticText-154"/><br />
					<box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/><br />
					<textElement textAlignment="Center" verticalAlignment="Middle"><br />
						<font pdfFontName="Helvetica-Bold" size="8" isBold="true"/><br />
					</textElement><br />
				<text><![CDATA[]]></text><br />
				</staticText><br />
				<staticText><br />
					<reportElement<br />
						x="0"<br />
						y="24"<br />
						width="21"<br />
						height="12"<br />
						key="staticText-155"/><br />
					<box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/><br />
					<textElement textAlignment="Center" verticalAlignment="Middle"><br />
						<font pdfFontName="Helvetica-Bold" size="8" isBold="true"/><br />
					</textElement><br />
				<text><![CDATA[]]></text><br />
				</staticText><br />
				<staticText><br />
					<reportElement<br />
						x="21"<br />
						y="24"<br />
						width="30"<br />
						height="12"<br />
						key="staticText-156"/><br />
					<box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/><br />
					<textElement textAlignment="Center" verticalAlignment="Middle"><br />
						<font pdfFontName="Helvetica-Bold" size="8" isBold="true"/><br />
					</textElement><br />
				<text><![CDATA[]]></text><br />
				</staticText><br />
				<staticText><br />
					<reportElement<br />
						x="51"<br />
						y="24"<br />
						width="36"<br />
						height="12"<br />
						key="staticText-157"/><br />
					<box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/><br />
					<textElement textAlignment="Center" verticalAlignment="Middle"><br />
						<font pdfFontName="Helvetica-Bold" size="8" isBold="true"/><br />
					</textElement><br />
				<text><![CDATA[]]></text><br />
				</staticText><br />
				<staticText><br />
					<reportElement<br />
						x="87"<br />
						y="24"<br />
						width="72"<br />
						height="12"<br />
						key="staticText-158"/><br />
					<box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/><br />
					<textElement textAlignment="Center" verticalAlignment="Middle"><br />
						<font pdfFontName="Helvetica-Bold" size="8" isBold="true"/><br />
					</textElement><br />
				<text><![CDATA[]]></text><br />
				</staticText><br />
				<staticText><br />
					<reportElement<br />
						x="159"<br />
						y="24"<br />
						width="71"<br />
						height="12"<br />
						key="staticText-159"/><br />
					<box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/><br />
					<textElement textAlignment="Center" verticalAlignment="Middle"><br />
						<font pdfFontName="Helvetica-Bold" size="8" isBold="true"/><br />
					</textElement><br />
				<text><![CDATA[]]></text><br />
				</staticText><br />
				<staticText><br />
					<reportElement<br />
						x="230"<br />
						y="36"<br />
						width="45"<br />
						height="11"<br />
						key="staticText-160"/><br />
					<box topBorder="1Point" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="1Point" bottomBorderColor="#000000"/><br />
					<textElement textAlignment="Cen

r_praveen

576

Joined: Oct 2 2006 - 11:16pm

Last seen: 16 years 11 months ago

Posted on June 13, 2007 at 12:07pm

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 [url=http://www.jasperforge.org/index.php?option=com_content&task=section&id=....

HTH,
sanda

shertage

22172

Joined: Sep 26 2006 - 8:06pm

Last seen: 2 months 2 weeks ago

Posted on June 14, 2007 at 6:11am

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 & Regards
Praveen

r_praveen

576

Joined: Oct 2 2006 - 11:16pm

Last seen: 16 years 11 months ago

Posted on June 15, 2007 at 7:03am

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.

Thanks
Praveen

r_praveen

576

Joined: Oct 2 2006 - 11:16pm

Last seen: 16 years 11 months ago

Posted on June 15, 2007 at 9:42am

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:

					<br />
File sourceFile = new File("Cosumers_Detail.jrprint"Â«Â»);<br />
File destFile = new File("Cosumers_Detail.xls"Â«Â»);<br />
JasperPrint jasperPrint = (JasperPrint)JRLoader.loadObject(sourceFile);<br />
JExcelApiExporter exporter = new JExcelApiExporter();<br />
exporter.setParameter(JRExporterParameter.JASPER_PRINT, jasperPrint);<br />
exporter.setParameter(JRExporterParameter.OUTPUT_FILE_NAME, destFile.toString());<br />
exporter.setParameter(JRXlsExporterParameter.IS_ONE_PAGE_PER_SHEET, Boolean.TRUE);<br />
exporter.setParameter(JRXlsExporterParameter.IS_DETECT_CELL_TYPE, Boolean.TRUE);<br />
exporter.exportReport();<br />
</td></tr></tbody></table><br />
<br />
And all was allright again.<br />
Maybe there's something wrong with that particular image. You could try with another one, just for comparing.<br />
<br />
I really hope this to be helpful,<br />
sanda [file name=Cosumers_Detail.jrxml size=6009]http://www.jasperforge.org/components/com_joomlaboard/uploaded/files/Cosumers_Detail.jrxml[/file] ]<img src="http://www.jasperforge.org/components/com_joomlaboard/uploaded/images/logo.jpg" width="Array"></img>

shertage

22172

Joined: Sep 26 2006 - 8:06pm

Last seen: 2 months 2 weeks ago

Posted on June 15, 2007 at 10:34am

Hi sanda
Sorry , 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

r_praveen

576

Joined: Oct 2 2006 - 11:16pm

Last seen: 16 years 11 months ago

Posted on June 15, 2007 at 11:03am

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:

<br />
exporterXLS.setParameter(JExcelApiExporterParameter.JASPER_PRINT, jasperPrint); <br />
exporterXLS.setParameter(JExcelApiExporterParameter.OUTPUT_STREAM, outStream);<br />
</td></tr></tbody></table><br />
The only condition to successfully run the export is the jasperPrint object to be a valid one. <br />
So, I think there are 2 possibilities here:<br />
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 version<br />
2. Just in case: please verify that you really <b>removed</b> 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).<br />
<br />
Keep going,<br />
sanda

shertage

22172

Joined: Sep 26 2006 - 8:06pm

Last seen: 2 months 2 weeks ago

Posted on June 15, 2007 at 12:27pm

Hi sanda
I 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 more
Caused 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

r_praveen

576

Joined: Oct 2 2006 - 11:16pm

Last seen: 16 years 11 months ago

Posted on June 15, 2007 at 1:40pm

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 [url=http://java.sun.com/j2se/1.4.2/docs/api/java/lang/IllegalAccessError.htm...
So, 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?

shertage

22172

Joined: Sep 26 2006 - 8:06pm

Last seen: 2 months 2 weeks ago

Posted on June 16, 2007 at 5:36am

Hi Sanda
Thanks for your help
Now I am able to display Logo on my excel report.

Thanks a Lot
Ptaveen

r_praveen

576

Joined: Oct 2 2006 - 11:16pm

Last seen: 16 years 11 months ago

Main menu

problem while exporting jasper report in EXCEL

14 Answers:

Tags

Main menu

You are here

problem while exporting jasper report in EXCEL

14 Answers:

Tags