Jump to content
Changes to the Jaspersoft community edition download ×

gabryh

Members
  • Posts

    1
  • Joined

  • Last visited

gabryh's Achievements

Newbie

Newbie (1/14)

  • Week One Done
  • One Month Later
  • One Year In
  • First Post Rare
  • Conversation Starter Rare

Recent Badges

0

Reputation

  1. 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>
×
×
  • Create New...