empty columns in excel file while export from jasper
<p>I am using jasper report 3.7.6. I have a list which i want to export to excel.I am able to export list into excel but there appears many hidden columns and rows in my excel.How to remove such hidden columns and rows?</p>

<p>My code is like this:</p>

<pre><code>JasperPrint jasperPrint;  

 JRBeanCollectionDataSource beanCollectionDataSource=new JRBeanCollectionDataSource(lstScoreSheet);  
 String  reportPath=  FacesContext.getCurrentInstance().getExternalContext().getRealPath("/reports/[![enter image description here][1]][1]ScoreSheet.jasper");       

    jasperPrint=JasperFillManager.fillReport(reportPath, getParameters(batchYr),beanCollectionDataSource);
     HttpServletResponse httpServletResponse1=(HttpServletResponse)FacesContext.getCurrentInstance().getExternalContext().getResponse();  
      httpServletResponse1.addHeader("Content-disposition", "attachment; filename=report.xls");  
       ServletOutputStream servletOutputStream=httpServletResponse1.getOutputStream();  

       JExcelApiExporter exporterXLS = new JExcelApiExporter();
       exporterXLS.setParameter(JRXlsExporterParameter.JASPER_PRINT, jasperPrint);
       exporterXLS.setParameter(JRXlsExporterParameter.OUTPUT_STREAM, servletOutputStream);
       exporterXLS.setParameter(JRXlsExporterParameter.IS_ONE_PAGE_PER_SHEET, Boolean.FALSE);
       exporterXLS.setParameter(JRXlsExporterParameter.IS_DETECT_CELL_TYPE, Boolean.TRUE);
       exporterXLS.setParameter(JRXlsExporterParameter.IS_WHITE_PAGE_BACKGROUND, Boolean.FALSE);
       exporterXLS.setParameter(JRXlsExporterParameter.IS_REMOVE_EMPTY_SPACE_BETWEEN_ROWS, Boolean.TRUE);
       exporterXLS.setParameter(JRXlsExporterParameter.IS_REMOVE_EMPTY_SPACE_BETWEEN_COLUMNS, Boolean.TRUE);
       exporterXLS.exportReport();
</code></pre>

<p>Image of excel file:
<a href="https://i.stack.imgur.com/39EpN.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/39EpN.jpg" alt="enter image description here"></a></p>

<p>Here Column A,C,E.... are all empty and hidden .I want to remove those hidden columns.</p>

<p>My jrxml code is:</p>

<pre><code>    &lt;?xml version="1.0" encoding="UTF-8"?&gt;
&lt;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="ScoreSheet" pageWidth="842" pageHeight="595" orientation="Landscape" columnWidth="802" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20"&gt;
    &lt;property name="ireport.zoom" value="3.897434200000008"/&gt;
    &lt;property name="ireport.x" value="2104"/&gt;
    &lt;property name="ireport.y" value="122"/&gt;
    &lt;property name="net.sf.jasperreports.export.xls.remove.empty.space.between.columns" value="true"/&gt;
    &lt;property name="net.sf.jasperreports.export.xls.column.width" value="100"/&gt;
    &lt;property name="net.sf.jasperreports.export.xls.remove.empty.space.between.rows" value="true"/&gt;
    &lt;property name="detectCellType" value="true"/&gt;
    &lt;property name="onePagePerSheet" value="false"/&gt;
    &lt;property name="whitePageBackground" value="false"/&gt;
    &lt;property name="ignoreGraphics" value="false"/&gt;
    &lt;property name="collapseRowSpan" value="true"/&gt;
    &lt;property name="ignoreCellBorder" value="true"/&gt;
    &lt;property name="fontSizeFixEnabled" value="true"/&gt;
    &lt;property name="maximumRowsPerSheet" value="0"/&gt;
    &lt;parameter name="batchYear" class="java.lang.String"/&gt;
    &lt;parameter name="date" class="java.lang.String"/&gt;
    &lt;queryString&gt;
        &lt;![CDATA[]]&gt;
    &lt;/queryString&gt;
    &lt;field name="advanceAccHT1" class="java.lang.String"&gt;
        &lt;fieldDescription&gt;&lt;![CDATA[advanceAccHT1]]&gt;&lt;/fieldDescription&gt;
    &lt;/field&gt;
    &lt;field name="financialHT2" class="java.lang.String"&gt;
        &lt;fieldDescription&gt;&lt;![CDATA[financialHT2]]&gt;&lt;/fieldDescription&gt;
    &lt;/field&gt;
    &lt;field name="sn" class="java.lang.Integer"&gt;
        &lt;fieldDescription&gt;&lt;![CDATA[sn]]&gt;&lt;/fieldDescription&gt;
    &lt;/field&gt;
    &lt;field name="financialPT1" class="java.lang.String"&gt;
        &lt;fieldDescription&gt;&lt;![CDATA[financialPT1]]&gt;&lt;/fieldDescription&gt;
    &lt;/field&gt;
    &lt;field name="remarks" class="java.lang.String"&gt;
        &lt;fieldDescription&gt;&lt;![CDATA[remarks]]&gt;&lt;/fieldDescription&gt;
    &lt;/field&gt;
    &lt;field name="advanceAccHT2" class="java.lang.String"&gt;
        &lt;fieldDescription&gt;&lt;![CDATA[advanceAccHT2]]&gt;&lt;/fieldDescription&gt;
    &lt;/field&gt;
    &lt;field name="auditHT2" class="java.lang.String"&gt;
        &lt;fieldDescription&gt;&lt;![CDATA[auditHT2]]&gt;&lt;/fieldDescription&gt;
    &lt;/field&gt;
    &lt;field name="advanceAccPT1" class="java.lang.String"&gt;
        &lt;fieldDescription&gt;&lt;![CDATA[advanceAccPT1]]&gt;&lt;/fieldDescription&gt;
    &lt;/field&gt;
    &lt;field name="bcPT1" class="java.lang.String"&gt;
        &lt;fieldDescription&gt;&lt;![CDATA[bcPT1]]&gt;&lt;/fieldDescription&gt;
    &lt;/field&gt;
    &lt;field name="financialHT1" class="java.lang.String"&gt;
        &lt;fieldDescription&gt;&lt;![CDATA[financialHT1]]&gt;&lt;/fieldDescription&gt;
    &lt;/field&gt;
    &lt;field name="incomeHT2" class="java.lang.String"&gt;
        &lt;fieldDescription&gt;&lt;![CDATA[incomeHT2]]&gt;&lt;/fieldDescription&gt;
    &lt;/field&gt;
    &lt;field name="marketingPT1" class="java.lang.String"&gt;
        &lt;fieldDescription&gt;&lt;![CDATA[marketingPT1]]&gt;&lt;/fieldDescription&gt;
    &lt;/field&gt;
    &lt;field name="costHT2" class="java.lang.String"&gt;
        &lt;fieldDescription&gt;&lt;![CDATA[costHT2]]&gt;&lt;/fieldDescription&gt;
    &lt;/field&gt;
    &lt;field name="auditPT1" class="java.lang.String"&gt;
        &lt;fieldDescription&gt;&lt;![CDATA[auditPT1]]&gt;&lt;/fieldDescription&gt;
    &lt;/field&gt;
    &lt;field name="corporateHT1" class="java.lang.String"&gt;
        &lt;fieldDescription&gt;&lt;![CDATA[corporateHT1]]&gt;&lt;/fieldDescription&gt;
    &lt;/field&gt;
    &lt;field name="corporateHT2" class="java.lang.String"&gt;
        &lt;fieldDescription&gt;&lt;![CDATA[corporateHT2]]&gt;&lt;/fieldDescription&gt;
    &lt;/field&gt;
    &lt;field name="corporatePT1" class="java.lang.String"&gt;
        &lt;fieldDescription&gt;&lt;![CDATA[corporatePT1]]&gt;&lt;/fieldDescription&gt;
    &lt;/field&gt;
    &lt;field name="bcHT" class="java.lang.String"&gt;
        &lt;fieldDescription&gt;&lt;![CDATA[bcHT]]&gt;&lt;/fieldDescription&gt;
    &lt;/field&gt;
    &lt;field name="regNo" class="java.lang.String"&gt;
        &lt;fieldDescription&gt;&lt;![CDATA[regNo]]&gt;&lt;/fieldDescription&gt;
    &lt;/field&gt;
    &lt;field name="studentName" class="java.lang.String"&gt;
        &lt;fieldDescription&gt;&lt;![CDATA[studentName]]&gt;&lt;/fieldDescription&gt;
    &lt;/field&gt;
    &lt;field name="costHT1" class="java.lang.String"&gt;
        &lt;fieldDescription&gt;&lt;![CDATA[costHT1]]&gt;&lt;/fieldDescription&gt;
    &lt;/field&gt;
    &lt;field name="incomePT1" class="java.lang.String"&gt;
        &lt;fieldDescription&gt;&lt;![CDATA[incomePT1]]&gt;&lt;/fieldDescription&gt;
    &lt;/field&gt;
    &lt;field name="costPT1" class="java.lang.String"&gt;
        &lt;fieldDescription&gt;&lt;![CDATA[costPT1]]&gt;&lt;/fieldDescription&gt;
    &lt;/field&gt;
    &lt;field name="incomeHT1" class="java.lang.String"&gt;
        &lt;fieldDescription&gt;&lt;![CDATA[incomeHT1]]&gt;&lt;/fieldDescription&gt;
    &lt;/field&gt;
    &lt;field name="marketingHT" class="java.lang.String"&gt;
        &lt;fieldDescription&gt;&lt;![CDATA[marketingHT]]&gt;&lt;/fieldDescription&gt;
    &lt;/field&gt;
    &lt;field name="auditHT1" class="java.lang.String"&gt;
        &lt;fieldDescription&gt;&lt;![CDATA[auditHT1]]&gt;&lt;/fieldDescription&gt;
    &lt;/field&gt;
    &lt;field name="advanceAccPT2" class="java.lang.String"&gt;
        &lt;fieldDescription&gt;&lt;![CDATA[advanceAccPT2]]&gt;&lt;/fieldDescription&gt;
    &lt;/field&gt;
    &lt;field name="auditPT2" class="java.lang.String"&gt;
        &lt;fieldDescription&gt;&lt;![CDATA[auditPT2]]&gt;&lt;/fieldDescription&gt;
    &lt;/field&gt;
    &lt;field name="corporatePT2" class="java.lang.String"&gt;
        &lt;fieldDescription&gt;&lt;![CDATA[corporatePT2]]&gt;&lt;/fieldDescription&gt;
    &lt;/field&gt;
    &lt;field name="financialPT2" class="java.lang.String"&gt;
        &lt;fieldDescription&gt;&lt;![CDATA[financialPT2]]&gt;&lt;/fieldDescription&gt;
    &lt;/field&gt;
    &lt;field name="costPT2" class="java.lang.String"&gt;
        &lt;fieldDescription&gt;&lt;![CDATA[costPT2]]&gt;&lt;/fieldDescription&gt;
    &lt;/field&gt;
    &lt;field name="bcPT2" class="java.lang.String"&gt;
        &lt;fieldDescription&gt;&lt;![CDATA[bcPT2]]&gt;&lt;/fieldDescription&gt;
    &lt;/field&gt;
    &lt;field name="marketingPT2" class="java.lang.String"&gt;
        &lt;fieldDescription&gt;&lt;![CDATA[marketingPT2]]&gt;&lt;/fieldDescription&gt;
    &lt;/field&gt;
    &lt;field name="incomePT2" class="java.lang.String"&gt;
        &lt;fieldDescription&gt;&lt;![CDATA[incomePT2]]&gt;&lt;/fieldDescription&gt;
    &lt;/field&gt;
    &lt;background&gt;
        &lt;band splitType="Stretch"/&gt;
    &lt;/background&gt;
    &lt;title&gt;
        &lt;band height="49"&gt;
            &lt;staticText&gt;
                &lt;reportElement x="262" y="0" width="273" height="16"/&gt;
                &lt;textElement textAlignment="Center"&gt;
                    &lt;font size="12" isBold="true"/&gt;
                &lt;/textElement&gt;
                &lt;text&gt;&lt;![CDATA[ABC School]]&gt;&lt;/text&gt;
            &lt;/staticText&gt;
            &lt;staticText&gt;
                &lt;reportElement x="364" y="30" width="71" height="17"/&gt;
                &lt;textElement textAlignment="Center"&gt;
                    &lt;font size="11" isBold="true"/&gt;
                &lt;/textElement&gt;

            &lt;/staticText&gt;
            &lt;staticText&gt;
                &lt;reportElement x="337" y="16" width="124" height="16"/&gt;
                &lt;textElement textAlignment="Center"&gt;
                    &lt;font size="12" isBold="true"/&gt;
                &lt;/textElement&gt;
                &lt;text&gt;&lt;![CDATA[Score Sheet]]&gt;&lt;/text&gt;
            &lt;/staticText&gt;
        &lt;/band&gt;
    &lt;/title&gt;
    &lt;detail&gt;
        &lt;band height="16" splitType="Stretch"&gt;
            &lt;textField isStretchWithOverflow="true" isBlankWhenNull="true"&gt;
                &lt;reportElement positionType="Float" stretchType="RelativeToTallestObject" x="0" y="0" width="19" height="16"/&gt;
                &lt;textElement textAlignment="Center" verticalAlignment="Middle"&gt;
                    &lt;font size="8"/&gt;
                &lt;/textElement&gt;
                &lt;textFieldExpression class="java.lang.Integer"&gt;&lt;![CDATA[$F{sn}==0?null:$F{sn}]]&gt;&lt;/textFieldExpression&gt;
            &lt;/textField&gt;
            &lt;textField isStretchWithOverflow="true" isBlankWhenNull="true"&gt;
                &lt;reportElement positionType="Float" stretchType="RelativeToTallestObject" x="18" y="0" width="119" height="16"/&gt;
                &lt;textElement textAlignment="Center" verticalAlignment="Middle"&gt;
                    &lt;font size="8"/&gt;
                &lt;/textElement&gt;
                &lt;textFieldExpression class="java.lang.String"&gt;&lt;![CDATA[$F{studentName}]]&gt;&lt;/textFieldExpression&gt;
            &lt;/textField&gt;
            &lt;textField isStretchWithOverflow="true" isBlankWhenNull="true"&gt;
                &lt;reportElement positionType="Float" stretchType="RelativeToTallestObject" x="136" y="0" width="49" height="16"/&gt;
                &lt;textElement textAlignment="Center" verticalAlignment="Middle"&gt;
                    &lt;font size="8"/&gt;
                &lt;/textElement&gt;
                &lt;textFieldExpression class="java.lang.String"&gt;&lt;![CDATA[$F{regNo}]]&gt;&lt;/textFieldExpression&gt;
            &lt;/textField&gt;
            &lt;textField isStretchWithOverflow="true" isBlankWhenNull="true"&gt;
                &lt;reportElement positionType="Float" stretchType="RelativeToTallestObject" x="184" y="0" width="17" height="16"/&gt;
                &lt;textElement textAlignment="Center" verticalAlignment="Middle"&gt;
                    &lt;font size="8"/&gt;
                &lt;/textElement&gt;
                &lt;textFieldExpression class="java.lang.String"&gt;&lt;![CDATA[$F{advanceAccHT1}]]&gt;&lt;/textFieldExpression&gt;
            &lt;/textField&gt;
            &lt;textField isStretchWithOverflow="true" isBlankWhenNull="true"&gt;
                &lt;reportElement positionType="Float" stretchType="RelativeToTallestObject" x="200" y="0" width="18" height="16"/&gt;
                &lt;textElement textAlignment="Center" verticalAlignment="Middle"&gt;
                    &lt;font size="8"/&gt;
                &lt;/textElement&gt;
                &lt;textFieldExpression class="java.lang.String"&gt;&lt;![CDATA[$F{advanceAccHT2}]]&gt;&lt;/textFieldExpression&gt;
            &lt;/textField&gt;
            &lt;textField isStretchWithOverflow="true" isBlankWhenNull="true"&gt;
                &lt;reportElement positionType="Float" stretchType="RelativeToTallestObject" x="217" y="0" width="18" height="16"/&gt;
                &lt;textElement textAlignment="Center" verticalAlignment="Middle"&gt;
                    &lt;font size="8"/&gt;
                &lt;/textElement&gt;
                &lt;textFieldExpression class="java.lang.String"&gt;&lt;![CDATA[$F{advanceAccPT1}]]&gt;&lt;/textFieldExpression&gt;
            &lt;/textField&gt;
            &lt;textField isStretchWithOverflow="true" isBlankWhenNull="true"&gt;
                &lt;reportElement positionType="Float" stretchType="RelativeToTallestObject" x="717" y="0" width="85" height="16"/&gt;
                &lt;textElement textAlignment="Center" verticalAlignment="Middle"&gt;
                    &lt;font size="9"/&gt;
                &lt;/textElement&gt;
                &lt;textFieldExpression class="java.lang.String"&gt;&lt;![CDATA[$F{remarks}]]&gt;&lt;/textFieldExpression&gt;
            &lt;/textField&gt;
            &lt;textField isStretchWithOverflow="true" isBlankWhenNull="true"&gt;
                &lt;reportElement positionType="Float" stretchType="RelativeToTallestObject" x="234" y="0" width="18" height="16"/&gt;
                &lt;textElement textAlignment="Center" verticalAlignment="Middle"&gt;
                    &lt;font size="8"/&gt;
                &lt;/textElement&gt;
                &lt;textFieldExpression class="java.lang.String"&gt;&lt;![CDATA[$F{advanceAccPT2}]]&gt;&lt;/textFieldExpression&gt;
            &lt;/textField&gt;
            &lt;textField isStretchWithOverflow="true" isBlankWhenNull="true"&gt;
                &lt;reportElement positionType="Float" stretchType="RelativeToTallestObject" x="251" y="0" width="17" height="16"/&gt;
                &lt;textElement textAlignment="Center" verticalAlignment="Middle"&gt;
                    &lt;font size="8"/&gt;
                &lt;/textElement&gt;
                &lt;textFieldExpression class="java.lang.String"&gt;&lt;![CDATA[$F{auditHT1}]]&gt;&lt;/textFieldExpression&gt;
            &lt;/textField&gt;
            &lt;textField isStretchWithOverflow="true" isBlankWhenNull="true"&gt;
                &lt;reportElement positionType="Float" stretchType="RelativeToTallestObject" x="268" y="0" width="17" height="16"/&gt;
                &lt;textElement textAlignment="Center" verticalAlignment="Middle"&gt;
                    &lt;font size="8"/&gt;
                &lt;/textElement&gt;
                &lt;textFieldExpression class="java.lang.String"&gt;&lt;![CDATA[$F{auditHT2}]]&gt;&lt;/textFieldExpression&gt;
            &lt;/textField&gt;
            &lt;textField isStretchWithOverflow="true" isBlankWhenNull="true"&gt;
                &lt;reportElement positionType="Float" stretchType="RelativeToTallestObject" x="284" y="0" width="17" height="16"/&gt;
                &lt;textElement textAlignment="Center" verticalAlignment="Middle"&gt;
                    &lt;font size="8"/&gt;
                &lt;/textElement&gt;
                &lt;textFieldExpression class="java.lang.String"&gt;&lt;![CDATA[$F{auditPT1}]]&gt;&lt;/textFieldExpression&gt;
            &lt;/textField&gt;
            &lt;textField isStretchWithOverflow="true" isBlankWhenNull="true"&gt;
                &lt;reportElement positionType="Float" stretchType="RelativeToTallestObject" x="300" y="0" width="17" height="16"/&gt;
                &lt;textElement textAlignment="Center" verticalAlignment="Middle"&gt;
                    &lt;font size="8"/&gt;
                &lt;/textElement&gt;
                &lt;textFieldExpression class="java.lang.String"&gt;&lt;![CDATA[$F{auditPT2}]]&gt;&lt;/textFieldExpression&gt;
            &lt;/textField&gt;
            &lt;textField isStretchWithOverflow="true" isBlankWhenNull="true"&gt;
                &lt;reportElement positionType="Float" stretchType="RelativeToTallestObject" x="316" y="0" width="17" height="16"/&gt;
                &lt;textElement textAlignment="Center" verticalAlignment="Middle"&gt;
                    &lt;font size="8"/&gt;
                &lt;/textElement&gt;
                &lt;textFieldExpression class="java.lang.String"&gt;&lt;![CDATA[$F{corporateHT1}]]&gt;&lt;/textFieldExpression&gt;
            &lt;/textField&gt;
            &lt;textField isStretchWithOverflow="true" isBlankWhenNull="true"&gt;
                &lt;reportElement positionType="Float" stretchType="RelativeToTallestObject" x="333" y="0" width="18" height="16"/&gt;
                &lt;textElement textAlignment="Center" verticalAlignment="Middle"&gt;
                    &lt;font size="8"/&gt;
                &lt;/textElement&gt;
                &lt;textFieldExpression class="java.lang.String"&gt;&lt;![CDATA[$F{corporateHT2}]]&gt;&lt;/textFieldExpression&gt;
            &lt;/textField&gt;
            &lt;textField isStretchWithOverflow="true" isBlankWhenNull="true"&gt;
                &lt;reportElement positionType="Float" stretchType="RelativeToTallestObject" x="350" y="0" width="18" height="16"/&gt;
                &lt;textElement textAlignment="Center" verticalAlignment="Middle"&gt;
                    &lt;font size="8"/&gt;
                &lt;/textElement&gt;
                &lt;textFieldExpression class="java.lang.String"&gt;&lt;![CDATA[$F{corporatePT1}]]&gt;&lt;/textFieldExpression&gt;
            &lt;/textField&gt;
            &lt;textField isStretchWithOverflow="true" isBlankWhenNull="true"&gt;
                &lt;reportElement positionType="Float" stretchType="RelativeToTallestObject" x="367" y="0" width="20" height="16"/&gt;
                &lt;textElement textAlignment="Center" verticalAlignment="Middle"&gt;
                    &lt;font size="8"/&gt;
                &lt;/textElement&gt;
                &lt;textFieldExpression class="java.lang.String"&gt;&lt;![CDATA[$F{corporatePT2}]]&gt;&lt;/textFieldExpression&gt;
            &lt;/textField&gt;
            &lt;textField isStretchWithOverflow="true" isBlankWhenNull="true"&gt;
                &lt;reportElement positionType="Float" stretchType="RelativeToTallestObject" x="386" y="0" width="18" height="16"/&gt;
                &lt;textElement textAlignment="Center" verticalAlignment="Middle"&gt;
                    &lt;font size="8"/&gt;
                &lt;/textElement&gt;
                &lt;textFieldExpression class="java.lang.String"&gt;&lt;![CDATA[$F{financialHT1}]]&gt;&lt;/textFieldExpression&gt;
            &lt;/textField&gt;
            &lt;textField isStretchWithOverflow="true" isBlankWhenNull="true"&gt;
                &lt;reportElement positionType="Float" stretchType="RelativeToTallestObject" x="403" y="0" width="18" height="16"/&gt;
                &lt;textElement textAlignment="Center" verticalAlignment="Middle"&gt;
                    &lt;font size="8"/&gt;
                &lt;/textElement&gt;
                &lt;textFieldExpression class="java.lang.String"&gt;&lt;![CDATA[$F{financialHT2}]]&gt;&lt;/textFieldExpression&gt;
            &lt;/textField&gt;
            &lt;textField isStretchWithOverflow="true" isBlankWhenNull="true"&gt;
                &lt;reportElement positionType="Float" stretchType="RelativeToTallestObject" x="420" y="0" width="19" height="16"/&gt;
                &lt;textElement textAlignment="Center" verticalAlignment="Middle"&gt;
                    &lt;font size="8"/&gt;
                &lt;/textElement&gt;
                &lt;textFieldExpression class="java.lang.String"&gt;&lt;![CDATA[$F{financialPT1}]]&gt;&lt;/textFieldExpression&gt;
            &lt;/textField&gt;
            &lt;textField isStretchWithOverflow="true" isBlankWhenNull="true"&gt;
                &lt;reportElement positionType="Float" stretchType="RelativeToTallestObject" x="438" y="0" width="21" height="16"/&gt;
                &lt;textElement textAlignment="Center" verticalAlignment="Middle"&gt;
                    &lt;font size="8"/&gt;
                &lt;/textElement&gt;
                &lt;textFieldExpression class="java.lang.String"&gt;&lt;![CDATA[$F{financialPT2}]]&gt;&lt;/textFieldExpression&gt;
            &lt;/textField&gt;
            &lt;textField isStretchWithOverflow="true" isBlankWhenNull="true"&gt;
                &lt;reportElement positionType="Float" stretchType="RelativeToTallestObject" x="458" y="0" width="18" height="16"/&gt;
                &lt;textElement textAlignment="Center" verticalAlignment="Middle"&gt;
                    &lt;font size="8"/&gt;
                &lt;/textElement&gt;
                &lt;textFieldExpression class="java.lang.String"&gt;&lt;![CDATA[$F{costHT1}]]&gt;&lt;/textFieldExpression&gt;
            &lt;/textField&gt;
            &lt;textField isStretchWithOverflow="true" isBlankWhenNull="true"&gt;
                &lt;reportElement positionType="Float" stretchType="RelativeToTallestObject" x="475" y="0" width="19" height="16"/&gt;
                &lt;textElement textAlignment="Center" verticalAlignment="Middle"&gt;
                    &lt;font size="8"/&gt;
                &lt;/textElement&gt;
                &lt;textFieldExpression class="java.lang.String"&gt;&lt;![CDATA[$F{costHT2}]]&gt;&lt;/textFieldExpression&gt;
            &lt;/textField&gt;
            &lt;textField isStretchWithOverflow="true" isBlankWhenNull="true"&gt;
                &lt;reportElement positionType="Float" stretchType="RelativeToTallestObject" x="493" y="0" width="19" height="16"/&gt;
                &lt;textElement textAlignment="Center" verticalAlignment="Middle"&gt;
                    &lt;font size="8"/&gt;
                &lt;/textElement&gt;
                &lt;textFieldExpression class="java.lang.String"&gt;&lt;![CDATA[$F{costPT1}]]&gt;&lt;/textFieldExpression&gt;
            &lt;/textField&gt;
            &lt;textField isStretchWithOverflow="true" isBlankWhenNull="true"&gt;
                &lt;reportElement positionType="Float" stretchType="RelativeToTallestObject" x="511" y="0" width="23" height="16"/&gt;
                &lt;textElement textAlignment="Center" verticalAlignment="Middle"&gt;
                    &lt;font size="8"/&gt;
                &lt;/textElement&gt;
                &lt;textFieldExpression class="java.lang.String"&gt;&lt;![CDATA[$F{costPT2}]]&gt;&lt;/textFieldExpression&gt;
            &lt;/textField&gt;
            &lt;textField isStretchWithOverflow="true" isBlankWhenNull="true"&gt;
                &lt;reportElement positionType="Float" stretchType="RelativeToTallestObject" x="533" y="0" width="21" height="16"/&gt;
                &lt;textElement textAlignment="Center" verticalAlignment="Middle"&gt;
                    &lt;font size="8"/&gt;
                &lt;/textElement&gt;
                &lt;textFieldExpression class="java.lang.String"&gt;&lt;![CDATA[$F{bcHT}]]&gt;&lt;/textFieldExpression&gt;
            &lt;/textField&gt;
            &lt;textField isStretchWithOverflow="true" isBlankWhenNull="true"&gt;
                &lt;reportElement positionType="Float" stretchType="RelativeToTallestObject" x="553" y="0" width="21" height="16"/&gt;
                &lt;textElement textAlignment="Center" verticalAlignment="Middle"&gt;
                    &lt;font size="8"/&gt;
                &lt;/textElement&gt;
                &lt;textFieldExpression class="java.lang.String"&gt;&lt;![CDATA[$F{bcPT1}]]&gt;&lt;/textFieldExpression&gt;
            &lt;/textField&gt;
            &lt;textField isStretchWithOverflow="true" isBlankWhenNull="true"&gt;
                &lt;reportElement positionType="Float" stretchType="RelativeToTallestObject" x="573" y="0" width="22" height="16"/&gt;
                &lt;textElement textAlignment="Center" verticalAlignment="Middle"&gt;
                    &lt;font size="8"/&gt;
                &lt;/textElement&gt;
                &lt;textFieldExpression class="java.lang.String"&gt;&lt;![CDATA[$F{bcPT2}]]&gt;&lt;/textFieldExpression&gt;
            &lt;/textField&gt;
            &lt;textField isStretchWithOverflow="true" isBlankWhenNull="true"&gt;
                &lt;reportElement positionType="Float" stretchType="RelativeToTallestObject" x="594" y="0" width="20" height="16"/&gt;
                &lt;textElement textAlignment="Center" verticalAlignment="Middle"&gt;
                    &lt;font size="8"/&gt;
                &lt;/textElement&gt;
                &lt;textFieldExpression class="java.lang.String"&gt;&lt;![CDATA[$F{marketingHT}]]&gt;&lt;/textFieldExpression&gt;
            &lt;/textField&gt;
            &lt;textField isStretchWithOverflow="true" isBlankWhenNull="true"&gt;
                &lt;reportElement positionType="Float" stretchType="RelativeToTallestObject" x="613" y="0" width="20" height="16"/&gt;
                &lt;textElement textAlignment="Center" verticalAlignment="Middle"&gt;
                    &lt;font size="8"/&gt;
                &lt;/textElement&gt;
                &lt;textFieldExpression class="java.lang.String"&gt;&lt;![CDATA[$F{marketingPT1}]]&gt;&lt;/textFieldExpression&gt;
            &lt;/textField&gt;
            &lt;textField isStretchWithOverflow="true" isBlankWhenNull="true"&gt;
                &lt;reportElement positionType="Float" stretchType="RelativeToTallestObject" x="700" y="0" width="18" height="16"/&gt;
                &lt;textElement textAlignment="Center" verticalAlignment="Middle"&gt;
                    &lt;font size="8"/&gt;
                &lt;/textElement&gt;
                &lt;textFieldExpression class="java.lang.String"&gt;&lt;![CDATA[$F{incomePT2}]]&gt;&lt;/textFieldExpression&gt;
            &lt;/textField&gt;
            &lt;textField isStretchWithOverflow="true" isBlankWhenNull="true"&gt;
                &lt;reportElement positionType="Float" stretchType="RelativeToTallestObject" x="683" y="0" width="18" height="16"/&gt;
                &lt;textElement textAlignment="Center" verticalAlignment="Middle"&gt;
                    &lt;font size="8"/&gt;
                &lt;/textElement&gt;
                &lt;textFieldExpression class="java.lang.String"&gt;&lt;![CDATA[$F{incomePT1}]]&gt;&lt;/textFieldExpression&gt;
            &lt;/textField&gt;
            &lt;textField isStretchWithOverflow="true" isBlankWhenNull="true"&gt;
                &lt;reportElement positionType="Float" stretchType="RelativeToTallestObject" x="666" y="0" width="18" height="16"/&gt;
                &lt;textElement textAlignment="Center" verticalAlignment="Middle"&gt;
                    &lt;font size="8"/&gt;
                &lt;/textElement&gt;
                &lt;textFieldExpression class="java.lang.String"&gt;&lt;![CDATA[$F{incomeHT2}]]&gt;&lt;/textFieldExpression&gt;
            &lt;/textField&gt;
            &lt;textField isStretchWithOverflow="true" isBlankWhenNull="true"&gt;
                &lt;reportElement positionType="Float" stretchType="RelativeToTallestObject" x="632" y="0" width="19" height="16"/&gt;
                &lt;textElement textAlignment="Center" verticalAlignment="Middle"&gt;
                    &lt;font size="8"/&gt;
                &lt;/textElement&gt;
                &lt;textFieldExpression class="java.lang.String"&gt;&lt;![CDATA[$F{marketingPT2}]]&gt;&lt;/textFieldExpression&gt;
            &lt;/textField&gt;
            &lt;textField isStretchWithOverflow="true" isBlankWhenNull="true"&gt;
                &lt;reportElement positionType="Float" stretchType="RelativeToTallestObject" x="650" y="0" width="17" height="16"/&gt;
                &lt;textElement textAlignment="Center" verticalAlignment="Middle"&gt;
                    &lt;font size="8"/&gt;
                &lt;/textElement&gt;
                &lt;textFieldExpression class="java.lang.String"&gt;&lt;![CDATA[$F{incomeHT1}]]&gt;&lt;/textFieldExpression&gt;
            &lt;/textField&gt;
        &lt;/band&gt;
    &lt;/detail&gt;
&lt;/jasperReport&gt;
</code></pre>

<p>My jasper image :<a href="https://i.stack.imgur.com/5D8VP.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/5D8VP.jpg" alt="enter image description here"></a></p>

<p><em>UPDATED</em>.</p>

<p><em>New question:</em></p>

<p>My row overlap problem
<a href="https://i.stack.imgur.com/UwBWz.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/UwBWz.jpg" alt="enter image description here"></a></p>