chitra.elumalai
-
Posts
8 -
Joined
-
Last visited
chitra.elumalai's Achievements
-
Kerning issue can be resoved by align left instead of justified. Please try
-
Thanks Javier. So the problem is because of the indices. Some data from csv file is showed up in the 1st sub report whereas the second sub report does not get the data. So it has to either read the csv file again and populate the data in the second sub report. Any help will be much appreciated.
-
Hi , I created a main report with 2 sub reports. For instance - Main report with Title (Static Text) Sub report 1 - (Column1,Column2,Column3) in title band of Main report Sub report 2 - (Title ,Column1,Column2 ... Column5 ) in the Detail band of Main Report The data source is csv datasource. I passed the parameter ($P{REPORT_DATA_SOURCE}) in the Data source expression for each sub reports. When previewed , i got the main report with the first subreport along with data. For Second sub report , i get only the title and not the data. Could anyone please advise ? P.S : I have not used any parameters to filter the data. Regards, Chitra
-
How to Unmerge Cells in Excel Export Jasper Report
chitra.elumalai replied to chitra.elumalai's topic in Products
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"/> -
How to Unmerge Cells in Excel Export Jasper Report
chitra.elumalai replied to chitra.elumalai's topic in Products
<?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> -
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?
