Jump to content
Changes to the Jaspersoft community edition download ×

problem while exporting jasper report in EXCEL


r_praveen

Recommended Posts

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

  • Replies 14
  • Created
  • Last Reply

Top Posters In This Topic

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

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

Link to comment
Share on other sites

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

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

<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><![CDATA

Code:
]></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

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

<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><![CDATA

Code:
]></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

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

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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

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

Link to comment
Share on other sites

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 version

2. 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

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

Link to comment
Share on other sites

Link to comment
Share on other sites

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 account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...