Gap Placed Between Bands

0

I am using Jaspersoft Studio v6.0.1.

I have a band with 2 columns.  The 1st has static data, the second has a single table that populates based on a query.

When I return multiple rows in the table in the 2nd column it adds an additional space between that band and the next band.  When I return only one column the space does not appear between that band and the next band.

Can anyone tell me why these gaps appear and how to resolve?  I have attached a screenshot of the layout, preview with multiple rows & gap, preview with single row & no gap, and the jrxml before modifying the query to return only 1 row.

Pic of gap preview: http://tinypic.com/r/bg4psh/8

Pic of layout:  http://tinypic.com/r/2469x8j/8

Pic of preview with no gap after returning single row: http://tinypic.com/r/2s1lt78/8

Source:

<?xml version="1.0" encoding="UTF-8"?>
<!-- Created with Jaspersoft Studio version 6.0.1.final using JasperReports Library version 6.0.0  -->
<!-- 2015-04-22T22:22:15 -->
 
<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="v1"
              pageWidth="595"
              pageHeight="842"
              columnWidth="555"
              leftMargin="20"
              rightMargin="20"
              topMargin="20"
              bottomMargin="20"
              uuid="8cdad2ee-eb03-420d-a186-a369365e75d9">
    <property name="com.jaspersoft.studio.data.defaultdataadapter"
              value="ZDWAdapter2"/>
    <style name="Table_TH" mode="Opaque" backcolor="#F0F8FF">
        <box>
            <topPen    lineWidth="0.5" lineColor="#000000"/>
            <bottomPen lineWidth="0.5" lineColor="#000000"/>
        </box>
    </style>
    <style name="Table_CH" mode="Opaque" backcolor="#BFE1FF">
        <box>
            <topPen    lineWidth="0.5" lineColor="#000000"/>
            <bottomPen lineWidth="0.5" lineColor="#000000"/>
        </box>
    </style>
    <style name="Table_TD" mode="Opaque" backcolor="#FFFFFF">
        <box>
            <topPen    lineWidth="0.5" lineColor="#000000"/>
            <bottomPen lineWidth="0.5" lineColor="#000000"/>
        </box>
    </style>
    <style name="Table 1_TH" mode="Opaque" backcolor="#FAFBFD">
        <box>
            <topPen    lineWidth="0.5" lineColor="#CCC8C8"/>
            <bottomPen lineWidth="0.5" lineColor="#CCC8C8"/>
        </box>
    </style>
    <style name="Table 1_CH" mode="Opaque" backcolor="#BFE1FF">
        <box>
            <topPen    lineWidth="0.5" lineColor="#CCC8C8"/>
            <bottomPen lineWidth="0.5" lineColor="#CCC8C8"/>
        </box>
    </style>
    <style name="Table 1_TD" mode="Opaque" backcolor="#F7F7F7">
        <box>
            <topPen    lineWidth="0.5" lineColor="#CCC8C8"/>
            <bottomPen lineWidth="0.5" lineColor="#CCC8C8"/>
        </box>
    </style>
    <style name="Table 2_TH" mode="Opaque" backcolor="#F0F8FF">
        <box>
            <topPen    lineWidth="0.5" lineColor="#000000"/>
            <bottomPen lineWidth="0.5" lineColor="#000000"/>
        </box>
    </style>
    <style name="Table 3_TH" mode="Opaque" backcolor="#F0F8FF">
        <box>
            <topPen    lineWidth="0.5" lineColor="#000000"/>
            <bottomPen lineWidth="0.5" lineColor="#000000"/>
        </box>
    </style>
    <style name="Table 2_CH" mode="Opaque" backcolor="#F6F8FB">
        <box>
            <topPen    lineWidth="0.5" lineColor="#000000"/>
            <bottomPen lineWidth="0.5" lineColor="#000000"/>
        </box>
    </style>
    <style name="Table 2_TD" mode="Opaque" backcolor="#FFFFFF">
        <box>
            <topPen    lineWidth="0.5" lineColor="#000000"/>
            <bottomPen lineWidth="0.5" lineColor="#000000"/>
        </box>
        <conditionalStyle>
            <conditionExpression>
                <![CDATA[new Boolean($V{REPORT_COUNT}.intValue()%2==0)]]>
            </conditionExpression>
            <style backcolor="#F5F5F5"/>
        </conditionalStyle>
    </style>
    <style name="Table 4_TH" mode="Opaque" backcolor="#F6F8FB">
        <box>
            <topPen    lineWidth="0.5" lineColor="#000000"/>
            <bottomPen lineWidth="0.5" lineColor="#000000"/>
        </box>
    </style>
    <style name="Table 4_CH" mode="Opaque" backcolor="#F6F8FB">
        <box>
            <topPen    lineWidth="0.5" lineColor="#000000"/>
            <bottomPen lineWidth="0.5" lineColor="#000000"/>
        </box>
    </style>
    <style name="Table 4_TD" mode="Opaque" backcolor="#FFFFFF">
        <box>
            <topPen    lineWidth="0.5" lineColor="#000000"/>
            <bottomPen lineWidth="0.5" lineColor="#000000"/>
        </box>
    </style>
    <style name="Table 5_TH" mode="Opaque" backcolor="#F0F8FF">
        <box>
            <topPen    lineWidth="0.5" lineColor="#000000"/>
            <bottomPen lineWidth="0.5" lineColor="#000000"/>
        </box>
    </style>
    <style name="Table 5_CH" mode="Opaque" backcolor="#F6F8FB">
        <box>
            <topPen    lineWidth="0.5" lineColor="#000000"/>
            <bottomPen lineWidth="0.5" lineColor="#000000"/>
        </box>
    </style>
    <style name="Table 5_TD" mode="Opaque" backcolor="#FFFFFF">
        <box>
            <topPen    lineWidth="0.5" lineColor="#000000"/>
            <bottomPen lineWidth="0.5" lineColor="#000000"/>
        </box>
        <conditionalStyle>
            <conditionExpression>
                <![CDATA[new Boolean($V{REPORT_COUNT}.intValue()%2==0)]]>
            </conditionExpression>
            <style backcolor="#F5F5F5"/>
        </conditionalStyle>
    </style>
    <style name="Table 6_TH" mode="Opaque" backcolor="#F6F8FB">
        <box>
            <topPen    lineWidth="0.5" lineColor="#000000"/>
            <bottomPen lineWidth="0.5" lineColor="#000000"/>
        </box>
    </style>
    <style name="Table 6_CH" mode="Opaque" backcolor="#BFE1FF">
        <box>
            <topPen    lineWidth="0.5" lineColor="#000000"/>
            <bottomPen lineWidth="0.5" lineColor="#000000"/>
        </box>
    </style>
    <style name="Table 6_TD" mode="Opaque" backcolor="#FFFFFF">
        <box>
            <topPen    lineWidth="0.5" lineColor="#000000"/>
            <bottomPen lineWidth="0.5" lineColor="#000000"/>
        </box>
    </style>
    <subDataset name="chargesummary"
                uuid="27da851f-61ae-4c3a-99dd-1041e90f5769">
        <property name="com.jaspersoft.studio.data.defaultdataadapter"
                  value="ZDWAdapter2"/>
        <parameter name="pChargeSummaryInvoiceNumber" class="java.lang.String"/>
        <queryString language="SQL">
            <![CDATA[select ChargeAmount, ChargeGroup from view_chargesummary  where InvoiceNumber = $P{pChargeSummaryInvoiceNumber} order by ordr]]>
        </queryString>
        <field name="chargeamount" class="java.math.BigDecimal"/>
        <field name="ChargeGroup"  class="java.lang.String"/>
        <variable name="chargeamount1" class="java.math.BigDecimal" calculation="Sum">
            <variableExpression><![CDATA[$F{chargeamount}]]></variableExpression>
        </variable>
    </subDataset>
    <subDataset name="MonthlyServices"
                uuid="17621581-eb37-4c9e-b261-b2ea7c34c749">
        <property name="com.jaspersoft.studio.data.defaultdataadapter"
                  value="ZDWAdapter2"/>
        <parameter name="pMonthlyServicesInvoiceNumber"
                   class="java.lang.String"/>
        <queryString>
            <![CDATA[select * from view_recurringdetails where InvoiceNumber = $P{pMonthlyServicesInvoiceNumber}]]>
        </queryString>
        <field name="DisplayName"  class="java.lang.String"/>
        <field name="Quantity"     class="java.math.BigDecimal"/>
        <field name="UnitPrice"    class="java.math.BigDecimal"/>
        <field name="ChargeAmount" class="java.math.BigDecimal"/>
        <field name="ChargeGroup"  class="java.lang.String"/>
        <variable name="ChargeAmount1" class="java.math.BigDecimal" calculation="Sum">
            <variableExpression><![CDATA[$F{ChargeAmount}]]></variableExpression>
        </variable>
    </subDataset>
    <subDataset name="UsageDetails" uuid="3c167ca3-ff99-4c73-9ec1-d9a1347b1c70">
        <property name="com.jaspersoft.studio.data.defaultdataadapter"
                  value="ZDWAdapter2"/>
        <parameter name="pUsageDetailsInvoiceNumber" class="java.lang.String"/>
        <queryString>
            <![CDATA[select * from view_usagedetails where InvoiceNumber = $P{pUsageDetailsInvoiceNumber}]]>
        </queryString>
        <field name="Name"        class="java.lang.String"/>
        <field name="Description" class="java.lang.String"/>
        <field name="Rate"        class="java.lang.String"/>
        <field name="Minutes"     class="java.math.BigDecimal"/>
        <field name="Total"       class="java.math.BigDecimal"/>
        <variable name="Total1" class="java.math.BigDecimal" calculation="Sum">
            <variableExpression><![CDATA[$F{Total}]]></variableExpression>
        </variable>
    </subDataset>
    <subDataset name="TaxDetails" whenResourceMissingType="Empty"
                uuid="97d5f4f4-c347-495b-90ef-d4a9fb6623c6">
        <property name="com.jaspersoft.studio.data.defaultdataadapter" value="ZDWAdapter2"/>
        <parameter name="pTaxationInvoiceItem" class="java.lang.String"/>
        <queryString>
            <![CDATA[select * from view_taxdetails where InvoiceNumber = $P{pTaxationInvoiceItem}]]>
        </queryString>
        <field name="Name"   class="java.lang.String"/>
        <field name="Amount" class="java.math.BigDecimal"/>
        <variable name="Amount1" class="java.math.BigDecimal" calculation="Sum">
            <variableExpression><![CDATA[$F{Amount}]]></variableExpression>
        </variable>
    </subDataset>
    <subDataset name="FeesDetail" uuid="109ace56-8f63-4bc7-bf58-587876224356">
        <property name="com.jaspersoft.studio.data.defaultdataadapter" value="ZDWAdapter2"/>
        <parameter name="pFeeDetailInvoiceNumber" class="java.lang.String"/>
        <queryString>
            <![CDATA[select * from view_feedetail where InvoiceNumber = $P{pFeeDetailInvoiceNumber}]]>
        </queryString>
        <field name="DisplayName"   class="java.lang.String"/>
        <field name="ChargeAmount"  class="java.math.BigDecimal"/>
        <field name="InvoiceNumber" class="java.lang.String"/>
        <field name="Id"            class="java.lang.String"/>
        <variable name="ChargeAmount1" class="java.math.BigDecimal" calculation="Sum">
            <variableExpression><![CDATA[$F{ChargeAmount}]]></variableExpression>
        </variable>
    </subDataset>
    <parameter name="pAccountSummaryInvoiceNumber" class="java.lang.String"/>
    <queryString>
        <![CDATA[select  * from view_AccountDetails where InvoiceNumber = $P{pAccountSummaryInvoiceNumber}]]>
    </queryString>
    <field name="AccountNumber" class="java.lang.String">
        <fieldDescription><![CDATA[]]></fieldDescription>
    </field>
    <field name="accountname"      class="java.lang.String"/>
    <field name="InvoiceDate"      class="java.lang.String"/>
    <field name="PaymentTerm"      class="java.lang.String"/>
    <field name="InvoiceNumber"    class="java.lang.String"/>
    <field name="BillToName"       class="java.lang.String"/>
    <field name="SoldToName"       class="java.lang.String"/>
    <field name="BillToAddress"    class="java.lang.String"/>
    <field name="BillToAddressCSZ" class="java.lang.String"/>
    <field name="SoldToAddress"    class="java.lang.String"/>
    <field name="SoldToAddressCSZ" class="java.lang.String"/>
    <background>
        <band splitType="Stretch"/>
    </background>
    <detail>
        <band height="210" splitType="Immediate">
            <frame>
                <reportElement x="0" y="20" width="250" height="179"
                               uuid="2f88b7a6-aae4-4b69-957f-c8fde32b9a35"/>
                <box>
                    <topPen    lineWidth="1.0" lineStyle="Solid" lineColor="#F5F5F5"/>
                    <leftPen   lineWidth="1.0" lineStyle="Solid" lineColor="#F5F5F5"/>
                    <bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#F5F5F5"/>
                    <rightPen  lineWidth="1.0" lineStyle="Solid" lineColor="#F5F5F5"/>
                </box>
                <rectangle>
                    <reportElement x="0" y="0" width="250" height="30"
                                   backcolor="#F5F5F5"
                                   uuid="1aa1d426-dfb7-4dbf-90e5-84138f5a5dd9"/>
                </rectangle>
                <staticText>
                    <reportElement x="3" y="30" width="100" height="20" uuid="b7e59278-ad9e-4ed9-ad06-74f855ba89cd"/>
                    <text><![CDATA[Val 1]]></text>
                </staticText>
                <staticText>
                    <reportElement x="3" y="48" width="100" height="20" uuid="4e60a934-3e17-4346-a9ac-4cb058843d01"/>
                    <text><![CDATA[Val 2]]></text>
                </staticText>
                <staticText>
                    <reportElement x="3" y="66" width="100" height="20" uuid="4ca07096-d5d1-4197-b2b9-f51222096f2c"/>
                        <text><![CDATA[Val 3]]></text>
                </staticText>
                <rectangle>
                    <reportElement x="0" y="90" width="250" height="20" backcolor="#F5F5F5" uuid="3260dc2e-d98f-4eb4-bcbc-f20bd91fbe38"/>
                </rectangle>
            </frame>
            <frame>
                <reportElement x="290" y="21" width="221" height="69" uuid="13dd2eb9-68c3-45d9-8857-687facd0d7d4"/>
                <componentElement>
                    <reportElement x="0" y="9" width="219" height="60" forecolor="#080000" uuid="93b8d121-4545-439b-9a15-45855e72cd7b"/>
                    <jr:table xmlns:jr="http://jasperreports.sourceforge.net/jasperreports/components"
                              xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports/components http://jasperreports.sourceforge.net/xsd/components.xsd">
                        <datasetRun subDataset="chargesummary" uuid="280c6204-c42b-46f9-9f9b-99b1680be0a3">
                            <datasetParameter name="pChargeSummaryInvoiceNumber">
                                <datasetParameterExpression>
                                    <![CDATA[$P{pAccountSummaryInvoiceNumber}]]>
                                </datasetParameterExpression>
                            </datasetParameter>
                            <connectionExpression>
                                <![CDATA[$P{REPORT_CONNECTION}]]>
                            </connectionExpression>
                        </datasetRun>
                        <jr:column width="120" uuid="4c64ee26-e268-4281-a9bb-f2d608ffe94b">
                            <jr:tableHeader style="Table 1_TH" height="20">
                                <box>
                                    <topPen    lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                                    <leftPen   lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                                    <bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                                    <rightPen  lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                                </box>
                                <staticText>
                                    <reportElement x="3" y="3" width="105" height="17" uuid="f3c391c9-d6dd-48f0-9edc-d5b0c488536e"/>
                                    <textElement>
                                        <font isBold="true"/>
                                    </textElement>
                                    <text>
                                        <![CDATA[List of  Charges]]>
                                    </text>
                                </staticText>
                            </jr:tableHeader>
                            <jr:tableFooter style="Table 1_TH" height="20">
                                <box>
                                    <topPen    lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                                    <leftPen   lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                                    <bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                                    <rightPen  lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                                </box>
                                <staticText>
                                    <reportElement x="1" y="0" width="107" height="20"
                                                   forecolor="#1F53AB"
                                                   uuid="1c4de6f9-9f35-495d-ae20-3e707afdf18c"/>
                                    <textElement>
                                        <font size="12" isBold="true"/>
                                    </textElement>
                                    <text>
                                        <![CDATA[Total Amount Due]]>
                                    </text>
                                </staticText>
                            </jr:tableFooter>
                            <jr:detailCell style="Table 1_TD" height="20">
                                <textField>
                                    <reportElement x="2" y="0" width="106" height="20" uuid="fcefdcd8-2c26-4663-8f0f-730a83d435de"/>
                                    <box>
                                        <topPen    lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                                        <leftPen   lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                                        <bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                                        <rightPen  lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                                    </box>
                                    <textFieldExpression>
                                        <![CDATA[$F{ChargeGroup}]]>
                                    </textFieldExpression>
                                </textField>
                            </jr:detailCell>
                        </jr:column>
                        <jr:column width="100" uuid="6ab515df-506a-410f-acc0-4c1231587f24">
                            <jr:tableHeader style="Table 1_TH" height="20">
                                <box>
                                    <topPen    lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                                    <leftPen   lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                                    <bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                                    <rightPen  lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                                </box>
                                <staticText>
                                    <reportElement x="1" y="3" width="99" height="17"
                                                   uuid="da2be826-75ed-4589-b77b-72169d938ca1"/>
                                    <textElement textAlignment="Right">
                                        <font isBold="true"/>
                                    </textElement>
                                    <text>
                                        <![CDATA[Amount]]>
                                    </text>
                                </staticText>
                            </jr:tableHeader>
                            <jr:tableFooter style="Table 1_TH" height="20">
                                <box>
                                    <topPen    lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                                    <leftPen   lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                                    <bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                                    <rightPen  lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                                </box>
                                <textField>
                                    <reportElement x="8" y="0" width="90" height="20"
                                                    forecolor="#1F53AB"
                                                    uuid="1b2209e1-1c6a-495e-9090-5bc52ea4b57e"/>
                                    <textElement textAlignment="Right">
                                        <font size="12" isBold="true"/>
                                    </textElement>
                                    <textFieldExpression>
                                        <![CDATA[$V{chargeamount1}]]>
                                    </textFieldExpression>
                                </textField>
                            </jr:tableFooter>
                            <jr:detailCell style="Table 1_TD" height="20">
                                <textField>
                                    <reportElement x="0" y="0" width="100" height="20"
                                                   uuid="5753ab62-5c37-4d67-911d-b9f4c33d768f"/>
                                    <box>
                                        <topPen    lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                                        <leftPen   lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                                        <bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                                        <rightPen  lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                                    </box>
                                    <textElement textAlignment="Right"/>
                                    <textFieldExpression>
                                        <![CDATA[$F{chargeamount}]]>
                                    </textFieldExpression>
                                </textField>
                            </jr:detailCell>
                        </jr:column>
                    </jr:table>
                </componentElement>
            </frame>
        </band>
        <band height="101" splitType="Stretch">
            <staticText>
                <reportElement x="220" y="0" width="150" height="30"
                               uuid="f354b2bd-1e10-4c72-9fbe-b887d79728bb"/>
                <text>
                     <![CDATA[Static text to show gap]]>
                </text>
            </staticText>
        </band>
    </detail>
</jasperReport>
roben1's picture
2
Joined: Feb 3 2015 - 10:18pm
Last seen: 4 years 6 months ago

0 Answers:

No answers yet
Feedback