Duplicate results

[gabryh]

Code:

<?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="DemandResponseDetails" language="groovy" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20">

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

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

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

	<subDataset name="Table Dataset 1"/>

	<queryString language="SQL">

		<![CDATA[sELECT

     DEMANDRESPONSE."ID" AS DEMANDRESPONSE_ID,

     DEMANDRESPONSE."CAPACITY" AS DEMANDRESPONSE_CAPACITY,

     DEMANDRESPONSE."COMPLY" AS DEMANDRESPONSE_COMPLY,

     DEMANDRESPONSE."CREATIONDATE" AS DEMANDRESPONSE_CREATIONDATE,

     DEMANDRESPONSE."DRSTATE" AS DEMANDRESPONSE_DRSTATE,

     DEMANDRESPONSE."ENDDATE" AS DEMANDRESPONSE_ENDDATE,

     DEMANDRESPONSE."FILTERCOMMAND" AS DEMANDRESPONSE_FILTERCOMMAND,

     DEMANDRESPONSE."STARTDATE" AS DEMANDRESPONSE_STARTDATE,

     DEMANDRESPONSE."ROOTNODEID" AS DEMANDRESPONSE_ROOTNODEID

FROM

     "GREENLET"."DEMANDRESPONSE" DEMANDRESPONSE]]>

	</queryString>

	<field name="DEMANDRESPONSE_CREATIONDATE" class="java.sql.Timestamp"/>

	<field name="DEMANDRESPONSE_STARTDATE" class="java.sql.Timestamp"/>

	<field name="DEMANDRESPONSE_ENDDATE" class="java.sql.Timestamp"/>

	<field name="DEMANDRESPONSE_FILTERCOMMAND" class="java.lang.Integer"/>

	<background>

		<band splitType="Stretch"/>

	</background>

	<title>

		<band height="37" splitType="Stretch">

			<staticText>

				<reportElement x="121" y="3" width="363" height="34"/>

				<textElement/>

				<text><![CDATA[Demand Response Details]]></text>

			</staticText>

			<textField pattern="HH:mm:ss">

				<reportElement x="484" y="17" width="71" height="17"/>

				<textElement/>

				<textFieldExpression><![CDATA[new java.util.Date()]]></textFieldExpression>

			</textField>

			<textField pattern="dd/MM/yyyy">

				<reportElement x="484" y="0" width="71" height="17"/>

				<textElement/>

				<textFieldExpression><![CDATA[new java.util.Date()]]></textFieldExpression>

			</textField>

			<image hyperlinkType="REFERENCE">

				<reportElement x="0" y="3" width="121" height="34"/>

				<imageExpression><![CDATA["logo.jpg"]]></imageExpression>

				<hyperlinkReferenceExpression><![CDATA["http://www.greenlet.net"]]></hyperlinkReferenceExpression>

			</image>

			<rectangle radius="10">

				<reportElement mode="Transparent" x="0" y="0" width="555" height="37" forecolor="#CCFF33"/>

			</rectangle>

		</band>

	</title>

	<detail>

		<band height="125" splitType="Stretch">

			<staticText>

				<reportElement x="0" y="0" width="61" height="18"/>

				<textElement/>

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

			</staticText>

			<line>

				<reportElement x="0" y="18" width="555" height="1"/>

			</line>

			<componentElement>

				<reportElement x="0" y="19" width="555" height="68"/>

				<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="Table Dataset 1">

						<dataSourceExpression><![CDATA[new net.sf.jasperreports.engine.JREmptyDataSource(1)]]></dataSourceExpression>

					</datasetRun>

					<jr:column width="90">

						<jr:tableHeader height="18" rowSpan="1">

							<staticText>

								<reportElement x="0" y="0" width="90" height="18"/>

								<textElement/>

								<text><![CDATA[start Time:]]></text>

							</staticText>

						</jr:tableHeader>

						<jr:tableFooter height="30" rowSpan="1"/>

						<jr:columnHeader height="19" rowSpan="1">

							<staticText>

								<reportElement x="0" y="0" width="90" height="19"/>

								<textElement/>

								<text><![CDATA[End Time:]]></text>

							</staticText>

						</jr:columnHeader>

						<jr:columnFooter height="30" rowSpan="1"/>

						<jr:detailCell height="20" rowSpan="1"/>

					</jr:column>

					<jr:column width="90">

						<jr:tableHeader height="18" rowSpan="1"/>

						<jr:tableFooter height="30" rowSpan="1"/>

						<jr:columnHeader height="19" rowSpan="1"/>

						<jr:columnFooter height="30" rowSpan="1"/>

						<jr:detailCell height="20" rowSpan="1"/>

					</jr:column>

					<jr:column width="90">

						<jr:tableHeader height="18" rowSpan="1"/>

						<jr:tableFooter height="30" rowSpan="1"/>

						<jr:columnHeader height="19" rowSpan="1"/>

						<jr:columnFooter height="30" rowSpan="1"/>

						<jr:detailCell height="20" rowSpan="1"/>

					</jr:column>

					<jr:column width="90">

						<jr:tableHeader height="18" rowSpan="1"/>

						<jr:tableFooter height="30" rowSpan="1"/>

						<jr:columnHeader height="19" rowSpan="1"/>

						<jr:columnFooter height="30" rowSpan="1"/>

						<jr:detailCell height="20" rowSpan="1"/>

					</jr:column>

				</jr:table>

			</componentElement>

		</band>

	</detail>

	<summary>

		<band height="42" splitType="Stretch"/>

	</summary>

</jasperReport>

[szaharia]

Hi,

Try to run the query separately and see how many rows does it return. Apparently there are 2 records in the result set, and therefore the detail section is repeated twice.

HTH,

sanda