Handle extra space between row

[aeslleny_1]

HI all, we find there is extra space between row and we have tried lots of method including "isPrintWhenDetailOverflows" or increasing padding but still no luck.

Below is the report look likes now :

Below is the report we want to have :

And here is the XML of our report :

<?xml version="1.0" encoding="UTF-8"?>

<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="ApplicationSummaryReport_OEARPg" language="groovy" pageWidth="554" pageHeight="842" columnWidth="554" leftMargin="0" rightMargin="0" topMargin="0" bottomMargin="0">

<property name="ireport.zoom" value="2.0490403660952117"/>

<property name="ireport.x" value="0"/>

<property name="ireport.y" value="0"/>

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

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

<field name="majorResponsibility" class="java.lang.String">

<fieldDescription><![CDATA[majorResponsibility]]></fieldDescription>

</field>

<background>

<band splitType="Stretch"/>

</background>

<detail>

<band height="10" splitType="Immediate">

<staticText>

<reportElement x="275" y="0" width="100" height="10" isPrintWhenDetailOverflows="true"/>

<box leftPadding="0">

<leftPen lineWidth="0.0"/>

<bottomPen lineWidth="0.0"/>

</box>

<textElement>

<font size="7" isBold="true" pdfFontName="Helvetica" pdfEncoding="Cp1252"/>

</textElement>

<text><![CDATA[Major Responsibilities]]></text>

</staticText>

<textField isStretchWithOverflow="true" evaluationTime="Auto" isBlankWhenNull="true">

<reportElement stretchType="RelativeToBandHeight" x="375" y="0" width="179" height="10" isPrintWhenDetailOverflows="true"/>

<box topPadding="0" bottomPadding="0">

<bottomPen lineWidth="0.0"/>

<rightPen lineWidth="0.75"/>

</box>

<textElement verticalAlignment="Top">

<font size="7" pdfFontName="Helvetica" pdfEncoding="Cp1252"/>

</textElement>

<textFieldExpression class="java.lang.String"><![CDATA[$F{majorResponsibility}.trim()]]></textFieldExpression>

</textField>

</band>

<band height="14" splitType="Immediate">

<staticText>

<reportElement stretchType="RelativeToTallestObject" x="275" y="0" width="100" height="10" isPrintWhenDetailOverflows="true"/>

<box>

<bottomPen lineWidth="0.0"/>

</box>

<textElement>

<font size="7" isBold="true"/>

</textElement>

<text><![CDATA[Modify User/Date]]></text>

</staticText>

<staticText>

<reportElement stretchType="RelativeToTallestObject" x="375" y="0" width="179" height="10" isPrintWhenDetailOverflows="true"/>

<textElement markup="none">

<font size="7"/>

</textElement>

<text><![CDATA[user]]></text>

</staticText>

</band>

</detail>

</jasperReport>

 

 

 

We are using Jasper report version 3.7.5 .Appreciate for any advise. Thank you

[hozawa]

Sorry but the version you're using is outdated and I don't know if the feature I know is supported in that version.

I would just group by majorResponsibilty and print users in the detail band.
 

Also, don't know if your version supports it or not but have you tried checking "Remove Line When Blank"?

FYI, I'm using Jaspersoft Studio 6.4.0

[aeslleny_1]

Dear Hozawa,

Thanks for your advise, but grouping them in a single detail band and checking "Remove Line When Blank" did not help. Any other advise ?