Jump to content
Changes to the Jaspersoft community edition download ×

roben1

Recommended Posts

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>[/code]
Link to comment
Share on other sites

  • Replies 0
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...