Jump to content
We've recently updated our Privacy Statement, available here ×

How to Unmerge Cells in Excel Export Jasper Report

chitra.elumalai

By chitra.elumalai
in Products

 Share

Recommended Posts

chitra.elumalai Rookie

chitra.elumalai

Posted
Posted

Hi,

I have created my template and it looks good when exported in PDF. But the Cells get merged when the report output is exported in Excel.

To be more clear , Column A in Jasper Report occupies Column A and B in Excel.

Could anyone please help in providing solution for this issue please?

Link to comment
Share on other sites
  • Replies 4
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Popular Days

hozawa Grand Master

hozawa

Posted
Posted

The point with Excel export is to make text fields aligned. Even a pixel difference will create a new column. Make sure all text and static text are vertically aligned on the left and on the right. Attaching a sample of your jrxml will help in better answering your question.

Link to comment
Share on other sites
chitra.elumalai Rookie

chitra.elumalai

Posted
  • Author
Posted

<?xml version="1.0" encoding="UTF-8"?>
<!-- Created with Jaspersoft Studio version last-->
<jasperReport xmlns="http://jasperreports.sourceforge.net/jasperreports" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports http://jasperreports.sourceforge.net/xsd/jasperreport.xsd" name="Report_1" language="groovy" pageWidth="1300" pageHeight="640" orientation="Landscape" whenNoDataType="NoDataSection" columnWidth="1280" leftMargin="10" rightMargin="10" topMargin="20" bottomMargin="20" uuid="8c117bc2-0e63-4a99-95cf-b2737fb6a6ca">
 <property name="ireport.zoom" value="1.1269722013523666"/>
 <property name="ireport.x" value="0"/>
 <property name="ireport.y" value="0"/>
 <property name="net.sf.jasperreports.export.xls.wrap.text" value="true"/>
 <property name="net.sf.jasperreports.export.xls.column.width.ratio" value="1.10f"/>
 <property name="net.sf.jasperreports.export.xls.auto.fit.column" value="true"/>
 <property name="net.sf.jasperreports.export.xls.exclude.origin.band.1" value="pageHeader"/>
 <property name="net.sf.jasperreports.export.xls.exclude.origin.band.2" value="pageFooter"/>
 <property name="net.sf.jasperreports.export.xls.exclude.origin.band.3" value="lastPageFooter"/>
 <property name="net.sf.jasperreports.export.xls.ignore.cell.background" value="true"/>
 <property name="net.sf.jasperreports.export.xls.white.page.background" value="false"/>
 <property name="net.sf.jasperreports.export.xls.ignore.graphics" value="true"/>
 <property name="net.sf.jasperreports.export.xls.detect.cell.type=true"/>
 <property name="net.sf.jasperreports.export.xls.remove.empty.space.between.rows=true"/>
 <property name="net.sf.jasperreports.export.xls.remove.empty.space.between.columns=true"/>
 <property name="net.sf.jasperreports.export.xls.collapse.row.span" value="true"/>
 <property name="net.sf.jasperreports.export.xls.ignore.page.margins=true"/>
 <property name="net.sf.jasperreports.export.xls.one.page.per.sheet=true"/>
 <property name="com.jaspersoft.studio.unit." value="pixel"/>
 <property name="com.jaspersoft.studio.data.defaultdataadapter" value="Vertica_Dev"/>
 <property name="com.jaspersoft.studio.unit.pageHeight" value="pixel"/>
 <property name="com.jaspersoft.studio.unit.pageWidth" value="pixel"/>
 <property name="com.jaspersoft.studio.unit.topMargin" value="pixel"/>
 <property name="com.jaspersoft.studio.unit.bottomMargin" value="pixel"/>
 <property name="com.jaspersoft.studio.unit.leftMargin" value="pixel"/>
 <property name="com.jaspersoft.studio.unit.rightMargin" value="pixel"/>
 <property name="com.jaspersoft.studio.unit.columnWidth" value="pixel"/>
 <property name="com.jaspersoft.studio.unit.columnSpacing" value="pixel"/>
 <parameter name="selectedParam1" class="java.lang.String"/>
 <parameter name="selectedParam2" class="java.lang.String"/>
 <parameter name=" Report_executor_name" class="java.lang.String" isForPrompting="false"/>
 <parameter name="report_owner_id" class="java.lang.String" isForPrompting="false"/>
 <parameter name="OPTIONAL_OUTPUT_NAME" class="java.lang.String" isForPrompting="false"/>
 <parameter name="requesting_user_id" class="java.lang.String" isForPrompting="false"/>
 <parameter name="selectedParam3" class="java.lang.String"/>
 <parameter name="selectedParam4" class="java.lang.String"/>
 <parameter name="requesting_user_name" class="java.lang.String" isForPrompting="false"/>
 <queryString language="SQL">
  <![CDATA[select COL_1,sum(COL_2) as COL_2,sum(COL_3) as  COL_3,sum(COL_4) as COL_4
 from Table_1
WHERE Date=TO_DATE( $P{selectedParam2} ,'yyyy/MM/dd')
AND instr( $P{selectedParam1}, COL_5) > 0
AND INSTR( $P{selectedParam3} ,COL_1) > 0
AND INSTR( $P{selectedParam4},COL_6) >0
group by COL_1]]>
 </queryString>
 <field name="COL_2" class="java.math.BigDecimal"/>
 <field name="COL_3" class="java.math.BigDecimal"/>
 <field name="COL_4" class="java.math.BigDecimal"/>
 <field name="COL_1" class="java.lang.String"/>
 <variable name="CURR" class="java.math.BigDecimal" calculation="Sum">
  <variableExpression><![CDATA[$F{COL_2}.intValue() == -0.00 ? 0.00 : $F{COL_2}]]></variableExpression>
 </variable>
 <variable name="PREV" class="java.math.BigDecimal" calculation="Sum">
  <variableExpression><![CDATA[$F{COL_3}.intValue() == -0.00 ? 0.00 :$F{COL_3}]]></variableExpression>
 </variable>
 <variable name="PREY" class="java.math.BigDecimal" calculation="Sum">
  <variableExpression><![CDATA[$F{COL_4}.intValue() == -0.00 ? 0.00 :$F{COL_4}]]></variableExpression>
 </variable>
 <variable name="QTO" class="java.math.BigDecimal" calculation="Sum">
  <variableExpression><![CDATA[$F{COL_2}.intValue() == -0.00 ? 0.00 : ($F{COL_3}.intValue() == -0.00 ? 0.00 :($F{COL_2}-$F{COL_3}))]]></variableExpression>
 </variable>
 <variable name="YO" class="java.math.BigDecimal" calculation="Sum">
  <variableExpression><![CDATA[$F{COL_2}.intValue() == -0.00 ? 0.00:($F{COL_4}.intValue()==-0.00 ? 0.00:($F{COL_2}-$F{COL_4}))]]></variableExpression>
 </variable>
 <group name="Group1">
  <groupExpression><![CDATA[$F{COL_1}]]></groupExpression>
 </group>
 <background>
  <band height="455">
   <staticText>
    <reportElement mode="Transparent" x="360" y="150" width="400" height="130" forecolor="#CCCCCC" uuid="eb6775df-e908-4cda-b76e-9fdda26b7de2">
     <property name="net.sf.jasperreports.export.xls.cell.hidden" value="true"/>
    </reportElement>
    <textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
     <font fontName="DejaVu Sans" size="96"/>
     <paragraph lineSpacing="Single" tabStopWidth="100"/>
    </textElement>
    <text><![CDATA[DRAFT]]></text>
   </staticText>
  </band>
 </background>
 <title>
  <band height="55" splitType="Stretch"/>
 </title>
 <pageHeader>
  <band height="56" splitType="Stretch">
   <staticText>
    <reportElement mode="Opaque" x="137" y="0" width="1063" height="28" backcolor="#FFFFFF" uuid="3def3bf6-29a5-4bb7-8950-67ad80df49e0"/>
    <textElement textAlignment="Center" verticalAlignment="Middle" markup="none">
     <font fontName="DejaVu Sans" size="14" isBold="true"/>
    </textElement>
    <text><![CDATA[sAMPLE
]]></text>
   </staticText>
   <image onErrorType="Icon">
    <reportElement x="2" y="1" width="127" height="49" uuid="dae32997-3413-4983-8a34-b82db324004f"/>
    <imageExpression><![CDATA["/JASPER/IMAGES/Logo.gif"]]></imageExpression>
   </image>
   <textField pattern="yyyy/MM/dd" isBlankWhenNull="false">
    <reportElement x="137" y="28" width="1063" height="28" uuid="36014ff4-8198-451d-bd16-64d29ebbbf9d"/>
    <textElement textAlignment="Center" verticalAlignment="Middle">
     <font fontName="DejaVu Sans" size="14" isBold="true"/>
    </textElement>
    <textFieldExpression><![CDATA["Report_1 "+$P{selectedParam2}]]></textFieldExpression>
   </textField>
  </band>
 </pageHeader>
 <columnHeader>
  <band height="36" splitType="Stretch">
   <staticText>
    <reportElement mode="Transparent" x="0" y="0" width="150" height="36" backcolor="#FFFFFF" uuid="763336f1-9f0e-4f00-a54c-ee46c717a1d9">
     <property name="local_mesure_unitwidth" value="pixel"/>
     <property name="com.jaspersoft.studio.unit.width" value="px"/>
    </reportElement>
    <box>
     <pen lineWidth="0.5" lineStyle="Solid" lineColor="#333300"/>
     <topPen lineWidth="0.5" lineStyle="Solid" lineColor="#333300"/>
     <leftPen lineWidth="0.5" lineStyle="Solid" lineColor="#333300"/>
     <bottomPen lineWidth="0.5" lineStyle="Solid" lineColor="#333300"/>
     <rightPen lineWidth="0.5" lineStyle="Solid" lineColor="#333300"/>
    </box>
    <textElement textAlignment="Center" verticalAlignment="Bottom">
     <font fontName="DejaVu Sans" size="12" isBold="true"/>
    </textElement>
    <text><![CDATA[COL_1]]></text>
   </staticText>
   <textField>
    <reportElement mode="Transparent" x="450" y="0" width="150" height="36" forecolor="#000000" backcolor="#FFFFFF" uuid="8bf6e5e6-d5cf-4d12-8b0c-9dc928b58c1d">
     <property name="local_mesure_unitx" value="pixel"/>
     <property name="com.jaspersoft.studio.unit.x" value="px"/>
     <property name="local_mesure_unitwidth" value="pixel"/>
     <property name="com.jaspersoft.studio.unit.width" value="px"/>
    </reportElement>
    <box padding="0" topPadding="0" leftPadding="0" bottomPadding="0" rightPadding="0">
     <pen lineWidth="0.5" lineColor="#333300"/>
     <topPen lineWidth="0.5" lineColor="#333300"/>
     <leftPen lineWidth="0.5" lineColor="#333300"/>
     <bottomPen lineWidth="0.5" lineColor="#333300"/>
     <rightPen lineWidth="0.5" lineColor="#333300"/>
    </box>
    <textElement textAlignment="Center" verticalAlignment="Bottom" rotation="None" markup="none">
     <font fontName="DejaVu Sans" size="12" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfFontName="Helvetica" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
     <paragraph lineSpacing="Single" lineSpacingSize="1.0" firstLineIndent="0" leftIndent="0" rightIndent="0" spacingBefore="0" spacingAfter="0" tabStopWidth="40"/>
    </textElement>
    <textFieldExpression><![CDATA[$P{selectedParam2}.contains("2015/12/31")?"4Q14":$P{selectedParam2}.contains("2015/03/31")?"1Q14":$P{selectedParam2}.contains("2015/09/30")?"3Q14":$P{selectedParam2}.contains("2015/06/30")?"2Q14":$P{selectedParam2}.contains("2016/12/31")?"4Q15":$P{selectedParam2}.contains("2016/03/31")?"1Q15":$P{selectedParam2}.contains("2016/09/30")?"3Q15":$P{selectedParam2}.contains("2016/06/30")?"2Q15":$P{selectedParam2}.contains("2017/12/31")?"4Q16":$P{selectedParam2}.contains("2017/03/31")?"1Q16":$P{selectedParam2}.contains("2017/09/30")?"3Q16":$P{selectedParam2}.contains("2017/06/30")?"2Q16":$P{selectedParam2}.contains("2014/12/31")?"4Q13":$P{selectedParam2}.contains("2014/03/31")?"1Q13":$P{selectedParam2}.contains("2014/09/30")?"3Q13":$P{selectedParam2}.contains("2014/06/30")?"2Q13":"null"]]></textFieldExpression>
   </textField>
   <staticText>
    <reportElement mode="Transparent" x="600" y="0" width="150" height="36" backcolor="#FFFFFF" uuid="4a253c9f-3108-4431-827e-6df7574329d4">
     <property name="local_mesure_unitwidth" value="pixel"/>
     <property name="com.jaspersoft.studio.unit.width" value="px"/>
     <property name="local_mesure_unitx" value="pixel"/>
     <property name="com.jaspersoft.studio.unit.x" value="px"/>
    </reportElement>
    <box>
     <pen lineWidth="0.5" lineColor="#333300"/>
     <topPen lineWidth="0.5" lineStyle="Solid" lineColor="#333300"/>
     <leftPen lineWidth="0.5" lineStyle="Solid" lineColor="#333300"/>
     <bottomPen lineWidth="0.5" lineStyle="Solid" lineColor="#333300"/>
     <rightPen lineWidth="0.5" lineStyle="Solid" lineColor="#333300"/>
    </box>
    <textElement textAlignment="Center" verticalAlignment="Bottom">
     <font fontName="DejaVu Sans" size="12" isBold="true"/>
    </textElement>
    <text><![CDATA[QTC]]></text>
   </staticText>
   <staticText>
    <reportElement mode="Transparent" x="750" y="0" width="150" height="36" backcolor="#FFFFFF" uuid="3466b96f-7fbf-4bbd-b697-d8b41ca0a3db">
     <property name="local_mesure_unitwidth" value="pixel"/>
     <property name="com.jaspersoft.studio.unit.width" value="px"/>
     <property name="local_mesure_unitx" value="pixel"/>
     <property name="com.jaspersoft.studio.unit.x" value="px"/>
    </reportElement>
    <box>
     <pen lineWidth="0.5" lineColor="#333300"/>
     <topPen lineWidth="0.5" lineColor="#333300"/>
     <leftPen lineWidth="0.5" lineColor="#333300"/>
     <bottomPen lineWidth="0.5" lineColor="#333300"/>
     <rightPen lineWidth="0.5" lineColor="#333300"/>
    </box>
    <textElement textAlignment="Center" verticalAlignment="Bottom">
     <font fontName="DejaVu Sans" size="12" isBold="true"/>
    </textElement>
    <text><![CDATA[QTI]]></text>
   </staticText>
   <staticText>
    <reportElement mode="Transparent" x="900" y="0" width="150" height="36" backcolor="#FFFFFF" uuid="74331e05-2c1a-427e-a8ba-7764adc0f988">
     <property name="local_mesure_unitx" value="pixel"/>
     <property name="com.jaspersoft.studio.unit.x" value="px"/>
     <property name="local_mesure_unitwidth" value="pixel"/>
     <property name="com.jaspersoft.studio.unit.width" value="px"/>
    </reportElement>
    <box>
     <pen lineWidth="0.5" lineColor="#333300"/>
     <topPen lineWidth="0.5" lineColor="#333300"/>
     <leftPen lineWidth="0.5" lineColor="#333300"/>
     <bottomPen lineWidth="0.5" lineColor="#333300"/>
     <rightPen lineWidth="0.5" lineColor="#333300"/>
    </box>
    <textElement textAlignment="Center" verticalAlignment="Bottom">
     <font fontName="DejaVu Sans" size="12" isBold="true"/>
    </textElement>
    <text><![CDATA[YOC]]></text>
   </staticText>
   <staticText>
    <reportElement mode="Transparent" x="1050" y="0" width="150" height="36" backcolor="#FFFFFF" uuid="1a16e579-01cb-4994-beb5-67a7501f916a"/>
    <box>
     <pen lineWidth="0.5" lineColor="#333300"/>
     <topPen lineWidth="0.5" lineColor="#333300"/>
     <leftPen lineWidth="0.5" lineColor="#333300"/>
     <bottomPen lineWidth="0.5" lineColor="#333300"/>
     <rightPen lineWidth="0.5" lineColor="#333300"/>
    </box>
    <textElement textAlignment="Center" verticalAlignment="Bottom">
     <font fontName="DejaVu Sans" size="12" isBold="true"/>
    </textElement>
    <text><![CDATA[YOI]]></text>
   </staticText>
   <textField>
    <reportElement mode="Transparent" x="150" y="0" width="150" height="36" forecolor="#000000" backcolor="#FFFFFF" uuid="4b81cdd1-7821-474f-bc1b-b44ff88af327">
     <property name="local_mesure_unitx" value="pixel"/>
     <property name="com.jaspersoft.studio.unit.x" value="px"/>
     <property name="local_mesure_unitwidth" value="pixel"/>
     <property name="com.jaspersoft.studio.unit.width" value="px"/>
    </reportElement>
    <box padding="0" topPadding="0" leftPadding="0" bottomPadding="0" rightPadding="0">
     <pen lineWidth="0.5" lineStyle="Solid" lineColor="#333300"/>
     <topPen lineWidth="0.5" lineStyle="Solid" lineColor="#333300"/>
     <leftPen lineWidth="0.5" lineStyle="Solid" lineColor="#333300"/>
     <bottomPen lineWidth="0.5" lineStyle="Solid" lineColor="#333300"/>
     <rightPen lineWidth="0.5" lineStyle="Solid" lineColor="#333300"/>
    </box>
    <textElement textAlignment="Center" verticalAlignment="Bottom" rotation="None" markup="none">
     <font fontName="DejaVu Sans" size="12" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfFontName="Helvetica" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
     <paragraph lineSpacing="Single" lineSpacingSize="1.0" firstLineIndent="0" leftIndent="0" rightIndent="0" spacingBefore="0" spacingAfter="0" tabStopWidth="40"/>
    </textElement>
    <textFieldExpression><![CDATA[$P{selectedParam2}.contains("2015/12/31")?"4Q15":$P{selectedParam2}.contains("2015/03/31")?"1Q15":$P{selectedParam2}.contains("2015/09/30")?"3Q15":$P{selectedParam2}.contains("2015/06/30")?"2Q15":$P{selectedParam2}.contains("2014/12/31")?"4Q14":$P{selectedParam2}.contains("2014/03/31")?"1Q14":$P{selectedParam2}.contains("2014/09/30")?"3Q14":$P{selectedParam2}.contains("2014/06/30")?"2Q14":$P{selectedParam2}.contains("2016/12/31")?"4Q16":$P{selectedParam2}.contains("2016/03/31")?"1Q16":$P{selectedParam2}.contains("2016/09/30")?"3Q16":$P{selectedParam2}.contains("2016/06/30")?"2Q16":$P{selectedParam2}.contains("2013/12/31")?"4Q13":$P{selectedParam2}.contains("2013/03/31")?"1Q13":$P{selectedParam2}.contains("2013/09/30")?"3Q13":$P{selectedParam2}.contains("2013/06/30")?"2Q13":$P{selectedParam2}.contains("2017/12/31")?"4Q17":$P{selectedParam2}.contains("2017/03/31")?"1Q17":$P{selectedParam2}.contains("2017/09/30")?"3Q17":$P{selectedParam2}.contains("2017/06/30")?"2Q17":"null"]]></textFieldExpression>
   </textField>
   <textField>
    <reportElement mode="Transparent" x="300" y="0" width="150" height="36" forecolor="#000000" backcolor="#FFFFFF" uuid="700ba806-0c5b-48cc-b0da-9fbbd51f9327">
     <property name="local_mesure_unitx" value="pixel"/>
     <property name="com.jaspersoft.studio.unit.x" value="px"/>
     <property name="local_mesure_unitwidth" value="pixel"/>
     <property name="com.jaspersoft.studio.unit.width" value="px"/>
     <property name="net.sf.jasperreports.export.xls.auto.fit.column" value="true"/>
    </reportElement>
    <box padding="0" topPadding="0" leftPadding="0" bottomPadding="0" rightPadding="0">
     <pen lineWidth="0.5" lineColor="#333300"/>
     <topPen lineWidth="0.5" lineColor="#333300"/>
     <leftPen lineWidth="0.5" lineColor="#333300"/>
     <bottomPen lineWidth="0.5" lineColor="#333300"/>
     <rightPen lineWidth="0.5" lineColor="#333300"/>
    </box>
    <textElement textAlignment="Center" verticalAlignment="Bottom" rotation="None" markup="none">
     <font fontName="DejaVu Sans" size="12" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfFontName="Helvetica" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
     <paragraph lineSpacing="Single" lineSpacingSize="1.0" firstLineIndent="0" leftIndent="0" rightIndent="0" spacingBefore="0" spacingAfter="0" tabStopWidth="40"/>
    </textElement>
    <textFieldExpression><![CDATA[$P{selectedParam2}.contains("2015/12/31")?"3Q15":$P{selectedParam2}.contains("2015/03/31")?"4Q14":$P{selectedParam2}.contains("2015/09/30")?"2Q15":$P{selectedParam2}.contains("2015/06/30")?"1Q15":$P{selectedParam2}.contains("2016/12/31")?"3Q16":$P{selectedParam2}.contains("2016/03/31")?"4Q15":$P{selectedParam2}.contains("2016/09/30")?"2Q16":$P{selectedParam2}.contains("2016/06/30")?"1Q16":$P{selectedParam2}.contains("2017/12/31")?"3Q17":$P{selectedParam2}.contains("2017/03/31")?"4Q16":$P{selectedParam2}.contains("2017/09/30")?"2Q17":$P{selectedParam2}.contains("2017/06/30")?"1Q17":$P{selectedParam2}.contains("2014/12/31")?"3Q14":$P{selectedParam2}.contains("2014/03/31")?"4Q13":$P{selectedParam2}.contains("2014/09/30")?"2Q14":$P{selectedParam2}.contains("2014/06/30")?"1Q14":"null"]]></textFieldExpression>
   </textField>
  </band>
 </columnHeader>
 <detail>
  <band height="25" splitType="Stretch">
   <textField evaluationTime="Band" pattern="#,##0.00#">
    <reportElement isPrintRepeatedValues="false" mode="Transparent" x="150" y="0" width="150" height="25" uuid="4f6c11b5-d695-4ca7-b683-f1414599d9e2">
     <property name="local_mesure_unitx" value="pixel"/>
     <property name="com.jaspersoft.studio.unit.x" value="px"/>
     <property name="local_mesure_unitwidth" value="pixel"/>
     <property name="com.jaspersoft.studio.unit.width" value="px"/>
    </reportElement>
    <box>
     <pen lineWidth="0.5" lineStyle="Dotted"/>
     <topPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/>
     <leftPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/>
     <bottomPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/>
     <rightPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/>
    </box>
    <textElement textAlignment="Right" verticalAlignment="Middle">
     <font fontName="DejaVu Sans" size="12" isBold="false"/>
     <paragraph leftIndent="2"/>
    </textElement>
    <textFieldExpression><![CDATA[$F{COL_2}.intValue()== 0 ? "NA":$F{COL_2}]]></textFieldExpression>
   </textField>
   <textField pattern="#,##0.00#" isBlankWhenNull="true">
    <reportElement mode="Transparent" x="300" y="0" width="150" height="25" uuid="e8878ce3-5717-42fe-a165-f2c8711ab620">
     <property name="local_mesure_unitx" value="pixel"/>
     <property name="com.jaspersoft.studio.unit.x" value="px"/>
     <property name="local_mesure_unitwidth" value="pixel"/>
     <property name="com.jaspersoft.studio.unit.width" value="px"/>
     <property name="net.sf.jasperreports.export.xls.auto.fit.column" value="true"/>
    </reportElement>
    <box>
     <pen lineWidth="0.5"/>
     <topPen lineWidth="0.5"/>
     <leftPen lineWidth="0.5"/>
     <bottomPen lineWidth="0.5"/>
     <rightPen lineWidth="0.5"/>
    </box>
    <textElement textAlignment="Right" verticalAlignment="Middle">
     <font fontName="DejaVu Sans" size="12"/>
     <paragraph leftIndent="2"/>
    </textElement>
    <textFieldExpression><![CDATA[$F{COL_3}.intValue()== -0.00 ? "NA" : $F{COL_3}]]></textFieldExpression>
   </textField>
   <textField>
    <reportElement x="0" y="0" width="150" height="25" uuid="52c86562-da63-448b-b7b7-0ae622ae9fcf">
     <property name="local_mesure_unitwidth" value="pixel"/>
     <property name="com.jaspersoft.studio.unit.width" value="px"/>
    </reportElement>
    <box>
     <pen lineWidth="0.5"/>
     <topPen lineWidth="0.5"/>
     <leftPen lineWidth="0.5"/>
     <bottomPen lineWidth="0.5"/>
     <rightPen lineWidth="0.5"/>
    </box>
    <textElement textAlignment="Justified" verticalAlignment="Middle">
     <font fontName="DejaVu Sans" size="12"/>
     <paragraph leftIndent="2"/>
    </textElement>
    <textFieldExpression><![CDATA[$F{COL_1}]]></textFieldExpression>
   </textField>
   <textField pattern="#,##0.00#" isBlankWhenNull="true">
    <reportElement mode="Transparent" x="450" y="0" width="150" height="25" uuid="30391cfb-0c75-41ba-b674-889f9b0f1caa">
     <property name="local_mesure_unitx" value="pixel"/>
     <property name="com.jaspersoft.studio.unit.x" value="px"/>
     <property name="local_mesure_unitwidth" value="pixel"/>
     <property name="com.jaspersoft.studio.unit.width" value="px"/>
    </reportElement>
    <box>
     <pen lineWidth="0.5"/>
     <topPen lineWidth="0.5"/>
     <leftPen lineWidth="0.5"/>
     <bottomPen lineWidth="0.5"/>
     <rightPen lineWidth="0.5"/>
    </box>
    <textElement textAlignment="Right" verticalAlignment="Middle">
     <font fontName="DejaVu Sans" size="12"/>
     <paragraph rightIndent="2"/>
    </textElement>
    <textFieldExpression><![CDATA[$F{COL_4}.intValue() == -0.00 ? "NA" : $F{COL_4}]]></textFieldExpression>
   </textField>
   <textField pattern="#,##0.00#">
    <reportElement mode="Transparent" x="600" y="0" width="150" height="25" uuid="5e3162a1-d528-4377-8f78-f41148a00050">
     <property name="local_mesure_unitwidth" value="pixel"/>
     <property name="com.jaspersoft.studio.unit.width" value="px"/>
     <property name="com.jaspersoft.studio.unit.x" value="px"/>
    </reportElement>
    <box>
     <pen lineWidth="0.5"/>
     <topPen lineWidth="0.5"/>
     <leftPen lineWidth="0.5"/>
     <bottomPen lineWidth="0.5"/>
     <rightPen lineWidth="0.5"/>
    </box>
    <textElement textAlignment="Right" verticalAlignment="Middle">
     <font fontName="DejaVu Sans" size="12"/>
     <paragraph rightIndent="2"/>
    </textElement>
    <textFieldExpression><![CDATA[$F{COL_2}.intValue()== -0.00 ? "NA" : ($F{COL_3}.intValue()== -0.00 ? "NA" :($F{COL_2}-$F{COL_3}))]]></textFieldExpression>
   </textField>
   <textField pattern="#,##0.00%">
    <reportElement mode="Transparent" x="750" y="0" width="150" height="25" uuid="16ddacd3-5b34-4dea-8d97-f4ffef2b91db">
     <property name="local_mesure_unitx" value="pixel"/>
     <property name="com.jaspersoft.studio.unit.x" value="px"/>
     <property name="local_mesure_unitwidth" value="pixel"/>
     <property name="com.jaspersoft.studio.unit.width" value="px"/>
    </reportElement>
    <box>
     <pen lineWidth="0.5"/>
     <topPen lineWidth="0.5"/>
     <leftPen lineWidth="0.5"/>
     <bottomPen lineWidth="0.5"/>
     <rightPen lineWidth="0.5"/>
    </box>
    <textElement textAlignment="Right" verticalAlignment="Middle">
     <font fontName="DejaVu Sans" size="12"/>
     <paragraph rightIndent="2"/>
    </textElement>
    <textFieldExpression><![CDATA[$F{COL_2}.intValue() == -0.00 ? "NA" :($F{COL_3}.intValue() == -0.00 ? "NA":(($F{COL_2}-$F{COL_3})/$F{COL_3}))]]></textFieldExpression>
   </textField>
   <textField pattern="#,##0.00#">
    <reportElement mode="Transparent" x="900" y="0" width="150" height="25" uuid="1e445d46-ae63-4ecf-a9ef-00ed923cfd0a">
     <property name="com.jaspersoft.studio.unit.x" value="px"/>
     <property name="com.jaspersoft.studio.unit.width" value="px"/>
    </reportElement>
    <box>
     <pen lineWidth="0.5"/>
     <topPen lineWidth="0.5"/>
     <leftPen lineWidth="0.5"/>
     <bottomPen lineWidth="0.5"/>
     <rightPen lineWidth="0.5"/>
    </box>
    <textElement textAlignment="Right" verticalAlignment="Middle">
     <font fontName="DejaVu Sans" size="12"/>
     <paragraph rightIndent="2"/>
    </textElement>
    <textFieldExpression><![CDATA[$F{COL_2}.intValue() == -0.00 ? "NA":($F{COL_4}.intValue()== -0.00 ? "NA" :($F{COL_2}-$F{COL_4}))]]></textFieldExpression>
   </textField>
   <textField pattern="#,##0.00%">
    <reportElement mode="Transparent" x="1050" y="0" width="150" height="25" uuid="b8106dae-4304-43c9-9054-9b169ba16d7f"/>
    <box>
     <pen lineWidth="0.5"/>
     <topPen lineWidth="0.5"/>
     <leftPen lineWidth="0.5"/>
     <bottomPen lineWidth="0.5"/>
     <rightPen lineWidth="0.5"/>
    </box>
    <textElement textAlignment="Right" verticalAlignment="Middle">
     <font fontName="DejaVu Sans" size="12"/>
     <paragraph rightIndent="2"/>
    </textElement>
    <textFieldExpression><![CDATA[$F{COL_2}.intValue() == -0.00 ? "NA" : ($F{COL_4}.intValue() == -0.00 ? "NA" : (($F{COL_2}-$F{COL_4})/$F{COL_4}))]]></textFieldExpression>
   </textField>
  </band>
 </detail>
 <columnFooter>
  <band height="25"/>
 </columnFooter>
 <pageFooter>
  <band height="80" splitType="Stretch">
   <textField>
    <reportElement x="565" y="24" width="100" height="39" uuid="52e889ea-3e53-49eb-be47-6eb5c52f4289"/>
    <textElement textAlignment="Center" verticalAlignment="Middle">
     <font fontName="DejaVu Sans" size="12"/>
    </textElement>
    <textFieldExpression><![CDATA[$V{PAGE_NUMBER}]]></textFieldExpression>
   </textField>
   <staticText>
    <reportElement x="0" y="22" width="216" height="39" uuid="2b33cab1-ab15-4647-9730-6955c238c2ef">
     <property name="local_mesure_unitx" value="pixel"/>
     <property name="com.jaspersoft.studio.unit.x" value="px"/>
    </reportElement>
    <textElement verticalAlignment="Middle">
     <font fontName="DejaVu Sans" size="8"/>
    </textElement>
    <text><![CDATA[Confidential ]]></text>
   </staticText>
  </band>
 </pageFooter>
 <lastPageFooter>
  <band height="181">
   <staticText>
    <reportElement x="10" y="0" width="80" height="20" uuid="c51176fc-bc90-4db7-b902-68b9bb2d7320"/>
    <textElement verticalAlignment="Middle">
     <font fontName="DejaVu Sans" size="8" isUnderline="true"/>
    </textElement>
    <text><![CDATA[information]]></text>
   </staticText>
   <staticText>
    <reportElement x="1" y="170" width="216" height="10" uuid="f190a1cf-9c2e-4ebe-ab29-24dec7914bb4">
     <property name="local_mesure_unity" value="pixel"/>
     <property name="com.jaspersoft.studio.unit.y" value="px"/>
    </reportElement>
    <textElement verticalAlignment="Middle">
     <font fontName="DejaVu Sans" size="8"/>
    </textElement>
    <text><![CDATA[Confidential ]]></text>
   </staticText>
   <textField>
    <reportElement x="565" y="142" width="100" height="39" uuid="42918733-8b4c-40d0-9e57-9093fc9d4bf2">
     <property name="local_mesure_unity" value="pixel"/>
     <property name="com.jaspersoft.studio.unit.y" value="px"/>
    </reportElement>
    <textElement textAlignment="Center" verticalAlignment="Middle">
     <font fontName="DejaVu Sans" size="12"/>
    </textElement>
    <textFieldExpression><![CDATA[$V{PAGE_NUMBER}]]></textFieldExpression>
   </textField>
   <textField isStretchWithOverflow="true">
    <reportElement positionType="Float" stretchType="RelativeToTallestObject" x="10" y="52" width="518" height="11" uuid="75470fd0-67db-4961-a043-f28049be50d1">
     <property name="local_mesure_unity" value="pixel"/>
     <property name="com.jaspersoft.studio.unit.y" value="px"/>
    </reportElement>
    <textElement markup="none">
     <font fontName="DejaVu Sans" size="8"/>
    </textElement>
    <textFieldExpression><![CDATA["Sectors: "+$P{selectedParam3}]]></textFieldExpression>
   </textField>
   <textField>
    <reportElement x="10" y="28" width="518" height="11" uuid="55b91abc-78b0-466e-9a5a-ed05ba57e364">
     <property name="local_mesure_unity" value="pixel"/>
     <property name="com.jaspersoft.studio.unit.y" value="px"/>
    </reportElement>
    <textElement markup="none">
     <font fontName="DejaVu Sans" size="8"/>
    </textElement>
    <textFieldExpression><![CDATA["Parameter Creator: "+ $P{requesting_user_name}+"("+$P{report_owner_id}+")"]]></textFieldExpression>
   </textField>
   <textField isStretchWithOverflow="true">
    <reportElement positionType="Float" stretchType="RelativeToTallestObject" x="10" y="64" width="518" height="11" uuid="f96db12f-56cc-445f-a379-8474004d91ea">
     <property name="local_mesure_unity" value="pixel"/>
     <property name="com.jaspersoft.studio.unit.y" value="px"/>
    </reportElement>
    <textElement markup="none">
     <font fontName="DejaVu Sans" size="8"/>
    </textElement>
    <textFieldExpression><![CDATA["Business Line: "+$P{selectedParam4}]]></textFieldExpression>
   </textField>
   <textField>
    <reportElement x="10" y="40" width="518" height="11" uuid="b7af3f95-5773-4ae9-890e-ca9d4bf0bda8">
     <property name="local_mesure_unity" value="pixel"/>
     <property name="com.jaspersoft.studio.unit.y" value="px"/>
    </reportElement>
    <textElement markup="none">
     <font fontName="DejaVu Sans" size="8"/>
    </textElement>
    <textFieldExpression><![CDATA["Report Name: "+$P{OPTIONAL_OUTPUT_NAME}]]></textFieldExpression>
   </textField>
   <textField isStretchWithOverflow="true">
    <reportElement positionType="Float" stretchType="RelativeToTallestObject" x="10" y="76" width="518" height="11" uuid="94739b5a-4fe5-4a92-b6fc-6317a32d25e7">
     <property name="local_mesure_unity" value="pixel"/>
     <property name="com.jaspersoft.studio.unit.y" value="px"/>
    </reportElement>
    <textElement markup="none">
     <font fontName="DejaVu Sans" size="8"/>
    </textElement>
    <textFieldExpression><![CDATA["Reporting System: "+ $P{selectedParam1}]]></textFieldExpression>
   </textField>
   <textField>
    <reportElement positionType="Float" x="10" y="100" width="518" height="11" uuid="d89f6b92-c64f-4266-9ab3-2fc692a8290a"/>
    <textElement markup="none">
     <font fontName="DejaVu Sans" size="8"/>
    </textElement>
    <textFieldExpression><![CDATA["Report Generated By: "+ $P{requesting_user_name}+"("+$P{requesting_user_id}+")"]]></textFieldExpression>
   </textField>
   <textField>
    <reportElement positionType="Float" x="10" y="88" width="518" height="11" uuid="d23fd68d-158d-42b4-bd31-8a65f5fca77b">
     <property name="local_mesure_unitx" value="pixel"/>
     <property name="local_mesure_unity" value="pixel"/>
     <property name="com.jaspersoft.studio.unit.y" value="px"/>
    </reportElement>
    <textElement markup="none">
     <font fontName="DejaVu Sans" size="8"/>
    </textElement>
    <textFieldExpression><![CDATA["Reporting Period: "+$P{selectedParam2}]]></textFieldExpression>
   </textField>
  </band>
 </lastPageFooter>
 <summary>
  <band height="25" splitType="Stretch">
   <staticText>
    <reportElement mode="Transparent" x="0" y="0" width="150" height="25" backcolor="#FFFFFF" uuid="2ba839c0-1194-40aa-b56d-9a982d26d426">
     <property name="local_mesure_unitwidth" value="pixel"/>
     <property name="com.jaspersoft.studio.unit.width" value="px"/>
    </reportElement>
    <box>
     <pen lineWidth="0.75" lineColor="#333300"/>
     <topPen lineWidth="0.75" lineColor="#333300"/>
     <leftPen lineWidth="0.75" lineColor="#333300"/>
     <bottomPen lineWidth="0.75" lineColor="#333300"/>
     <rightPen lineWidth="0.75" lineColor="#333300"/>
    </box>
    <textElement verticalAlignment="Middle">
     <font fontName="DejaVu Sans" size="12" isBold="true"/>
    </textElement>
    <text><![CDATA[sector Total]]></text>
   </staticText>
   <textField pattern="$#,##0.00#;$-#,##0.00#">
    <reportElement mode="Transparent" x="150" y="0" width="150" height="25" forecolor="#000000" backcolor="#FFFFFF" uuid="dce41d35-7b66-406c-a84c-6978a1a6afec">
     <property name="local_mesure_unitx" value="pixel"/>
     <property name="com.jaspersoft.studio.unit.x" value="px"/>
     <property name="local_mesure_unitwidth" value="pixel"/>
     <property name="com.jaspersoft.studio.unit.width" value="px"/>
    </reportElement>
    <box padding="0" topPadding="0" leftPadding="0" bottomPadding="0" rightPadding="0">
     <pen lineWidth="0.75" lineColor="#333300"/>
     <topPen lineWidth="0.75" lineColor="#333300"/>
     <leftPen lineWidth="0.75" lineColor="#333300"/>
     <bottomPen lineWidth="0.75" lineColor="#333300"/>
     <rightPen lineWidth="0.75" lineColor="#333300"/>
    </box>
    <textElement textAlignment="Right" verticalAlignment="Middle" rotation="None" markup="none">
     <font fontName="DejaVu Sans" size="12" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfFontName="Helvetica" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
     <paragraph lineSpacing="Single" lineSpacingSize="1.0" firstLineIndent="0" leftIndent="0" rightIndent="0" spacingBefore="0" spacingAfter="0" tabStopWidth="40"/>
    </textElement>
    <textFieldExpression><![CDATA[$V{CURR}]]></textFieldExpression>
   </textField>
   <textField pattern="¤#,##0.00#;¤-#,##0.00#">
    <reportElement mode="Transparent" x="300" y="0" width="150" height="25" forecolor="#000000" backcolor="#FFFFFF" uuid="703d9516-3598-42cf-8c8b-2cbc97b6d73e">
     <property name="local_mesure_unitx" value="pixel"/>
     <property name="com.jaspersoft.studio.unit.x" value="px"/>
     <property name="local_mesure_unitwidth" value="pixel"/>
     <property name="com.jaspersoft.studio.unit.width" value="px"/>
     <property name="net.sf.jasperreports.export.xls.auto.fit.column" value="true"/>
    </reportElement>
    <box padding="0" topPadding="0" leftPadding="0" bottomPadding="0" rightPadding="0">
     <pen lineWidth="0.75" lineColor="#333300"/>
     <topPen lineWidth="0.75" lineColor="#333300"/>
     <leftPen lineWidth="0.75" lineColor="#333300"/>
     <bottomPen lineWidth="0.75" lineColor="#333300"/>
     <rightPen lineWidth="0.75" lineColor="#333300"/>
    </box>
    <textElement textAlignment="Right" verticalAlignment="Middle" rotation="None" markup="none">
     <font fontName="DejaVu Sans" size="12" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfFontName="Helvetica" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
     <paragraph lineSpacing="Single" lineSpacingSize="1.0" firstLineIndent="0" leftIndent="0" rightIndent="0" spacingBefore="0" spacingAfter="0" tabStopWidth="40"/>
    </textElement>
    <textFieldExpression><![CDATA[$V{PREV}]]></textFieldExpression>
   </textField>
   <textField pattern="¤#,##0.00#;¤-#,##0.00#">
    <reportElement mode="Transparent" x="450" y="0" width="150" height="25" forecolor="#000000" backcolor="#FFFFFF" uuid="e7e71e09-393b-4608-b6ce-041b3aecae01">
     <property name="local_mesure_unitx" value="pixel"/>
     <property name="com.jaspersoft.studio.unit.x" value="px"/>
     <property name="local_mesure_unitwidth" value="pixel"/>
     <property name="com.jaspersoft.studio.unit.width" value="px"/>
    </reportElement>
    <box padding="0" topPadding="0" leftPadding="0" bottomPadding="0" rightPadding="0">
     <pen lineWidth="0.75" lineColor="#333300"/>
     <topPen lineWidth="0.75" lineColor="#333300"/>
     <leftPen lineWidth="0.75" lineColor="#333300"/>
     <bottomPen lineWidth="0.75" lineColor="#333300"/>
     <rightPen lineWidth="0.75" lineColor="#333300"/>
    </box>
    <textElement textAlignment="Right" verticalAlignment="Middle" rotation="None" markup="none">
     <font fontName="DejaVu Sans" size="12" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfFontName="Helvetica" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
     <paragraph lineSpacing="Single" lineSpacingSize="1.0" firstLineIndent="0" leftIndent="0" rightIndent="0" spacingBefore="0" spacingAfter="0" tabStopWidth="40"/>
    </textElement>
    <textFieldExpression><![CDATA[$V{PREY}]]></textFieldExpression>
   </textField>
   <textField pattern="¤#,##0.00#;¤-#,##0.00#">
    <reportElement mode="Transparent" x="600" y="0" width="150" height="25" forecolor="#000000" backcolor="#FFFFFF" uuid="497c0d59-b57d-45da-b998-77cad696adc8">
     <property name="local_mesure_unitwidth" value="pixel"/>
     <property name="com.jaspersoft.studio.unit.width" value="px"/>
     <property name="local_mesure_unitx" value="pixel"/>
     <property name="com.jaspersoft.studio.unit.x" value="px"/>
    </reportElement>
    <box padding="0" topPadding="0" leftPadding="0" bottomPadding="0" rightPadding="0">
     <pen lineWidth="0.75" lineColor="#333300"/>
     <topPen lineWidth="0.75" lineColor="#333300"/>
     <leftPen lineWidth="0.75" lineColor="#333300"/>
     <bottomPen lineWidth="0.75" lineColor="#333300"/>
     <rightPen lineWidth="0.75" lineColor="#333300"/>
    </box>
    <textElement textAlignment="Right" verticalAlignment="Middle" rotation="None" markup="none">
     <font fontName="DejaVu Sans" size="12" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfFontName="Helvetica" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
     <paragraph lineSpacing="Single" lineSpacingSize="1.0" firstLineIndent="0" leftIndent="0" rightIndent="0" spacingBefore="0" spacingAfter="0" tabStopWidth="40"/>
    </textElement>
    <textFieldExpression><![CDATA[$V{QTO}]]></textFieldExpression>
   </textField>
   <textField pattern="#,##0.00%">
    <reportElement mode="Transparent" x="750" y="0" width="150" height="25" forecolor="#000000" backcolor="#FFFFFF" uuid="07c1eae0-8310-4817-a708-eae1aa0f740b">
     <property name="local_mesure_unitx" value="pixel"/>
     <property name="com.jaspersoft.studio.unit.x" value="px"/>
     <property name="local_mesure_unitwidth" value="pixel"/>
     <property name="com.jaspersoft.studio.unit.width" value="px"/>
    </reportElement>
    <box padding="0" topPadding="0" leftPadding="0" bottomPadding="0" rightPadding="0">
     <pen lineWidth="0.75" lineColor="#333300"/>
     <topPen lineWidth="0.75" lineColor="#333300"/>
     <leftPen lineWidth="0.75" lineColor="#333300"/>
     <bottomPen lineWidth="0.75" lineColor="#333300"/>
     <rightPen lineWidth="0.75" lineColor="#333300"/>
    </box>
    <textElement textAlignment="Right" verticalAlignment="Middle" rotation="None" markup="none">
     <font fontName="DejaVu Sans" size="12" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfFontName="Helvetica" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
     <paragraph lineSpacing="Single" lineSpacingSize="1.0" firstLineIndent="0" leftIndent="0" rightIndent="0" spacingBefore="0" spacingAfter="0" tabStopWidth="40"/>
    </textElement>
    <textFieldExpression><![CDATA[$V{QTO}.intValue()== -0.00 ? "NA" : ($V{PREV}.intValue() == -0.00 ? "NA" :(($V{QTO})/($V{PREV})))]]></textFieldExpression>
   </textField>
   <textField pattern="¤#,##0.00#;¤-#,##0.00#">
    <reportElement mode="Transparent" x="900" y="0" width="150" height="25" forecolor="#000000" backcolor="#FFFFFF" uuid="c9b21fc5-d439-49d6-8b16-33b7e5c0a261">
     <property name="local_mesure_unitx" value="pixel"/>
     <property name="com.jaspersoft.studio.unit.x" value="px"/>
     <property name="local_mesure_unitwidth" value="pixel"/>
     <property name="com.jaspersoft.studio.unit.width" value="px"/>
    </reportElement>
    <box padding="0" topPadding="0" leftPadding="0" bottomPadding="0" rightPadding="0">
     <pen lineWidth="0.75" lineColor="#333300"/>
     <topPen lineWidth="0.75" lineColor="#333300"/>
     <leftPen lineWidth="0.75" lineColor="#333300"/>
     <bottomPen lineWidth="0.75" lineColor="#333300"/>
     <rightPen lineWidth="0.75" lineColor="#333300"/>
    </box>
    <textElement textAlignment="Right" verticalAlignment="Middle" rotation="None" markup="none">
     <font fontName="DejaVu Sans" size="12" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfFontName="Helvetica" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
     <paragraph lineSpacing="Single" lineSpacingSize="1.0" firstLineIndent="0" leftIndent="0" rightIndent="0" spacingBefore="0" spacingAfter="0" tabStopWidth="40"/>
    </textElement>
    <textFieldExpression><![CDATA[$V{YO}]]></textFieldExpression>
   </textField>
   <textField pattern="#,##0.00%">
    <reportElement mode="Transparent" x="1050" y="0" width="150" height="25" forecolor="#000000" backcolor="#FFFFFF" uuid="f41969b4-1326-458b-8e82-bc9f32eddc0f"/>
    <box padding="0" topPadding="0" leftPadding="0" bottomPadding="0" rightPadding="0">
     <pen lineWidth="0.75" lineColor="#333300"/>
     <topPen lineWidth="0.75" lineColor="#333300"/>
     <leftPen lineWidth="0.75" lineColor="#333300"/>
     <bottomPen lineWidth="0.75" lineColor="#333300"/>
     <rightPen lineWidth="0.75" lineColor="#333300"/>
    </box>
    <textElement textAlignment="Right" verticalAlignment="Middle" rotation="None" markup="none">
     <font fontName="DejaVu Sans" size="12" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfFontName="Helvetica" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
     <paragraph lineSpacing="Single" lineSpacingSize="1.0" firstLineIndent="0" leftIndent="0" rightIndent="0" spacingBefore="0" spacingAfter="0" tabStopWidth="40"/>
    </textElement>
    <textFieldExpression><![CDATA[$V{YO}.intValue() == -0.00 ? "NA" :($V{PREY}.intValue()== -0.00 ? "NA" :(($V{YO})/($V{PREY})))]]></textFieldExpression>
   </textField>
  </band>
 </summary>
 <noData>
  <band height="50">
   <staticText>
    <reportElement x="550" y="10" width="150" height="30" uuid="a8c8c673-5910-4f4d-b6a0-5407aca685f5"/>
    <textElement textAlignment="Center" verticalAlignment="Middle">
     <font size="12" isBold="true"/>
    </textElement>
    <text><![CDATA[No Data Found!]]></text>
   </staticText>
  </band>
 </noData>
</jasperReport>
 

Link to comment
Share on other sites
hozawa Grand Master

hozawa

Posted
Posted

This is just a bug in your jrxml. Try deleting Page Header band, Page footer band, and Last Page footer band and generating a report.

You'll have to make text fields and static text fields align with fields in your detail band to make JasperReport not create new columns.

Link to comment
Share on other sites
chitra.elumalai Rookie

chitra.elumalai

Posted
  • Author
Posted

Thanks a lot. After running so many tweaks , finally I’ve made the excel export report output to happen successfully without cell merge.

These are the properties which resolved our  Excel Export Cell Merge issue  and these properties will be added in each of our jasper report template.

<property name="net.sf.jasperreports.export.xls.exclude.origin.band.1" value="pageHeader"/>

   <property name="net.sf.jasperreports.export.xls.exclude.origin.band.2" value="pageFooter"/>

  <property name="net.sf.jasperreports.export.xls.exclude.origin.band.3" value="lastPageFooter"/>

  <property name="net.sf.jasperreports.export.xls.ignore.cell.background" value="true"/>

  <property name="net.sf.jasperreports.export.xls.white.page.background" value="false"/>

    <property name="net.sf.jasperreports.export.xls.ignore.graphics" value="true"/>

     <property name="net.sf.jasperreports.export.xls.detect.cell.type=true"/>

    <property name="net.sf.jasperreports.export.xls.remove.empty.space.between.rows=true"/>

                <property name="net.sf.jasperreports.export.xls.remove.empty.space.between.columns=true"/>

                <property name="net.sf.jasperreports.export.xls.collapse.row.span" value="true"/>

                <property name="net.sf.jasperreports.export.xls.ignore.page.margins=true"/>

                <property name="net.sf.jasperreports.export.xls.one.page.per.sheet=true"/>

                <property name="net.sf.jasperreports.export.xls.wrap.text" value="true"/>

                <property name="net.sf.jasperreports.export.xls.column.width.ratio" value="1.10f"/>

                <property name="net.sf.jasperreports.export.xls.auto.fit.column" value="true"/>

 

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
 Share
Go to topic listing
×
×
  • Create New...

© 2024 Cloud Software Group,
Inc. All rights reserved.

Products

Explore