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]
