gabryh Posted September 19, 2011 Share Posted September 19, 2011 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> Link to comment Share on other sites More sharing options...
szaharia Posted September 21, 2011 Share Posted September 21, 2011 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 Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now