2004 IR Help

Members

View Profile See their activity

Posts
2,951
Joined
August 17, 2006
Last visited
August 17, 2006

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

2004 IR Help's Achievements

Grand Master (14/14)

Rare
Rare

Recent Badges

Reputation

missing mandatory parameter

2004 IR Help posted a topic in Products

By: Todd - tberman333 missing mandatory parameter 2004-10-12 12:39 When I try to generate data in a report I just built, I get the following errors: Error filling print... java.sql.SQLException: ORA-01009: missing mandatory parameter at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134) at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289) at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:579) at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1894) at oracle.jdbc.ttc7.TTC7Protocol.fetch(TTC7Protocol.java:1199) at oracle.jdbc.driver.OracleResultSetImpl.next(OracleResultSetImpl.java:295) at dori.jasper.engine.JRResultSetDataSource.next(JRResultSetDataSource.java:121) at dori.jasper.engine.fill.JRBaseFiller.next(JRBaseFiller.java:711) at dori.jasper.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:173) at dori.jasper.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:554) at dori.jasper.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:471) at dori.jasper.engine.fill.JRFiller.fillReport(JRFiller.java:120) at dori.jasper.engine.JasperFillManager.fillReport(JasperFillManager.java:222) at dori.jasper.engine.JasperFillManager.fillReport(JasperFillManager.java:162) at it.businesslogic.ireport.IReportCompiler.run(IReportCompiler.java:415) at java.lang.Thread.run(Thread.java:534) NESTED BY : java.sql.SQLException: ORA-01009: missing mandatory parameter at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134) at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289) at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:579) at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1894) at oracle.jdbc.ttc7.TTC7Protocol.fetch(TTC7Protocol.java:1199) at oracle.jdbc.driver.OracleResultSetImpl.next(OracleResultSetImpl.java:295) at dori.jasper.engine.JRResultSetDataSource.next(JRResultSetDataSource.java:121) at dori.jasper.engine.fill.JRBaseFiller.next(JRBaseFiller.java:711) at dori.jasper.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:173) at dori.jasper.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:554) at dori.jasper.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:471) at dori.jasper.engine.fill.JRFiller.fillReport(JRFiller.java:120) at dori.jasper.engine.JasperFillManager.fillReport(JasperFillManager.java:222) at dori.jasper.engine.JasperFillManager.fillReport(JasperFillManager.java:162) at it.businesslogic.ireport.IReportCompiler.run(IReportCompiler.java:415) at java.lang.Thread.run(Thread.java:534) NESTED BY : dori.jasper.engine.JRException: Unable to get next record. at dori.jasper.engine.JRResultSetDataSource.next(JRResultSetDataSource.java:125) at dori.jasper.engine.fill.JRBaseFiller.next(JRBaseFiller.java:711) at dori.jasper.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:173) at dori.jasper.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:554) at dori.jasper.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:471) at dori.jasper.engine.fill.JRFiller.fillReport(JRFiller.java:120) at dori.jasper.engine.JasperFillManager.fillReport(JasperFillManager.java:222) at dori.jasper.engine.JasperFillManager.fillReport(JasperFillManager.java:162) at it.businesslogic.ireport.IReportCompiler.run(IReportCompiler.java:415) at java.lang.Thread.run(Thread.java:534) Caused by: java.sql.SQLException: ORA-01009: missing mandatory parameter at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134) at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289) at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:579) at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1894) at oracle.jdbc.ttc7.TTC7Protocol.fetch(TTC7Protocol.java:1199) at oracle.jdbc.driver.OracleResultSetImpl.next(OracleResultSetImpl.java:295) at dori.jasper.engine.JRResultSetDataSource.next(JRResultSetDataSource.java:121) ... 9 more Print not filled. Try to use an EmptyDataSource...! I can print this report with an empty data source, but as soon as I attempt to pull in data I get this message. The XML for my report is below: <?xml version="1.0" encoding="UTF-8" ?>  <!DOCTYPE jasperReport PUBLIC "//JasperReports//DTD Report Design//EN" "http://jasperreports.sourceforge.net/dtds/jasperreport.dtd"> <jasperReport name="LoanRecon" columnCount="1" printOrder="Vertical" orientation="Portrait" pageWidth="612" pageHeight="792" columnWidth="535" columnSpacing="0" leftMargin="45" rightMargin="30" topMargin="20" bottomMargin="20" whenNoDataType="NoPages" isTitleNewPage="false" isSummaryNewPage="false"> <property name="ireport.scriptlethandling" value="2" /> <parameter name="FLOORPLANNING_SCHEMA" isForPrompting="true" class="java.lang.String"> <defaultValueExpression ><![CDATA["AGC_USA"]]></defaultValueExpression> </parameter> <parameter name="OPENREPORTS_USER_NAME" isForPrompting="false" class="java.lang.String"> <defaultValueExpression ><![CDATA["BermanT"]]></defaultValueExpression> </parameter> <parameter name="ReturnedValuesMap" isForPrompting="true" class="java.util.HashMap"> <defaultValueExpression ><![CDATA[new java.util.HashMap()]]></defaultValueExpression> </parameter> <parameter name="JASPERSUBREPORT" isForPrompting="true" class="java.lang.String"> <defaultValueExpression ><![CDATA["Subreport2.jasper"]]></defaultValueExpression> </parameter> <parameter name="POSTING_DATE" isForPrompting="true" class="java.lang.String"> <defaultValueExpression ><![CDATA["12/30/2003"]]></defaultValueExpression> </parameter> <queryString><![CDATA[--Cashflow arithmatic logic --Cashflow Type | Condition | Effect ------------------------------------------------------------------ --10 | Event code = U03 | increase amount owing --New Entry --10 | Event code = U33 | increase amount owing --20 | Event code = U07 | decrease amount owing --20 | Event code = U09 | increase amount owing --25 | Event code = U13 | increase amount owing --25 | Event code = U20 | decrease amount owing --30 | Event code = U21 | decrease amount owing --30 | Event code = U28 | increase amount owing -- --New Entry --30 | Event code = U20 | increase amount owing --New Entry --30 | Event code = U40 | decrease amount owing --New Entry --30 | Event code = U13 | decrease amount owing -- --50 | Event code = U33 | decrease amount owing --55 | Event code = U33 | increase amount owing /* The following select will return a balance that is ideal, meaning if everything billed has been payed. */ SELECT t1.*, t2.*, t3.adjbalance FROM (SELECT cashflow.contractnumber, cashflow.cashflowtypecode, businessevent.eventcode, CASE WHEN cashflow.cashflowtypecode = 10 THEN DECODE(businessevent.eventcode,'U03','TotalConsignmentCashflows' ,'U33','TotalConsignmentCashflows') WHEN cashflow.cashflowtypecode = 20 THEN DECODE(businessevent.eventcode,'U07','TotalDeconsignmentCashflows' ,'U09','TotalRevDeconsignmentCashflows') WHEN cashflow.cashflowtypecode = 25 THEN DECODE(businessevent.eventcode,'U13','TotalDebitNotes' ,'U20','TotalCreditNotes') WHEN cashflow.cashflowtypecode = 30 THEN DECODE(businessevent.eventcode,'U13','TotalDebitReconPayments' ,'U20','TotalRefundCapitalPayments' ,'U21','TotalCapitalPayments' ,'U28','TotalReverseCapitalPayments' ,'U40','TotalCurtailmentPayments') WHEN cashflow.cashflowtypecode = 50 THEN DECODE(businessevent.eventcode,'U33','TotalSwapPayments') WHEN cashflow.cashflowtypecode = 55 THEN DECODE(businessevent.eventcode,'U33','TotalCapitalRepayments') END AS TransactionType, CASE WHEN cashflow.cashflowtypecode = 10 THEN DECODE(businessevent.eventcode,'U03',abs(cashflow.cashflowamount) ,'U33',abs(cashflow.cashflowamount)) WHEN cashflow.cashflowtypecode = 20 THEN DECODE(businessevent.eventcode,'U07',abs(cashflow.cashflowamount) * -1 ,'U09',abs(cashflow.cashflowamount)) WHEN cashflow.cashflowtypecode = 25 THEN DECODE(businessevent.eventcode,'U13',abs(cashflow.cashflowamount) ,'U20',abs(cashflow.cashflowamount) * -1) WHEN cashflow.cashflowtypecode = 30 THEN DECODE(businessevent.eventcode,'U13',abs(cashflow.cashflowamount) * -1 ,'U20',abs(cashflow.cashflowamount) ,'U21',abs(cashflow.cashflowamount) * -1 ,'U28',abs(cashflow.cashflowamount) ,'U40',abs(cashflow.cashflowamount) * -1) WHEN cashflow.cashflowtypecode = 50 THEN DECODE(businessevent.eventcode,'U33',abs(cashflow.cashflowamount) * -1) WHEN cashflow.cashflowtypecode = 55 THEN DECODE(businessevent.eventcode,'U33',Abs(cashflow.cashflowamount)) END AS Amount, businessevent.eventcpd, asset.idnumbersuffix, contract.dealerbpid, contract.fundingdate, bpmaster.name, financecompany.financecompanydescription FROM AGC_USA.cashflow, AGC_USA.cashflowtype, AGC_USA.cashflowtransaction, AGC_USA.businessevent, AGC_USA.event, AGC_USA.Asset, AGC_USA.Contract, AGC_USA.bpmaster, AGC_USA.financecompany WHERE cashflow.duedate <= to_date('30/12/2003', 'dd/mm/yyyy')--VAR AND cashflow.cashflowsequencenumber = cashflowtransaction.cashflowsequencenumber AND cashflowtransaction.eventid = businessevent.eventid AND event.eventcode = businessevent.eventcode AND cashflowtype.cashflowtypecode = cashflow.cashflowtypecode AND cashflowtype.flowtype = '1' AND cashflow.contractnumber = asset.contractnumber AND cashflow.contractnumber = contract.contractnumber AND contract.dealerbpid = bpmaster.bpidentifier AND CONTRACT.FINANCECOMPANYCODE = FINANCECOMPANY.FINANCECOMPANYCODE) t1, ( SELECT contractplanperiod.contractnumber, sum(contractplanperiod.periodlength) AS FreeDays FROM agc_usa.contractplanperiod, agc_usa.planperiod WHERE planperiod.plancode = contractplanperiod.plancode AND planperiod.periodsequencenumber = contractplanperiod.periodsequencenumber AND planperiod.liablebptypecode = 'DIST' GROUP BY contractplanperiod.contractnumber) t2, ( SELECT s2.contractnumber, s2.Balance, nvl(s3.allocationamount, 0) as Adjustments, (s2.balance + nvl(s3.allocationamount, 0)) as AdjBalance FROM ( SELECT s1.contractnumber, sum(Amount) as Balance FROM( SELECT cashflow.contractnumber, cashflow.cashflowtypecode, businessevent.eventcode, CASE WHEN cashflow.cashflowtypecode = 10 THEN DECODE(businessevent.eventcode,'U03',abs(cashflow.cashflowamount) ,'U33',abs(cashflow.cashflowamount)) WHEN cashflow.cashflowtypecode = 20 THEN DECODE(businessevent.eventcode,'U07',abs(cashflow.cashflowamount) * -1 ,'U09',abs(cashflow.cashflowamount)) WHEN cashflow.cashflowtypecode = 25 THEN DECODE(businessevent.eventcode,'U13',abs(cashflow.cashflowamount) ,'U20',abs(cashflow.cashflowamount) * -1) WHEN cashflow.cashflowtypecode = 30 THEN DECODE(businessevent.eventcode,'U13',abs(cashflow.cashflowamount) * -1 ,'U20',abs(cashflow.cashflowamount) ,'U21',abs(cashflow.cashflowamount) * -1 ,'U28',abs(cashflow.cashflowamount) ,'U40',abs(cashflow.cashflowamount) * -1) WHEN cashflow.cashflowtypecode = 50 THEN DECODE(businessevent.eventcode,'U33',abs(cashflow.cashflowamount) * -1) WHEN cashflow.cashflowtypecode = 55 THEN DECODE(businessevent.eventcode,'U33',Abs(cashflow.cashflowamount)) END AS Amount FROM AGC_USA.cashflow, AGC_USA.cashflowtype, AGC_USA.cashflowtransaction, AGC_USA.businessevent, AGC_USA.event WHERE cashflow.duedate <= to_date('30/12/2003', 'dd/mm/yyyy')--VAR AND cashflow.cashflowsequencenumber = cashflowtransaction.cashflowsequencenumber AND cashflowtransaction.eventid = businessevent.eventid AND event.eventcode = businessevent.eventcode AND cashflowtype.cashflowtypecode = cashflow.cashflowtypecode AND cashflowtype.flowtype = '1') s1 GROUP BY s1.CONTRACTNUMBER) s2, ( SELECT arinvoiceline.reference ContractNumber, SUM(ardocumentallocation.allocationamountac) AllocationAmount FROM agc_usa.ardocumentline, agc_usa.ardocument, agc_usa.arinvoice, agc_usa.arinvoiceline, agc_usa.transactiontype, agc_usa.ardocumentstatus, agc_usa.ardocumentallocation WHERE ardocumentline.documentnumber = ardocument.documentnumber AND ardocument.postingdate < to_date('30/12/2003', 'dd/mm/yyyy')--VAR AND ardocument.documentstatuscode = ardocumentstatus.documentstatuscode AND ardocumentline.documentnumber = arinvoice.documentnumber AND arinvoice.transactiontypecode in ('00030', '00040') AND arinvoice.transactiontypecode = transactiontype.transactiontypecode AND ardocumentline.documentnumber = arinvoiceline.documentnumber AND ardocumentline.documentlinenumber = arinvoiceline.documentlinenumber AND arinvoiceline.documentnumber = ardocumentallocation.debitdocumentnumber (+) AND arinvoiceline.documentlinenumber = ardocumentallocation.debitdocumentlinenumber (+) AND (ardocumentallocation.appliedcpd >= to_date('30/12/2003', 'dd/mm/yyyy')--VAR OR ardocumentallocation.appliedcpd is null) GROUP BY arinvoiceline.reference) s3 WHERE s2.contractnumber = s3.contractnumber(+)) t3 WHERE t1.contractnumber = t2.contractnumber(+) AND t1.contractnumber = t3.contractnumber ORDER BY t1.contractnumber]]></queryString> <field name="CONTRACTNUMBER" class="java.lang.Double"/> <field name="CASHFLOWTYPECODE" class="java.lang.String"/> <field name="EVENTCODE" class="java.lang.String"/> <field name="TRANSACTIONTYPE" class="java.lang.String"/> <field name="AMOUNT" class="java.lang.Double"/> <field name="EVENTCPD" class="java.util.Date"/> <field name="IDNUMBERSUFFIX" class="java.lang.String"/> <field name="DEALERBPID" class="java.lang.String"/> <field name="FUNDINGDATE" class="java.util.Date"/> <field name="NAME" class="java.lang.String"/> <field name="FINANCECOMPANYDESCRIPTION" class="java.lang.String"/> <field name="FREEDAYS" class="java.lang.Double"/> <field name="ADJBALANCE" class="java.lang.Double"/> <variable name="PAGE_TOTAL" class="java.lang.Integer" resetType="Report" calculation="Nothing"> <variableExpression><![CDATA[$V{PAGE_NUMBER}]]></variableExpression> </variable> <variable name="Tras_Total" class="java.lang.Double" resetType="Group" resetGroup="Transaction_Type" calculation="Sum"> <variableExpression><![CDATA[$F{AMOUNT}]]></variableExpression> </variable> <variable name="Deal_Total" class="java.lang.Double" resetType="Group" resetGroup="Dealer" calculation="Sum"> <variableExpression><![CDATA[$F{AMOUNT}]]></variableExpression> </variable> <variable name="Grand_Total" class="java.lang.Double" resetType="Report" calculation="Sum"> <variableExpression><![CDATA[$F{AMOUNT}]]></variableExpression> </variable> <group name="Dealer" isStartNewColumn="false" isStartNewPage="false" isResetPageNumber="false" isReprintHeaderOnEachPage="false" minHeightToStartNewPage="0" > <groupExpression><![CDATA[$F{NAME} + $F{DEALERBPID}]]></groupExpression> <groupHeader> <band height="15" isSplitAllowed="true" > <textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" > <reportElement mode="Opaque" x="0" y="0" width="203" height="12" forecolor="#000000" backcolor="#FFFFFF" key="textField" stretchType="NoStretch" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Left" verticalAlignment="Top" rotation="None" lineSpacing="Single"> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$F{NAME} + '/' + $F{DEALERBPID}]]></textFieldExpression> </textField> </band> </groupHeader> <groupFooter> <band height="20" isSplitAllowed="true" > <staticText> <reportElement mode="Opaque" x="0" y="5" width="187" height="12" forecolor="#000000" backcolor="#FFFFFF" key="staticText-14" stretchType="NoStretch" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Left" verticalAlignment="Top" rotation="None" lineSpacing="Single"> </textElement> <text><![CDATA[DEALER TOTAL]]></text> </staticText> <line direction="TopDown"> <reportElement mode="Opaque" x="0" y="19" width="537" height="0" forecolor="#000000" backcolor="#FFFFFF" key="line-1" stretchType="NoStretch" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <graphicElement stretchType="NoStretch" pen="Thin" fill="Solid" /> </line> <textField isStretchWithOverflow="false" pattern="#,##0.00" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" > <reportElement mode="Opaque" x="193" y="5" width="66" height="12" forecolor="#000000" backcolor="#FFFFFF" key="textField" stretchType="NoStretch" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Right" verticalAlignment="Top" rotation="None" lineSpacing="Single"> </textElement> <textFieldExpression class="java.lang.Double"><![CDATA[$V{Deal_Total}]]></textFieldExpression> </textField> </band> </groupFooter> </group> <group name="Transaction_Type" isStartNewColumn="false" isStartNewPage="false" isResetPageNumber="false" isReprintHeaderOnEachPage="false" minHeightToStartNewPage="0" > <groupExpression><![CDATA[$F{TRANSACTIONTYPE}]]></groupExpression> <groupHeader> <band height="15" isSplitAllowed="true" > <textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" > <reportElement mode="Opaque" x="0" y="0" width="100" height="12" forecolor="#000000" backcolor="#FFFFFF" key="textField" stretchType="NoStretch" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Left" verticalAlignment="Top" rotation="None" lineSpacing="Single"> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$F{TRANSACTIONTYPE}]]></textFieldExpression> </textField> </band> </groupHeader> <groupFooter> <band height="15" isSplitAllowed="true" > <textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" > <reportElement mode="Opaque" x="0" y="3" width="190" height="12" forecolor="#000000" backcolor="#FFFFFF" key="textField" stretchType="NoStretch" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Left" verticalAlignment="Top" rotation="None" lineSpacing="Single"> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$F{TRANSACTIONTYPE} + " TOTALS"]]></textFieldExpression> </textField> <textField isStretchWithOverflow="false" pattern="#,##0.00" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" > <reportElement mode="Opaque" x="193" y="3" width="66" height="12" forecolor="#000000" backcolor="#FFFFFF" key="textField" stretchType="NoStretch" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Right" verticalAlignment="Top" rotation="None" lineSpacing="Single"> </textElement> <textFieldExpression class="java.lang.Double"><![CDATA[$V{Tras_Total}]]></textFieldExpression> </textField> </band> </groupFooter> </group> <background> <band height="0" isSplitAllowed="true" > </band> </background> <title> <band height="0" isSplitAllowed="true" > </band> </title> <pageHeader> <band height="54" isSplitAllowed="true" > <textField isStretchWithOverflow="false" pattern="MM/dd/yyyy h:mm a" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" > <reportElement mode="Transparent" x="416" y="37" width="121" height="11" forecolor="#000000" backcolor="#FFFFFF" key="element-83" stretchType="NoStretch" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Right" verticalAlignment="Bottom" rotation="None" lineSpacing="Single"> </textElement> <textFieldExpression class="java.util.Date"><![CDATA[new Date()]]></textFieldExpression> </textField> <line direction="TopDown"> <reportElement mode="Opaque" x="0" y="51" width="537" height="0" forecolor="#000000" backcolor="#FFFFFF" key="element-97" stretchType="NoStretch" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <graphicElement stretchType="NoStretch" pen="Thin" fill="Solid" /> </line> <textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" > <reportElement mode="Opaque" x="0" y="20" width="264" height="14" forecolor="#000000" backcolor="#FFFFFF" key="textField" stretchType="NoStretch" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Left" verticalAlignment="Top" rotation="None" lineSpacing="Single"> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$F{FINANCECOMPANYDESCRIPTION}]]></textFieldExpression> </textField> <staticText> <reportElement mode="Opaque" x="0" y="1" width="424" height="20" forecolor="#009999" backcolor="#FFFFFF" key="staticText-8" stretchType="NoStretch" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Left" verticalAlignment="Top" rotation="None" lineSpacing="Single"> </textElement> <text><![CDATA[Loan Reconciliation]]></text> </staticText> <staticText> <reportElement mode="Opaque" x="0" y="34" width="73" height="14" forecolor="#000000" backcolor="#FFFFFF" key="staticText-5" stretchType="NoStretch" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Left" verticalAlignment="Bottom" rotation="None" lineSpacing="Single"> </textElement> <text><![CDATA[Posting Date :]]></text> </staticText> <textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" > <reportElement mode="Opaque" x="73" y="34" width="133" height="14" forecolor="#000000" backcolor="#FFFFFF" key="textField-1" stretchType="NoStretch" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Left" verticalAlignment="Bottom" rotation="None" lineSpacing="Single"> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$P{POSTING_DATE}]]></textFieldExpression> </textField> </band> </pageHeader> <columnHeader> <band height="17" isSplitAllowed="true" > <staticText> <reportElement mode="Opaque" x="0" y="0" width="66" height="10" forecolor="#000000" backcolor="#FFFFFF" key="staticText-3" stretchType="NoStretch" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Left" verticalAlignment="Top" rotation="None" lineSpacing="Single"> </textElement> <text><![CDATA[serial Number]]></text> </staticText> <line direction="TopDown"> <reportElement mode="Opaque" x="0" y="16" width="537" height="0" forecolor="#000000" backcolor="#FFFFFF" key="line-1" stretchType="NoStretch" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <graphicElement stretchType="NoStretch" pen="Thin" fill="Solid" /> </line> <staticText> <reportElement mode="Opaque" x="117" y="0" width="66" height="10" forecolor="#000000" backcolor="#FFFFFF" key="staticText-9" stretchType="NoStretch" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Left" verticalAlignment="Top" rotation="None" lineSpacing="Single"> </textElement> <text><![CDATA[Effective Date]]></text> </staticText> <staticText> <reportElement mode="Opaque" x="193" y="0" width="66" height="10" forecolor="#000000" backcolor="#FFFFFF" key="staticText-10" stretchType="NoStretch" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Right" verticalAlignment="Top" rotation="None" lineSpacing="Single"> </textElement> <text><![CDATA[Amount]]></text> </staticText> <staticText> <reportElement mode="Opaque" x="286" y="0" width="66" height="10" forecolor="#000000" backcolor="#FFFFFF" key="staticText-11" stretchType="NoStretch" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Left" verticalAlignment="Top" rotation="None" lineSpacing="Single"> </textElement> <text><![CDATA[Funding Date]]></text> </staticText> <staticText> <reportElement mode="Opaque" x="373" y="0" width="66" height="10" forecolor="#000000" backcolor="#FFFFFF" key="staticText-12" stretchType="NoStretch" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Right" verticalAlignment="Top" rotation="None" lineSpacing="Single"> </textElement> <text><![CDATA[Free Days]]></text> </staticText> <staticText> <reportElement mode="Opaque" x="453" y="0" width="66" height="10" forecolor="#000000" backcolor="#FFFFFF" key="staticText-13" stretchType="NoStretch" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Right" verticalAlignment="Top" rotation="None" lineSpacing="Single"> </textElement> <text><![CDATA[O/S Balance]]></text> </staticText> </band> </columnHeader> <detail> <band height="11" isSplitAllowed="true" > <textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" > <reportElement mode="Opaque" x="0" y="0" width="103" height="10" forecolor="#000000" backcolor="#FFFFFF" key="textField" stretchType="NoStretch" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Left" verticalAlignment="Top" rotation="None" lineSpacing="Single"> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$F{IDNUMBERSUFFIX}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="false" pattern="MM/dd/yyyy" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" > <reportElement mode="Opaque" x="117" y="0" width="66" height="10" forecolor="#000000" backcolor="#FFFFFF" key="textField" stretchType="NoStretch" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Left" verticalAlignment="Top" rotation="None" lineSpacing="Single"> </textElement> <textFieldExpression class="java.util.Date"><![CDATA[$F{EVENTCPD}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="false" pattern="#,##0.00" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" > <reportElement mode="Opaque" x="193" y="0" width="66" height="10" forecolor="#000000" backcolor="#FFFFFF" key="textField" stretchType="NoStretch" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Right" verticalAlignment="Top" rotation="None" lineSpacing="Single"> </textElement> <textFieldExpression class="java.lang.Double"><![CDATA[$F{AMOUNT}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="false" pattern="MM/dd/yyyy" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" > <reportElement mode="Opaque" x="286" y="0" width="84" height="10" forecolor="#000000" backcolor="#FFFFFF" key="textField" stretchType="NoStretch" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Left" verticalAlignment="Top" rotation="None" lineSpacing="Single"> </textElement> <textFieldExpression class="java.util.Date"><![CDATA[$F{FUNDINGDATE}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="false" pattern="###0" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" > <reportElement mode="Opaque" x="373" y="0" width="66" height="10" forecolor="#000000" backcolor="#FFFFFF" key="textField" stretchType="NoStretch" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Right" verticalAlignment="Top" rotation="None" lineSpacing="Single"> </textElement> <textFieldExpression class="java.lang.Double"><![CDATA[$F{FREEDAYS}]]></textFieldExpression> </textField> </band> </detail> <columnFooter> <band height="0" isSplitAllowed="true" > </band> </columnFooter> <pageFooter> <band height="31" isSplitAllowed="true" > <textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" > <reportElement mode="Opaque" x="0" y="11" width="263" height="11" forecolor="#000000" backcolor="#FFFFFF" key="element-1" stretchType="NoStretch" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Left" verticalAlignment="Top" rotation="None" lineSpacing="Single"> </textElement> <textFieldExpression class="java.lang.String"><![CDATA["LOANREC"]]></textFieldExpression> </textField> <textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" > <reportElement mode="Opaque" x="392" y="11" width="145" height="11" forecolor="#000000" backcolor="#FFFFFF" key="element-56" stretchType="NoStretch" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Right" verticalAlignment="Top" rotation="None" lineSpacing="Single"> </textElement> <textFieldExpression class="java.lang.String"><![CDATA["Page : " + $V{PAGE_NUMBER}]]></textFieldExpression> </textField> <line direction="TopDown"> <reportElement mode="Opaque" x="0" y="5" width="537" height="0" forecolor="#000000" backcolor="#FFFFFF" key="line-1" stretchType="NoStretch" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <graphicElement stretchType="NoStretch" pen="Thin" fill="Solid" /> </line> <line direction="TopDown"> <reportElement mode="Opaque" x="0" y="26" width="537" height="0" forecolor="#000000" backcolor="#FFFFFF" key="line-1" stretchType="NoStretch" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <graphicElement stretchType="NoStretch" pen="Thin" fill="Solid" /> </line> </band> </pageFooter> <summary> <band height="12" isSplitAllowed="true" > <staticText> <reportElement mode="Opaque" x="0" y="0" width="142" height="12" forecolor="#000000" backcolor="#FFFFFF" key="staticText-7" stretchType="NoStretch" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Left" verticalAlignment="Top" rotation="None" lineSpacing="Single"> </textElement> <text><![CDATA[GRAND TOTAL]]></text> </staticText> <textField isStretchWithOverflow="false" pattern="#,##0.00" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" > <reportElement mode="Opaque" x="159" y="0" width="100" height="12" forecolor="#000000" backcolor="#FFFFFF" key="textField" stretchType="NoStretch" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Right" verticalAlignment="Top" rotation="None" lineSpacing="Single"> </textElement> <textFieldExpression class="java.lang.Double"><![CDATA[$V{Deal_Total}]]></textFieldExpression> </textField> </band> </summary> </jasperReport> Any help would be greatly apprciated! Thanks in advance! By: BJ Freeman - bjfreemanAccepting Donations RE: missing mandatory parameter 2004-10-12 14:11 I notice your are using a previous version of jasperreports. not sure that is your problem. also I was not able to load your xml into Ireports. By: Todd - tberman333 RE: missing mandatory parameter 2004-10-12 14:15 I have not changed to the newest version of iReports. As far as the XML. I am not sure why you can't add it to iReorts. I will post it as it's own message right after this so it does not get mixed in with other text. Thanks again for the help By: Todd - tberman333 RE: missing mandatory parameter 2004-10-12 14:16 <?xml version="1.0" encoding="UTF-8" ?>  <!DOCTYPE jasperReport PUBLIC "//JasperReports//DTD Report Design//EN" "http://jasperreports.sourceforge.net/dtds/jasperreport.dtd"> <jasperReport name="LoanRecon" columnCount="1" printOrder="Vertical" orientation="Portrait" pageWidth="612" pageHeight="792" columnWidth="535" columnSpacing="0" leftMargin="45" rightMargin="30" topMargin="20" bottomMargin="20" whenNoDataType="NoPages" isTitleNewPage="false" isSummaryNewPage="false"> <property name="ireport.scriptlethandling" value="2" /> <parameter name="FLOORPLANNING_SCHEMA" isForPrompting="true" class="java.lang.String"> <defaultValueExpression ><![CDATA["AGC_USA"]]></defaultValueExpression> </parameter> <parameter name="OPENREPORTS_USER_NAME" isForPrompting="false" class="java.lang.String"> <defaultValueExpression ><![CDATA["BermanT"]]></defaultValueExpression> </parameter> <parameter name="ReturnedValuesMap" isForPrompting="true" class="java.util.HashMap"> <defaultValueExpression ><![CDATA[new java.util.HashMap()]]></defaultValueExpression> </parameter> <parameter name="JASPERSUBREPORT" isForPrompting="true" class="java.lang.String"> <defaultValueExpression ><![CDATA["Subreport2.jasper"]]></defaultValueExpression> </parameter> <parameter name="POSTING_DATE" isForPrompting="true" class="java.lang.String"> <defaultValueExpression ><![CDATA["12/30/2003"]]></defaultValueExpression> </parameter> <queryString><![CDATA[--Cashflow arithmatic logic --Cashflow Type | Condition | Effect ------------------------------------------------------------------ --10 | Event code = U03 | increase amount owing --New Entry --10 | Event code = U33 | increase amount owing --20 | Event code = U07 | decrease amount owing --20 | Event code = U09 | increase amount owing --25 | Event code = U13 | increase amount owing --25 | Event code = U20 | decrease amount owing --30 | Event code = U21 | decrease amount owing --30 | Event code = U28 | increase amount owing -- --New Entry --30 | Event code = U20 | increase amount owing --New Entry --30 | Event code = U40 | decrease amount owing --New Entry --30 | Event code = U13 | decrease amount owing -- --50 | Event code = U33 | decrease amount owing --55 | Event code = U33 | increase amount owing /* The following select will return a balance that is ideal, meaning if everything billed has been payed. */ SELECT t1.*, t2.*, t3.adjbalance FROM (SELECT cashflow.contractnumber, cashflow.cashflowtypecode, businessevent.eventcode, CASE WHEN cashflow.cashflowtypecode = 10 THEN DECODE(businessevent.eventcode,'U03','TotalConsignmentCashflows' ,'U33','TotalConsignmentCashflows') WHEN cashflow.cashflowtypecode = 20 THEN DECODE(businessevent.eventcode,'U07','TotalDeconsignmentCashflows' ,'U09','TotalRevDeconsignmentCashflows') WHEN cashflow.cashflowtypecode = 25 THEN DECODE(businessevent.eventcode,'U13','TotalDebitNotes' ,'U20','TotalCreditNotes') WHEN cashflow.cashflowtypecode = 30 THEN DECODE(businessevent.eventcode,'U13','TotalDebitReconPayments' ,'U20','TotalRefundCapitalPayments' ,'U21','TotalCapitalPayments' ,'U28','TotalReverseCapitalPayments' ,'U40','TotalCurtailmentPayments') WHEN cashflow.cashflowtypecode = 50 THEN DECODE(businessevent.eventcode,'U33','TotalSwapPayments') WHEN cashflow.cashflowtypecode = 55 THEN DECODE(businessevent.eventcode,'U33','TotalCapitalRepayments') END AS TransactionType, CASE WHEN cashflow.cashflowtypecode = 10 THEN DECODE(businessevent.eventcode,'U03',abs(cashflow.cashflowamount) ,'U33',abs(cashflow.cashflowamount)) WHEN cashflow.cashflowtypecode = 20 THEN DECODE(businessevent.eventcode,'U07',abs(cashflow.cashflowamount) * -1 ,'U09',abs(cashflow.cashflowamount)) WHEN cashflow.cashflowtypecode = 25 THEN DECODE(businessevent.eventcode,'U13',abs(cashflow.cashflowamount) ,'U20',abs(cashflow.cashflowamount) * -1) WHEN cashflow.cashflowtypecode = 30 THEN DECODE(businessevent.eventcode,'U13',abs(cashflow.cashflowamount) * -1 ,'U20',abs(cashflow.cashflo
Date Paramters

2004 IR Help posted a topic in Products

By: Todd - tberman333 Date Paramters 2004-09-01 11:32 I am having trouble using a date parameter in my SQL (i.e. a parameter that is set witha class type of java.util.Date). Depending on what I use as a defult for this parameter I get a varity of error messages in my SQL. I want my defualt date to be 31st of July, 2004. Can someone tell me how the default expression should be written to achive this. As a note, if I change my SQL to say 'DOC.POSTINGDATE <= sysdate' rather than DOC.POSTINGDATE <= $P!{POSTING_DATE} it seems to work successfully. A few of the error messages I have recived are: Default expression = new Date(07-31-2004) Error message = SQL problems:ORA-00907:missing right parenthesis. Default expression = '07-31-2004' Error message = General problem:Sourced file: eval stream tocken parsing error: Lexical error at line 121, calumn 44. Encountered: "7" (55) after : "0"Check username and password; is the DBMS active?!. Thanks for the help! By: Todd - tberman333 RE: Date Paramters 2004-09-02 07:27 I have done a liitle more reseach into this and noticed that the default should be in this format: new java.util.Date(2004,8,31) When I use that format, I get a message in my SQL: Error message = SQL problems:ORA-00907:missing right parenthesis Also if I try to complile the report, I get the following message: Compiling to file... C:iReports Outputaacintrec.jasper -> C:iReports OutputInterestReconciliation.java Errors compiling C:iReports Outputaacintrec.jasper! 0 [Thread-35] WARN design.JRVerifier - Warning : Element bottom reaches outside band area : y=126 height=0 band-height=0 dori.jasper.engine.JRException: Report design not valid : 1. Field not found : Field at dori.jasper.engine.design.JRAbstractJavaCompiler.compileReport(JRAbstractJavaCompiler.java:111) at dori.jasper.engine.design.JRDefaultCompiler.compileReport(JRDefaultCompiler.java:137) at dori.jasper.engine.JasperCompileManager.compileReportToFile(JasperCompileManager.java:138) at dori.jasper.engine.JasperCompileManager.compileReportToFile(JasperCompileManager.java:126) at it.businesslogic.ireport.IReportCompiler.run(IReportCompiler.java:321) at java.lang.Thread.run(Thread.java:534) To help solve this my SQL statment is below and the XML of the report is blow that. SQL: SELECT DOC.DOCUMENTNUMBER , INVOICELINE.DOCUMENTLINENUMBER , DOCLINE.LINENETAMOUNTAC , DOCLINE.LINEBALANCEAC , INVOICE.NETAMOUNTAC , INVOICE.VATAMOUNTAC , INVOICELINE.REFERENCE , INVOICELINE.SUBREFERENCE , INVOICELINE.TRANSACTIONLINEID , INVOICELINE.LINEVATAMOUNTAC , TRANS.TRANSACTIONTYPEDESCRIPTION , INVOICE.INVOICENUMBER , INVOICE.BPID, DEALER.companyregistrationnumber, DEALER.companyname , FIN.FINANCECOMPANYDESCRIPTION , DOC.POSTINGDATE FROM $P!{FLOORPLANNING_SCHEMA}.ARDOCUMENT DOC , $P!{FLOORPLANNING_SCHEMA}.ARDOCUMENTLINE DOCLINE , $P!{FLOORPLANNING_SCHEMA}.ARINVOICELINE INVOICELINE , $P!{FLOORPLANNING_SCHEMA}.TRANSACTIONTYPE TRANS , $P!{FLOORPLANNING_SCHEMA}.ARINVOICE INVOICE , $P!{FLOORPLANNING_SCHEMA}.BPMASTER DEALER , $P!{FLOORPLANNING_SCHEMA}.FINANCECOMPANY FIN WHERE (DOC.DOCUMENTNUMBER = DOCLINE.DOCUMENTNUMBER) AND (DOCLINE.DOCUMENTNUMBER = INVOICE.DOCUMENTNUMBER) AND (INVOICE.DOCUMENTNUMBER = INVOICELINE.DOCUMENTNUMBER) AND (INVOICE.bpid = DEALER.bpidentifier) AND (INVOICE.TRANSACTIONTYPECODE = TRANS.TRANSACTIONTYPECODE) AND (INVOICE.TRANSACTIONTYPECODE in ('00010', '00020')) AND (DOC.POSTINGDATE = $P!{POSTING_DATE}) XML: <?xml version="1.0" encoding="UTF-8" ?> -  <!DOCTYPE jasperReport (View Source for full doctype...)> - <jasperReport name="InterestReconciliation" columnCount="1" printOrder="Vertical" orientation="Portrait" pageWidth="612" pageHeight="792" columnWidth="535" columnSpacing="0" leftMargin="45" rightMargin="30" topMargin="20" bottomMargin="20" whenNoDataType="NoPages" isTitleNewPage="false" isSummaryNewPage="false"> <property name="ireport.scriptlethandling" value="2" /> - <parameter name="FLOORPLANNING_SCHEMA" isForPrompting="true" class="java.lang.String"> - <defaultValueExpression> - <![CDATA[ "FIN_USA" ]]> </defaultValueExpression> </parameter> - <parameter name="OPENREPORTS_USER_NAME" isForPrompting="false" class="java.lang.String"> - <defaultValueExpression> - <![CDATA[ "BermanT" ]]> </defaultValueExpression> </parameter> - <parameter name="REPORT_TITLE" isForPrompting="false" class="java.lang.String"> - <defaultValueExpression> - <![CDATA[ "Dealer Balances by Supplier" ]]> </defaultValueExpression> </parameter> - <parameter name="ReturnedValuesMap" isForPrompting="true" class="java.util.HashMap"> - <defaultValueExpression> - <![CDATA[ new java.util.HashMap() ]]> </defaultValueExpression> </parameter> - <parameter name="JASPERSUBREPORT" isForPrompting="true" class="java.lang.String"> - <defaultValueExpression> - <![CDATA[ "Subreport2.jasper" ]]> </defaultValueExpression> </parameter> - <parameter name="POSTING_DATE" isForPrompting="false" class="java.util.Date"> - <defaultValueExpression> - <![CDATA[ new java.util.Date(2004,8,31) ]]> </defaultValueExpression> </parameter> - <queryString> - <![CDATA[ SELECT DOC.DOCUMENTNUMBER , INVOICELINE.DOCUMENTLINENUMBER , DOCLINE.LINENETAMOUNTAC , DOCLINE.LINEBALANCEAC , INVOICE.NETAMOUNTAC , INVOICE.VATAMOUNTAC , INVOICELINE.REFERENCE , INVOICELINE.SUBREFERENCE , INVOICELINE.TRANSACTIONLINEID , INVOICELINE.LINEVATAMOUNTAC , TRANS.TRANSACTIONTYPEDESCRIPTION , INVOICE.INVOICENUMBER , INVOICE.BPID, DEALER.companyregistrationnumber, DEALER.companyname , FIN.FINANCECOMPANYDESCRIPTION , DOC.POSTINGDATE FROM $P!{FLOORPLANNING_SCHEMA}.ARDOCUMENT DOC , $P!{FLOORPLANNING_SCHEMA}.ARDOCUMENTLINE DOCLINE , $P!{FLOORPLANNING_SCHEMA}.ARINVOICELINE INVOICELINE , $P!{FLOORPLANNING_SCHEMA}.TRANSACTIONTYPE TRANS , $P!{FLOORPLANNING_SCHEMA}.ARINVOICE INVOICE , $P!{FLOORPLANNING_SCHEMA}.BPMASTER DEALER , $P!{FLOORPLANNING_SCHEMA}.FINANCECOMPANY FIN WHERE (DOC.DOCUMENTNUMBER = DOCLINE.DOCUMENTNUMBER) AND (DOCLINE.DOCUMENTNUMBER = INVOICE.DOCUMENTNUMBER) AND (INVOICE.DOCUMENTNUMBER = INVOICELINE.DOCUMENTNUMBER) AND (INVOICE.bpid = DEALER.bpidentifier) AND (INVOICE.TRANSACTIONTYPECODE = TRANS.TRANSACTIONTYPECODE) AND (INVOICE.TRANSACTIONTYPECODE in ('00010', '00020')) AND (DOC.POSTINGDATE <= sysdate) --AND (DOC.POSTINGDATE <= $P!{POSTING_DATE}) ]]> </queryString> <field name="DOCUMENTNUMBER" class="java.lang.String" /> <field name="DOCUMENTLINENUMBER" class="java.lang.Double" /> <field name="LINENETAMOUNTAC" class="java.lang.Double" /> <field name="LINEBALANCEAC" class="java.lang.Double" /> <field name="NETAMOUNTAC" class="java.lang.Double" /> <field name="VATAMOUNTAC" class="java.lang.Double" /> <field name="REFERENCE" class="java.lang.String" /> <field name="SUBREFERENCE" class="java.lang.String" /> <field name="TRANSACTIONLINEID" class="java.lang.Double" /> <field name="LINEVATAMOUNTAC" class="java.lang.Double" /> <field name="TRANSACTIONTYPEDESCRIPTION" class="java.lang.String" /> <field name="INVOICENUMBER" class="java.lang.String" /> <field name="BPID" class="java.lang.String" /> <field name="COMPANYREGISTRATIONNUMBER" class="java.lang.String" /> <field name="COMPANYNAME" class="java.lang.String" /> <field name="FINANCECOMPANYDESCRIPTION" class="java.lang.String" /> <field name="POSTINGDATE" class="java.util.Date" /> - <variable name="PAGE_TOTAL" class="java.lang.Integer" resetType="Report" calculation="Nothing"> - <variableExpression> - <![CDATA[ $V{PAGE_NUMBER} ]]> </variableExpression> </variable> - <background> <band height="0" isSplitAllowed="true" /> </background> - <title> <band height="0" isSplitAllowed="true" /> </title> - <pageHeader> - <band height="57" isSplitAllowed="true"> - <textField isStretchWithOverflow="false" pattern="MM/dd/yyyy h:mm a" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"> <reportElement mode="Transparent" x="414" y="23" width="121" height="11" forecolor="#000000" backcolor="#FFFFFF" key="element-83" stretchType="NoStretch" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false" /> - <textElement textAlignment="Right" verticalAlignment="Top" rotation="None" lineSpacing="Single" isStyledText="false"> </textElement> - <textFieldExpression class="java.util.Date"> - <![CDATA[ new Date() ]]> </textFieldExpression> </textField> - <textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"> <reportElement mode="Opaque" x="387" y="45" width="148" height="11" forecolor="#000000" backcolor="#FFFFFF" key="element-1" stretchType="NoStretch" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false" /> - <textElement textAlignment="Right" verticalAlignment="Top" rotation="None" lineSpacing="Single" isStyledText="false"> </textElement> - <textFieldExpression class="java.lang.String"> - <![CDATA[ $P{FLOORPLANNING_SCHEMA} ]]> </textFieldExpression> </textField> - <line direction="TopDown"> <reportElement mode="Opaque" x="0" y="44" width="537" height="0" forecolor="#000000" backcolor="#FFFFFF" key="element-97" stretchType="NoStretch" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false" /> <graphicElement stretchType="NoStretch" pen="Thin" fill="Solid" /> </line> - <textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Report" hyperlinkType="None"> <reportElement mode="Opaque" x="0" y="0" width="424" height="20" forecolor="#009999" backcolor="#FFFFFF" key="textField-1" stretchType="NoStretch" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false" /> - <textElement textAlignment="Left" verticalAlignment="Top" rotation="None" lineSpacing="Single" isStyledText="false"> </textElement> - <textFieldExpression class="java.lang.String"> - <![CDATA[ $P{REPORT_TITLE} ]]> </textFieldExpression> </textField> - <textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"> <reportElement mode="Opaque" x="0" y="23" width="230" height="11" forecolor="#000000" backcolor="#FFFFFF" key="textField" stretchType="NoStretch" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false" /> - <textElement textAlignment="Left" verticalAlignment="Top" rotation="None" lineSpacing="Single" isStyledText="false"> </textElement> - <textFieldExpression class="java.lang.String"> - <![CDATA[ $F{FINANCECOMPANYDESCRIPTION} ]]> </textFieldExpression> </textField> - <staticText> <reportElement mode="Opaque" x="0" y="34" width="48" height="10" forecolor="#000000" backcolor="#FFFFFF" key="staticText-5" stretchType="NoStretch" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false" /> - <textElement textAlignment="Left" verticalAlignment="Top" rotation="None" lineSpacing="Single" isStyledText="false"> </textElement> - <text> - <![CDATA[ Posting Date ]]> </text> </staticText> - <textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"> <reportElement mode="Opaque" x="48" y="34" width="100" height="10" forecolor="#000000" backcolor="#FFFFFF" key="textField" stretchType="NoStretch" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false" /> - <textElement textAlignment="Left" verticalAlignment="Top" rotation="None" lineSpacing="Single" isStyledText="false"> </textElement> - <textFieldExpression class="java.util.Date"> - <![CDATA[ $P{POSTING_DATE} ]]> </textFieldExpression> </textField> </band> </pageHeader> - <columnHeader> - <band height="17" isSplitAllowed="true"> - <staticText> <reportElement mode="Opaque" x="0" y="0" width="197" height="10" forecolor="#000000" backcolor="#FFFFFF" key="staticText-3" stretchType="NoStretch" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false" /> - <textElement textAlignment="Left" verticalAlignment="Top" rotation="None" lineSpacing="Single" isStyledText="false"> </textElement> - <text> - <![CDATA[ Column Headers ]]> </text> </staticText> - <line direction="TopDown"> <reportElement mode="Opaque" x="0" y="16" width="537" height="0" forecolor="#000000" backcolor="#FFFFFF" key="line-1" stretchType="NoStretch" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false" /> <graphicElement stretchType="NoStretch" pen="Thin" fill="Solid" /> </line> </band> </columnHeader> - <detail> - <band height="11" isSplitAllowed="true"> - <rectangle radius="0"> - <reportElement mode="Opaque" x="0" y="0" width="537" height="11" forecolor="#000000" backcolor="#CCCCCC" key="rectangle-1" stretchType="NoStretch" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"> - <printWhenExpression> - <![CDATA[ $V{REPORT_COUNT}.intValue() % 2 == 1 ? Boolean.TRUE : Boolean.FALSE ]]> </printWhenExpression> </reportElement> <graphicElement stretchType="NoStretch" pen="None" fill="Solid" /> </rectangle> - <staticText> <reportElement mode="Transparent" x="0" y="0" width="145" height="10" forecolor="#000000" backcolor="#FFFFFF" key="staticText-4" stretchType="NoStretch" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false" /> - <textElement textAlignment="Left" verticalAlignment="Top" rotation="None" lineSpacing="Single" isStyledText="false"> </textElement> - <text> - <![CDATA[ Details ]]> </text> </staticText> - <textField isStretchWithOverflow="false" pattern="MM/dd/yyyy" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"> <reportElement mode="Transparent" x="159" y="0" width="100" height="10" forecolor="#000000" backcolor="#FFFFFF" key="textField" stretchType="NoStretch" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false" /> - <textElement textAlignment="Left" verticalAlignment="Top" rotation="None" lineSpacing="Single" isStyledText="false"> </textElement> - <textFieldExpression class="java.util.Date"> - <![CDATA[ $F{POSTINGDATE} ]]> </textFieldExpression> </textField> </band> </detail> - <columnFooter> <band height="0" isSplitAllowed="true" /> </columnFooter> - <pageFooter> - <band height="31" isSplitAllowed="true"> - <textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"> <reportElement mode="Opaque" x="0" y="11" width="263" height="11" forecolor="#000000" backcolor="#FFFFFF" key="element-1" stretchType="NoStretch" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false" /> - <textElement textAlignment="Left" verticalAlignment="Top" rotation="None" lineSpacing="Single" isStyledText="false"> </textElement> - <textFieldExpression class="java.lang.String"> - <![CDATA[ "Printed by: " + $P{OPENREPORTS_USER_NAME} ]]> </textFieldExpression> </textField> - <textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"> <reportElement mode="Opaque" x="420" y="11" width="115" height="11" forecolor="#000000" backcolor="#FFFFFF" key="element-56" stretchType="NoStretch" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false" /> - <textElement textAlignment="Right" verticalAlignment="Top" rotation="None" lineSpacing="Single" isStyledText="false"> </textElement> - <textFieldExpression class="java.lang.String"> - <![CDATA[ $V{PAGE_NUMBER} + "/" + $V{PAGE_TOTAL} ]]> </textFieldExpression> </textField> - <line direction="TopDown"> <reportElement mode="Opaque" x="0" y="5" width="537" height="0" forecolor="#000000" backcolor="#FFFFFF" key="line-1" stretchType="NoStretch" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false" /> <graphicElement stretchType="NoStretch" pen="Thin" fill="Solid" /> </line> - <line direction="TopDown"> <reportElement mode="Opaque" x="0" y="26" width="537" height="0" forecolor="#000000" backcolor="#FFFFFF" key="line-1" stretchType="NoStretch" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false" /> <graphicElement stretchType="NoStretch" pen="Thin" fill="Solid" /> </line> </band> </pageFooter> - <summary> - <band height="0" isSplitAllowed="true"> - <textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"> <reportElement mode="Opaque" x="232" y="126" width="0" height="0" forecolor="#000000" backcolor="#FFFFFF" key="textField-2" stretchType="NoStretch" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false" /> - <textElement textAlignment="Left" verticalAlignment="Top" rotation="None" lineSpacing="Single" isStyledText="false"> </textElement> - <textFieldExpression class="java.lang.String"> - <![CDATA[ $F{Field} ]]> </textFieldExpression> </textField> </band> </summary> </jasperReport> By: Todd - tberman333 RE: Date Paramters - Pls ignore previous post 2004-09-02 11:56 I found the issue that was causing the strange error messages in my previous post... Anyway, I am still having problems with the date parameter. When I attempt to compile my report now I am getting the following error message: Compiling to file... C:iReports Outputaacintrec.jasper -> C:iReports OutputInterestReconciliation.java Compilation running time : 2314 Filling report... Error filling print... java.sql.SQLException: ORA-00933: SQL command not properly ended at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134) at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289) at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:579) at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1894) at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteDescribe(TTC7Protocol.java:831) at oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:2496) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2840) at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:608) at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:536) at dori.jasper.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:466) at dori.jasper.engine.fill.JRFiller.fillReport(JRFiller.java:120) at dori.jasper.engine.JasperFillManager.fillReport(JasperFillManager.java:222) at dori.jasper.engine.JasperFillManager.fillReport(JasperFillManager.java:162) at it.businesslogic.ireport.IReportCompiler.run(IReportCompiler.java:415) at java.lang.Thread.run(Thread.java:534) NESTED BY : java.sql.SQLException: ORA-00933: SQL command not properly ended at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134) at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289) at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:579) at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1894) at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteDescribe(TTC7Protocol.java:831) at oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:2496) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2840) at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:608) at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:536) at dori.jasper.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:466) at dori.jasper.engine.fill.JRFiller.fillReport(JRFiller.java:120) at dori.jasper.engine.JasperFillManager.fillReport(JasperFillManager.java:222) at dori.jasper.engine.JasperFillManager.fillReport(JasperFillManager.java:162) at it.businesslogic.ireport.IReportCompiler.run(IReportCompiler.java:415) at java.lang.Thread.run(Thread.java:534) NESTED BY : dori.jasper.engine.JRException: Error executing SQL statement for report : InterestReconciliation at dori.jasper.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:475) at dori.jasper.engine.fill.JRFiller.fillReport(JRFiller.java:120) at dori.jasper.engine.JasperFillManager.fillReport(JasperFillManager.java:222) at dori.jasper.engine.JasperFillManager.fillReport(JasperFillManager.java:162) at it.businesslogic.ireport.IReportCompiler.run(IReportCompiler.java:415) at java.lang.Thread.run(Thread.java:534) Caused by: java.sql.SQLException: ORA-00933: SQL command not properly ended at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134) at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289) at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:579) at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1894) at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteDescribe(TTC7Protocol.java:831) at oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:2496) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2840) at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:608) at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:536) at dori.jasper.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:466) ... 5 more Print not filled. Try to use an EmptyDataSource...! My XML looks like this: <?xml version="1.0" encoding="UTF-8" ?>  <!DOCTYPE jasperReport PUBLIC "//JasperReports//DTD Report Design//EN" "http://jasperreports.sourceforge.net/dtds/jasperreport.dtd"> <jasperReport name="InterestReconciliation" columnCount="1" printOrder="Vertical" orientation="Portrait" pageWidth="612" pageHeight="792" columnWidth="535" columnSpacing="0" leftMargin="45" rightMargin="30" topMargin="20" bottomMargin="20" whenNoDataType="NoPages" isTitleNewPage="false" isSummaryNewPage="false"> <property name="ireport.scriptlethandling" value="2" /> <parameter name="FLOORPLANNING_SCHEMA" isForPrompting="true" class="java.lang.String"> <defaultValueExpression ><![CDATA["FIN_USA"]]></defaultValueExpression> </parameter> <parameter name="OPENREPORTS_USER_NAME" isForPrompting="false" class="java.lang.String"> <defaultValueExpression ><![CDATA["BermanT"]]></defaultValueExpression> </parameter> <parameter name="REPORT_TITLE" isForPrompting="false" class="java.lang.String"> <defaultValueExpression ><![CDATA["Dealer Balances by Supplier" ]]></defaultValueExpression> </parameter> <parameter name="ReturnedValuesMap" isForPrompting="true" class="java.util.HashMap"> <defaultValueExpression ><![CDATA[new java.util.HashMap()]]></defaultValueExpression> </parameter> <parameter name="JASPERSUBREPORT" isForPrompting="true" class="java.lang.String"> <defaultValueExpression ><![CDATA["Subreport2.jasper"]]></defaultValueExpression> </parameter> <parameter name="POSTING_DATE" isForPrompting="false" class="java.util.Date"> <defaultValueExpression ><![CDATA[new java.util.Date(104,8,31)]]></defaultValueExpression> </parameter> <queryString><![CDATA[sELECT DOC.DOCUMENTNUMBER , INVOICELINE.DOCUMENTLINENUMBER , DOCLINE.LINENETAMOUNTAC , DOCLINE.LINEBALANCEAC , INVOICE.NETAMOUNTAC , INVOICE.VATAMOUNTAC , INVOICELINE.REFERENCE , INVOICELINE.SUBREFERENCE , INVOICELINE.TRANSACTIONLINEID , INVOICELINE.LINEVATAMOUNTAC , TRANS.TRANSACTIONTYPEDESCRIPTION , INVOICE.INVOICENUMBER , INVOICE.BPID, DEALER.companyregistrationnumber, DEALER.companyname , FIN.FINANCECOMPANYDESCRIPTION , DOC.POSTINGDATE FROM $P!{FLOORPLANNING_SCHEMA}.ARDOCUMENT DOC , $P!{FLOORPLANNING_SCHEMA}.ARDOCUMENTLINE DOCLINE , $P!{FLOORPLANNING_SCHEMA}.ARINVOICELINE INVOICELINE , $P!{FLOORPLANNING_SCHEMA}.TRANSACTIONTYPE TRANS , $P!{FLOORPLANNING_SCHEMA}.ARINVOICE INVOICE , $P!{FLOORPLANNING_SCHEMA}.BPMASTER DEALER , $P!{FLOORPLANNING_SCHEMA}.FINANCECOMPANY FIN WHERE DOC.DOCUMENTNUMBER = DOCLINE.DOCUMENTNUMBER AND DOCLINE.DOCUMENTNUMBER = INVOICE.DOCUMENTNUMBER AND INVOICE.DOCUMENTNUMBER = INVOICELINE.DOCUMENTNUMBER AND INVOICE.bpid = DEALER.bpidentifier AND INVOICE.TRANSACTIONTYPECODE = TRANS.TRANSACTIONTYPECODE AND INVOICE.TRANSACTIONTYPECODE in ('00010', '00020') AND DOC.POSTINGDATE <= $P!{POSTING_DATE}]]></queryString> <field name="DOCUMENTNUMBER" class="java.lang.String"/> <field name="DOCUMENTLINENUMBER" class="java.lang.Double"/> <field name="LINENETAMOUNTAC" class="java.lang.Double"/> <field name="LINEBALANCEAC" class="java.lang.Double"/> <field name="NETAMOUNTAC" class="java.lang.Double"/> <field name="VATAMOUNTAC" class="java.lang.Double"/> <field name="REFERENCE" class="java.lang.String"/> <field name="SUBREFERENCE" class="java.lang.String"/> <field name="TRANSACTIONLINEID" class="java.lang.Double"/> <field name="LINEVATAMOUNTAC" class="java.lang.Double"/> <field name="TRANSACTIONTYPEDESCRIPTION" class="java.lang.String"/> <field name="INVOICENUMBER" class="java.lang.String"/> <field name="BPID" class="java.lang.String"/> <field name="COMPANYREGISTRATIONNUMBER" class="java.lang.String"/> <field name="COMPANYNAME" class="java.lang.String"/> <field name="FINANCECOMPANYDESCRIPTION" class="java.lang.String"/> <field name="POSTINGDATE" class="java.util.Date"/> <variable name="PAGE_TOTAL" class="java.lang.Integer" resetType="Report" calculation="Nothing"> <variableExpression><![CDATA[$V{PAGE_NUMBER}]]></variableExpression> </variable> <background> <band height="0" isSplitAllowed="true" > </band> </background> <title> <band height="0" isSplitAllowed="true" > </band> </title> <pageHeader> <band height="57" isSplitAllowed="true" > <textField isStretchWithOverflow="false" pattern="MM/dd/yyyy h:mm a" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" > <reportElement mode="Transparent" x="414" y="23" width="121" height="11" forecolor="#000000" backcolor="#FFFFFF" key="element-83" stretchType="NoStretch" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Right" verticalAlignment="Top" rotation="None" lineSpacing="Single"> </textElement> <textFieldExpression class="java.util.Date"><![CDATA[new Date()]]></textFieldExpression> </textField> <textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" > <reportElement mode="Opaque" x="387" y="45" width="148" height="11" forecolor="#000000" backcolor="#FFFFFF" key="element-1" stretchType="NoStretch" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Right" verticalAlignment="Top" rotation="None" lineSpacing="Single"> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$P{FLOORPLANNING_SCHEMA}]]></textFieldExpression> </textField> <line direction="TopDown"> <reportElement mode="Opaque" x="0" y="44" width="537" height="0" forecolor="#000000" backcolor="#FFFFFF" key="element-97" stretchType="NoStretch" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <graphicElement stretchType="NoStretch" pen="Thin" fill="Solid" /> </line> <textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Report" hyperlinkType="None" > <reportElement mode="Opaque" x="0" y="0" width="424" height="20" forecolor="#009999" backcolor="#FFFFFF" key="textField-1" stretchType="NoStretch" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Left" verticalAlignment="Top" rotation="None" lineSpacing="Single"> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$P{REPORT_TITLE}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" > <reportElement mode="Opaque" x="0" y="23" width="230" height="11" forecolor="#000000" backcolor="#FFFFFF" key="textField" stretchType="NoStretch" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Left" verticalAlignment="Top" rotation="None" lineSpacing="Single"> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$F{FINANCECOMPANYDESCRIPTION}]]></textFieldExpression> </textField> <staticText> <reportElement mode="Opaque" x="0" y="34" width="52" height="10" forecolor="#000000" backcolor="#FFFFFF" key="staticText-5" stretchType="NoStretch" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Left" verticalAlignment="Top" rotation="None" lineSpacing="Single"> </textElement> <text><![CDATA[Posting Date :]]></text> </staticText> <textField isStretchWithOverflow="false" pattern="MM/dd/yyyy" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" > <reportElement mode="Opaque" x="52" y="34" width="100" height="10" forecolor="#000000" backcolor="#FFFFFF" key="textField" stretchType="NoStretch" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Left" verticalAlignment="Top" rotation="None" lineSpacing="Single"> </textElement> <textFieldExpression class="java.util.Date"><![CDATA[$P{POSTING_DATE}]]></textFieldExpression> </textField> </band> </pageHeader> <columnHeader> <band height="17" isSplitAllowed="true" > <staticText> <reportElement mode="Opaque" x="0" y="0" width="197" height="10" forecolor="#000000" backcolor="#FFFFFF" key="staticText-3" stretchType="NoStretch" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Left" verticalAlignment="Top" rotation="None" lineSpacing="Single"> </textElement> <text><![CDATA[Column Headers]]></text> </staticText> <line direction="TopDown"> <reportElement mode="Opaque" x="0" y="16" width="537" height="0" forecolor="#000000" backcolor="#FFFFFF" key="line-1" stretchType="NoStretch" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <graphicElement stretchType="NoStretch" pen="Thin" fill="Solid" /> </line> </band> </columnHeader> <detail> <band height="11" isSplitAllowed="true" > <rectangle radius="0" > <reportElement mode="Opaque" x="0" y="0" width="537" height="11" forecolor="#000000" backcolor="#CCCCCC" key="rectangle-1" stretchType="NoStretch" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"> <printWhenExpression><![CDATA[$V{REPORT_COUNT}.intValue() % 2 == 1 ? Boolean.TRUE : Boolean.FALSE]]></printWhenExpression> </reportElement> <graphicElement stretchType="NoStretch" pen="None" fill="Solid" /> </rectangle> <staticText> <reportElement mode="Transparent" x="0" y="0" width="145" height="10" forecolor="#000000" backcolor="#FFFFFF" key="staticText-4" stretchType="NoStretch" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Left" verticalAlignment="Top" rotation="None" lineSpacing="Single"> </textElement> <text><![CDATA[Details]]></text> </staticText> <textField isStretchWithOverflow="false" pattern="MM/dd/yyyy" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" > <reportElement mode="Transparent" x="159" y="0" width="100" height="10" forecolor="#000000" backcolor="#FFFFFF" key="textField" stretchType="NoStretch" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Left" verticalAlignment="Top" rotation="None" lineSpacing="Single"> </textElement> <textFieldExpression class="java.util.Date"><![CDATA[$F{POSTINGDATE}]]></textFieldExpression> </textField> </band> </detail> <columnFooter> <band height="0" isSplitAllowed="true" > </band> </columnFooter> <pageFooter> <band height="31" isSplitAllowed="true" > <textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" > <reportElement mode="Opaque" x="0" y="11" width="263" height="11" forecolor="#000000" backcolor="#FFFFFF" key="element-1" stretchType="NoStretch" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Left" verticalAlignment="Top" rotation="None" lineSpacing="Single"> </textElement> <textFieldExpression class="java.lang.String"><![CDATA["Printed by: " + $P{OPENREPORTS_USER_NAME}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" > <reportElement mode="Opaque" x="420" y="11" width="115" height="11" forecolor="#000000" backcolor="#FFFFFF" key="element-56" stretchType="NoStretch" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Right" verticalAlignment="Top" rotation="None" lineSpacing="Single"> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$V{PAGE_NUMBER} + "/" + $V{PAGE_TOTAL}]]></textFieldExpression> </textField> <line direction="TopDown"> <reportElement mode="Opaque" x="0" y="5" width="537" height="0" forecolor="#000000" backcolor="#FFFFFF" key="line-1" stretchType="NoStretch" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <graphicElement stretchType="NoStretch" pen="Thin" fill="Solid" /> </line> <line direction="TopDown"> <reportElement mode="Opaque" x="0" y="26" width="537" height="0" forecolor="#000000" backcolor="#FFFFFF" key="line-1" stre
- September 12, 2006
- - iReport Designer
Upgrade problems iReport 0.2.2 to 0.2.3

2004 IR Help posted a topic in Products

By: Neil Lamka - neil_lamka Upgrade problems iReport 0.2.2 to 0.2.3 2004-03-04 18:46 I just tried to upgrade to iReport 0.2.3 on Win/XP. iRepor 0.2.2 was working find but thought I'd try the new version hoping for a better UI experience. What I have found is... on startup I get a series of the following sets of messages tttjavax.swing.JMenuItem[,0,0,0x0,invalid,alignmentX=null,alignmentY=null,border =javax.swing.border.EmptyBorder@1eef2c,flags=264,maximumSize=,minimumSize=,prefe rredSize=,defaultIcon=,disabledIcon=,disabledSelectedIcon=,margin=javax.swing.pl af.InsetsUIResource[top=2,left=2,bottom=2,right=2],paintBorder=true,paintFocus=f alse,pressedIcon=,rolloverEnabled=false,rolloverIcon=,rolloverSelectedIcon=,sele ctedIcon=,text=1. D:Documents and Settings...WeeklyTimeSheet.xml] These occure for a group of reports files and I have no idea what they mean. I then tried to open a report that works correctly in iReport 0.2.2. The report opens but if (without change) I try to compile it I get.. Errors compiling D:Documents and SettingsNeil Lamka.ireportScheduleExpressLA CountyMySchedule.jasper! Mar 4, 2004 3:53:53 PM org.apache.commons.digester.Digester fatalError SEVERE: Parse Fatal Error at line 22 column 16: The element type "parameter" must be terminated by the matching end-tag "</parameter>". org.xml.sax.SAXParseException: The element type "parameter" must be terminated by the matching end-tag "</parameter>". at org.apache.xerces.util.ErrorHandlerWrapper.createSAXParseException(Unknown Source) at org.apache.xerces.util.ErrorHandlerWrapper.fatalError(Unknown Source) at org.apache.xerces.impl.XMLErrorReporter.reportError(Unknown Source) at org.apache.xerces.impl.XMLErrorReporter.reportError(Unknown Source) at org.apache.xerces.impl.XMLScanner.reportFatalError(Unknown Source) at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanEndElement(Unknown Source) at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl$FragmentContentDispatcher.dispatch(Unknown Source) at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown Source) at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source) at org.apache.xerces.parsers.DTDConfiguration.parse(Unknown Source) at org.apache.xerces.parsers.XMLParser.parse(Unknown Source) at org.apache.xerces.parsers.AbstractSAXParser.parse(Unknown Source) at org.apache.commons.digester.Digester.parse(Digester.java:1514) at dori.jasper.engine.xml.JRXmlLoader.loadXML(JRXmlLoader.java:373) at dori.jasper.engine.xml.JRXmlLoader.load(JRXmlLoader.java:357) at dori.jasper.engine.xml.JRXmlLoader.load(JRXmlLoader.java:337) at dori.jasper.engine.xml.JRXmlLoader.load(JRXmlLoader.java:323) at dori.jasper.engine.JasperCompileManager.compileReportToFile(JasperCompileManager.java:121) at it.businesslogic.ireport.IReportCompiler.run(IReportCompiler.java:148) at java.lang.Thread.run(Unknown Source) org.xml.sax.SAXParseException: The element type "parameter" must be terminated by the matching end-tag "</parameter>". at org.apache.xerces.parsers.AbstractSAXParser.parse(Unknown Source) at org.apache.commons.digester.Digester.parse(Digester.java:1514) at dori.jasper.engine.xml.JRXmlLoader.loadXML(JRXmlLoader.java:373) at dori.jasper.engine.xml.JRXmlLoader.load(JRXmlLoader.java:357) at dori.jasper.engine.xml.JRXmlLoader.load(JRXmlLoader.java:337) at dori.jasper.engine.xml.JRXmlLoader.load(JRXmlLoader.java:323) at dori.jasper.engine.JasperCompileManager.compileReportToFile(JasperCompileManager.java:121) at it.businesslogic.ireport.IReportCompiler.run(IReportCompiler.java:148) at java.lang.Thread.run(Unknown Source) NESTED BY : dori.jasper.engine.JRException: The element type "parameter" must be terminated by the matching end-tag "</parameter>". at dori.jasper.engine.xml.JRXmlLoader.loadXML(JRXmlLoader.java:381) at dori.jasper.engine.xml.JRXmlLoader.load(JRXmlLoader.java:357) at dori.jasper.engine.xml.JRXmlLoader.load(JRXmlLoader.java:337) at dori.jasper.engine.xml.JRXmlLoader.load(JRXmlLoader.java:323) at dori.jasper.engine.JasperCompileManager.compileReportToFile(JasperCompileManager.java:121) at it.businesslogic.ireport.IReportCompiler.run(IReportCompiler.java:148) at java.lang.Thread.run(Unknown Source) Caused by: org.xml.sax.SAXParseException: The element type "parameter" must be terminated by the matching end-tag "</parameter>". at org.apache.xerces.parsers.AbstractSAXParser.parse(Unknown Source) at org.apache.commons.digester.Digester.parse(Digester.java:1514) at dori.jasper.engine.xml.JRXmlLoader.loadXML(JRXmlLoader.java:373) ... 6 more Compilation running time : 1081 At this point, the original .xml file has been totally trashed and is not usable by either 0.2.3 or 0.2.2. I'm not sure what the issue is. What I did was download the 0.2.3 zip file with libs, unzipped the code to a new iReports directory and started it as I had done with earier versions of iReports. I'm using the Sun 1.4.2_02 JVM. I must be missing something on the install..but not sure what. Any pointers or suggestoins would be useful. Thanks Neil By: Kees Kuip - keeskuip RE: Upgrade problems iReport 0.2.2 to 0.2.3 2004-03-04 23:32 Could you post the some lines from your report ? The parser says to look at line 22 column 16. Kees By: Neil Lamka - neil_lamka RE: Upgrade problems iReport 0.2.2 to 0.2.3 2004-03-05 11:38 Ok. I will post the report before opening it in 0.2.3 and then after it is trashed. All I did between the 2 was open the working 0.2.2 report and do a compile which generated the exceptions I noted and saved the "After" version ... sorry for the long post but thought it best to try and be complete. The first difference is around the first parameter definition "Users key:". ****************** BEFORE ************* <?xml version="1.0" encoding="UTF-8" ?>  <!DOCTYPE jasperReport PUBLIC "//JasperReports//DTD Report Design//EN" "http://jasperreports.sourceforge.net/dtds/jasperreport.dtd"> <jasperReport name="MySchedule" columnCount="1" printOrder="Vertical" orientation="Portrait" pageWidth="595" pageHeight="842" columnWidth="535" columnSpacing="0" leftMargin="30" rightMargin="30" topMargin="20" bottomMargin="20" whenNoDataType="AllSectionsNoDetail" isTitleNewPage="false" isSummaryNewPage="false"> <parameter name="se_upk" isForPrompting="true" class="java.lang.String"> <parameterDescription><![CDATA[users key:]]></parameterDescription> </parameter> <parameter name="se_date_start" isForPrompting="true" class="java.lang.String"> <parameterDescription><![CDATA[schedule from:]]></parameterDescription> </parameter> <parameter name="se_date_end" isForPrompting="true" class="java.lang.String"> <parameterDescription><![CDATA[To:]]></parameterDescription> </parameter> <queryString><![CDATA[select to_char( timezone('GMT',(secs_gmt)::int4::abstime), 'Dy') as dayoftheweek, * from t_day_ref LEFT JOIN ( select * from v_schedule_details where (user_pk=$P{se_upk}) AND (isschedulepublished='true') ) as a ON t_day_ref.day_str = itemstartday where secs_gmt between (cast($P{se_date_start} as int8)/1000) and ((cast($P{se_date_end} as int8)+ 86399999)/1000) order by day_str ;]]></queryString> <field name="scheduleid" class="java.lang.String"/> <field name="isschedulepublished" class="java.lang.Boolean"/> <field name="tradeacceptdeleted" class="java.lang.Boolean"/> <field name="tradedeleted" class="java.lang.Boolean"/> <field name="absencedeleted" class="java.lang.Boolean"/> <field name="tradeacptshift" class="java.lang.String"/> <field name="tradeacptnote" class="java.lang.String"/> <field name="tradeacceptendtime" class="java.lang.String"/> <field name="tradeacceptendday" class="java.lang.String"/> <field name="tradeacptend" class="java.lang.Long"/> <field name="tradeacceptstarttime" class="java.lang.String"/> <field name="tradeacceptstartday" class="java.lang.String"/> <field name="tradeacptstart" class="java.lang.Long"/> <field name="tradeacptemployeeid" class="java.lang.String"/> <field name="tradeacptlastname" class="java.lang.String"/> <field name="tradeacptfirstname" class="java.lang.String"/> <field name="tradeshift" class="java.lang.String"/> <field name="tradedeclinereason" class="java.lang.String"/> <field name="tradeendtime" class="java.lang.String"/> <field name="tradeendday" class="java.lang.String"/> <field name="tradeend" class="java.lang.Long"/> <field name="tradestarttime" class="java.lang.String"/> <field name="tradestartday" class="java.lang.String"/> <field name="tradestart" class="java.lang.Long"/> <field name="tradestatus" class="java.lang.String"/> <field name="overtimeasgnemployeeid" class="java.lang.String"/> <field name="overtimeasgnlastname" class="java.lang.String"/> <field name="overtimeasgnfirstname" class="java.lang.String"/> <field name="overtimetimeslot" class="java.lang.String"/> <field name="overtimenote" class="java.lang.String"/> <field name="overtimeendtime" class="java.lang.String"/> <field name="overtimeendday" class="java.lang.String"/> <field name="overtimeend" class="java.lang.Long"/> <field name="overtimestarttime" class="java.lang.String"/> <field name="overtimestartday" class="java.lang.String"/> <field name="overtimestart" class="java.lang.Long"/> <field name="overtimestatus" class="java.lang.String"/> <field name="istelephonicabsence" class="java.lang.Boolean"/> <field name="absencecaller" class="java.lang.String"/> <field name="absencereviewedendtime" class="java.lang.String"/> <field name="absencereviewedendday" class="java.lang.String"/> <field name="absencerevtime" class="java.lang.Long"/> <field name="absenceappremployeeid" class="java.lang.String"/> <field name="absenceapprlastname" class="java.lang.String"/> <field name="absenceapprfirstname" class="java.lang.String"/> <field name="absencetotaldays" class="java.lang.Double"/> <field name="absencedays" class="java.lang.String"/> <field name="absencetotalhours" class="java.lang.Double"/> <field name="absencehours" class="java.lang.String"/> <field name="absencecontact" class="java.lang.String"/> <field name="bcontact" class="java.lang.Boolean"/> <field name="absencesupnote" class="java.lang.String"/> <field name="absencedeclinereason" class="java.lang.String"/> <field name="absencenote" class="java.lang.String"/> <field name="absencekey" class="java.lang.String"/> <field name="absencestatus" class="java.lang.String"/> <field name="absenceendtime" class="java.lang.String"/> <field name="absenceendday" class="java.lang.String"/> <field name="absenceend" class="java.lang.Long"/> <field name="absencestarttime" class="java.lang.String"/> <field name="absencestartday" class="java.lang.String"/> <field name="absencestart" class="java.lang.Long"/> <field name="mannethours" class="java.lang.Long"/> <field name="manendtimeafter" class="java.lang.String"/> <field name="manenddayafter" class="java.lang.String"/> <field name="manendafter" class="java.lang.Long"/> <field name="manstarttimeafter" class="java.lang.String"/> <field name="manstartdayafter" class="java.lang.String"/> <field name="manstartafter" class="java.lang.Long"/> <field name="manendtimebefore" class="java.lang.String"/> <field name="manenddaybefore" class="java.lang.String"/> <field name="manendbefore" class="java.lang.Long"/> <field name="manstarttimebefore" class="java.lang.String"/> <field name="manstartdaybefore" class="java.lang.String"/> <field name="manstartbefore" class="java.lang.Long"/> <field name="manualsupnotes" class="java.lang.String"/> <field name="manualabsdesc" class="java.lang.String"/> <field name="manualabscode" class="java.lang.String"/> <field name="manualcode" class="java.lang.String"/> <field name="manualchangeid" class="java.lang.String"/> <field name="changekey" class="java.lang.String"/> <field name="changemode" class="java.lang.String"/> <field name="itemactive" class="java.lang.Boolean"/> <field name="itemstartdow" class="java.lang.String"/> <field name="itemhours" class="java.lang.Double"/> <field name="itemendtime" class="java.lang.String"/> <field name="itemendday" class="java.lang.String"/> <field name="itemend" class="java.lang.Long"/> <field name="itemstarttime" class="java.lang.String"/> <field name="itemstartday" class="java.lang.String"/> <field name="itemstart" class="java.lang.Long"/> <field name="categorydesc" class="java.lang.String"/> <field name="categoryid" class="java.lang.String"/> <field name="groupdesc" class="java.lang.String"/> <field name="groupid" class="java.lang.String"/> <field name="usrdateofassignment" class="java.lang.Long"/> <field name="usrdateofhire" class="java.lang.Long"/> <field name="isuseractive" class="java.lang.Boolean"/> <field name="usrpaycode" class="java.lang.String"/> <field name="usremployeeid" class="java.lang.String"/> <field name="usrlastname" class="java.lang.String"/> <field name="usrfirstname" class="java.lang.String"/> <field name="customer_id" class="java.lang.String"/> <field name="user_pk" class="java.lang.String"/> <field name="schedule_items_pk" class="java.lang.String"/> <field name="day_str" class="java.lang.String"/> <field name="secs_gmt" class="java.lang.Integer"/> <field name="secs" class="java.lang.Integer"/> <field name="day" class="java.sql.Timestamp"/> <field name="dayoftheweek" class="java.lang.String"/> <variable name="test" class="java.lang.String" resetType="None" calculation="Nothing"> <variableExpression><![CDATA["test"]]></variableExpression> <initialValueExpression><![CDATA["test" ]]></initialValueExpression> </variable> <variable name="IsManual" class="java.lang.Boolean" resetType="Report" calculation="Nothing"> <variableExpression><![CDATA[(Boolean.valueOf($F{changemode}.equalsIgnoreCase("Manual")))]]></variableExpression> <initialValueExpression><![CDATA[boolean.valueOf("False")]]></initialValueExpression> </variable> <variable name="IsOvertime" class="java.lang.Boolean" resetType="Report" calculation="Nothing"> <variableExpression><![CDATA[(Boolean.valueOf($F{changemode}.equalsIgnoreCase("Overtime")))]]></variableExpression> </variable> <variable name="IsTrade" class="java.lang.Boolean" resetType="Report" calculation="Nothing"> <variableExpression><![CDATA[boolean.valueOf( ($F{changemode}.equalsIgnoreCase("Trade")) && Boolean.FALSE.equals($F{tradedeleted}) && Boolean.FALSE.equals($F{tradeacceptdeleted}) )]]></variableExpression> </variable> <variable name="IsAbsence" class="java.lang.Boolean" resetType="Report" calculation="Nothing"> <variableExpression><![CDATA[(Boolean.valueOf($F{changemode}.equalsIgnoreCase("Absence")))]]></variableExpression> </variable> <variable name="IsBlank" class="java.lang.Boolean" resetType="Report" calculation="Nothing"> <variableExpression><![CDATA[boolean.valueOf(null == $F{schedule_items_pk})]]></variableExpression> </variable> <variable name="MsPerDay" class="java.lang.Long" resetType="None" calculation="Nothing"> <initialValueExpression><![CDATA[new java.lang.Long(86400000) ]]></initialValueExpression> </variable> <variable name="EndOfDay" class="java.lang.String" resetType="None" calculation="Nothing"> <variableExpression><![CDATA[new java.lang.Long(86399999+ java.lang.Long.parseLong($P{se_date_end}) ).toString()]]></variableExpression> </variable> <variable name="ReportLocation" class="java.lang.String" resetType="None" calculation="Nothing"> <variableExpression><![CDATA[$V{ReportLocationRemote}]]></variableExpression> </variable> <variable name="lstart" class="java.lang.Long" resetType="None" calculation="Nothing"> <variableExpression><![CDATA[new java.lang.Long($P{se_date_start})]]></variableExpression> </variable> <variable name="lend" class="java.lang.Long" resetType="None" calculation="Nothing"> <variableExpression><![CDATA[new java.lang.Long($P{se_date_end})]]></variableExpression> </variable> <variable name="lastname" class="java.lang.String" resetType="None" calculation="Nothing"> <variableExpression><![CDATA[null==$F{usrlastname}?$V{lastname}:$F{usrlastname}]]></variableExpression> <initialValueExpression><![CDATA[""]]></initialValueExpression> </variable> <variable name="firstname" class="java.lang.String" resetType="None" calculation="Nothing"> <variableExpression><![CDATA[null==$F{usrfirstname}?$V{firstname}:$F{usrfirstname}]]></variableExpression> <initialValueExpression><![CDATA[""]]></initialValueExpression> </variable> <variable name="thegroup" class="java.lang.String" resetType="None" calculation="Nothing"> <variableExpression><![CDATA[null==$F{groupid}?$V{thegroup}:$F{groupid}]]></variableExpression> <initialValueExpression><![CDATA[""]]></initialValueExpression> </variable> <variable name="ReportLocationRemote" class="java.lang.String" resetType="None" calculation="Nothing"> <variableExpression><![CDATA["/opt/report/bin/"]]></variableExpression> </variable> <variable name="ReportLocationLocal" class="java.lang.String" resetType="None" calculation="Nothing"> <variableExpression><![CDATA["D:\Documents and Settings\Neil Lamka\.ireport\ScheduleExpress\LA County\"]]></variableExpression> </variable> <group name="DetailGroup" isStartNewColumn="false" isStartNewPage="false" isResetPageNumber="false" isReprintHeaderOnEachPage="false" minHeightToStartNewPage="0" > <groupExpression><![CDATA[$F{day_str}]]></groupExpression> <groupHeader> <band height="0" isSplitAllowed="true" > </band> </groupHeader> <groupFooter> <band height="0" isSplitAllowed="true" > </band> </groupFooter> </group> <background> <band height="0" isSplitAllowed="true" > </band> </background> <title> <band height="48" isSplitAllowed="true" > <staticText> <reportElement mode="Transparent" x="0" y="5" width="535" height="40" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Center" verticalAlignment="Top" lineSpacing="Single"> </textElement> <text><![CDATA[Personal Schedule]]></text> </staticText> <line direction="TopDown"> <reportElement mode="Opaque" x="0" y="47" width="535" height="0" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <graphicElement stretchType="NoStretch" pen="2Point" fill="Solid" /> </line> <line direction="TopDown"> <reportElement mode="Opaque" x="0" y="3" width="535" height="0" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <graphicElement stretchType="NoStretch" pen="2Point" fill="Solid" /> </line> </band> </title> <pageHeader> <band height="40" isSplitAllowed="true" > <rectangle radius="0" > <reportElement mode="Opaque" x="0" y="0" width="535" height="40" forecolor="#8080FF" backcolor="#000000" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <graphicElement stretchType="NoStretch" pen="None" fill="Solid" /> </rectangle> <staticText> <reportElement mode="Transparent" x="0" y="0" width="55" height="22" forecolor="#FFFFFF" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="true"/> <textElement textAlignment="Left" verticalAlignment="Top" lineSpacing="Single"> </textElement> <text><![CDATA[Name]]></text> </staticText> <textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="false" evaluationTime="Report" hyperlinkType="None" > <reportElement mode="Transparent" x="57" y="0" width="287" height="22" forecolor="#FFFFFF" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Left" verticalAlignment="Top" lineSpacing="Single"> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$V{lastname}+ ", " + $V{firstname}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true" evaluationTime="Report" hyperlinkType="None" > <reportElement mode="Transparent" x="352" y="0" width="181" height="22" forecolor="#FFFFFF" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Right" verticalAlignment="Middle" lineSpacing="Single"> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$V{thegroup}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" > <reportElement mode="Transparent" x="0" y="24" width="534" height="15" forecolor="#FFFFFF" backcolor="#FFFFFF" positionType="Float" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Left" verticalAlignment="Bottom" lineSpacing="Single"> </textElement> <textFieldExpression class="java.lang.String"><![CDATA["Reporting from " + (new SimpleDateFormat("EEE MMM dd, yyyy").format(new Date($V{lstart}.longValue() ))) + " through " + (new SimpleDateFormat("EEE MMM dd, yyyy").format(new Date( $V{lend}.longValue() )))]]></textFieldExpression> </textField> </band> </pageHeader> <columnHeader> <band height="16" isSplitAllowed="true" > <rectangle radius="0" > <reportElement mode="Opaque" x="0" y="0" width="535" height="15" forecolor="#000000" backcolor="#808080" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <graphicElement stretchType="NoStretch" pen="None" fill="Solid" /> </rectangle> <line direction="BottomUp"> <reportElement mode="Opaque" x="0" y="0" width="535" height="0" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <graphicElement stretchType="NoStretch" pen="Thin" fill="Solid" /> </line> <line direction="BottomUp"> <reportElement mode="Opaque" x="0" y="15" width="535" height="0" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <graphicElement stretchType="NoStretch" pen="Thin" fill="Solid" /> </line> <staticText> <reportElement mode="Transparent" x="50" y="0" width="80" height="15" forecolor="#FFFFFF" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Left" verticalAlignment="Top" lineSpacing="Single"> </textElement> <text><![CDATA[Date]]></text> </staticText> <staticText> <reportElement mode="Transparent" x="141" y="0" width="80" height="15" forecolor="#FFFFFF" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Left" verticalAlignment="Top" lineSpacing="Single"> </textElement> <text><![CDATA[start time]]></text> </staticText> <staticText> <reportElement mode="Transparent" x="231" y="0" width="80" height="15" forecolor="#FFFFFF" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Left" verticalAlignment="Top" lineSpacing="Single"> </textElement> <text><![CDATA[End time]]></text> </staticText> <staticText> <reportElement mode="Transparent" x="0" y="0" width="43" height="15" forecolor="#FFFFFF" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Left" verticalAlignment="Top" lineSpacing="Single"> </textElement> <text><![CDATA[Day]]></text> </staticText> <staticText> <reportElement mode="Transparent" x="317" y="0" width="214" height="15" forecolor="#FFFFFF" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Left" verticalAlignment="Top" lineSpacing="Single"> </textElement> <text><![CDATA[schedule Notes]]></text> </staticText> </band> </columnHeader> <detail> <band height="16" isSplitAllowed="true" > <line direction="TopDown"> <reportElement mode="Opaque" x="0" y="14" width="535" height="0" forecolor="#808080" backcolor="#FFFFFF" positionType="FixRelativeToBottom" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <graphicElement stretchType="NoStretch" pen="Thin" fill="Solid" /> </line> <textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None" > <reportElement mode="Transparent" x="141" y="0" width="80" height="15" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="true" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="true"> <printWhenExpression><![CDATA[$F{itemactive}]]></printWhenExpression> </reportElement> <textElement textAlignment="Left" verticalAlignment="Top" lineSpacing="Single"> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$F{itemstarttime}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None" > <reportElement mode="Transparent" x="231" y="0" width="80" height="15" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="true" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="true"> <printWhenExpression><![CDATA[$F{itemactive}]]></printWhenExpression> </reportElement> <textElement textAlignment="Left" verticalAlignment="Top" lineSpacing="Single"> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$F{itemendtime}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None" > <reportElement mode="Transparent" x="0" y="0" width="37" height="15" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="false" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="true"/> <textElement textAlignment="Left" verticalAlignment="Top" lineSpacing="Single"> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$F{dayoftheweek}]]></textFieldExpression> </textField> <line direction="TopDown"> <reportElement mode="Opaque" x="312" y="0" width="0" height="14" forecolor="#808080" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <graphicElement stretchType="RelativeToBandHeight" pen="Thin" fill="Solid" /> </line> <subreport isUsingCache="false"> <reportElement mode="Transparent" x="313" y="0" width="220" height="15" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="true" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="true"> <printWhenExpression><![CDATA[$V{IsManual}]]></printWhenExpression> </reportElement> <subreportParameter name="code"> <subreportParameterExpression><![CDATA[$F{manualcode}]]></subreportParameterExpression> </subreportParameter> <subreportParameter name="notes"> <subreportParameterExpression><![CDATA[$F{manualsupnotes}]]></subreportParameterExpression> </subreportParameter> <subreportParameter name="abscode"> <subreportParameterExpression><![CDATA[$F{manualabscode}]]></subreportParameterExpression> </subreportParameter> <subreportParameter name="absdesc"> <subreportParameterExpression><![CDATA[$F{manualabsdesc}]]></subreportParameterExpression> </subreportParameter> <subreportParameter name="ltimeafter"> <subreportParameterExpression><![CDATA[$F{manstartafter}]]></subreportParameterExpression> </subreportParameter> <subreportParameter name="mode"> <subreportParameterExpression><![CDATA[$F{changemode}]]></subreportParameterExpression> </subreportParameter> <subreportParameter name="key"> <subreportParameterExpression><![CDATA[$F{changekey}]]></subreportParameterExpression> </subreportParameter> <subreportParameter name="startdaybefore"> <subreportParameterExpression><![CDATA[$F{manstartdaybefore}]]></subreportParameterExpression> </subreportParameter> <subreportParameter name="startdayafter"> <subreportParameterExpression><![CDATA[$F{manstartdayafter}]]></subreportParameterExpression> </subreportParameter> <subreportParameter name="starttimebefore"> <subreportParameterExpression><![CDATA[$F{manstarttimebefore}]]></subreportParameterExpression> </subreportParameter> <subreportParameter name="starttimeafter"> <subreportParameterExpression><![CDATA[$F{manstarttimeafter}]]></subreportParameterExpression> </subreportParameter> <subreportParameter name="enddaybefore"> <subreportParameterExpression><![CDATA[$F{manenddaybefore}]]></subreportParameterExpression> </subreportParameter> <subreportParameter name="enddayafter"> <subreportParameterExpression><![CDATA[$F{manenddayafter}]]></subreportParameterExpression> </subreportParameter> <subreportParameter name="endtimebefore"> <subreportParameterExpression><![CDATA[$F{manendtimebefore}]]></subreportParameterExpression> </subreportParameter> <subreportParameter name="endtimeafter"> <subreportParameterExpression><![CDATA[$F{manendtimeafter}]]></subreportParameterExpression> </subreportParameter> <subreportParameter name="active"> <subreportParameterExpression><![CDATA[$F{itemactive}]]></subreportParameterExpression> </subreportParameter> <connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression> <subreportExpression class="java.lang.String"><![CDATA[$V{ReportLocation}+"ScheduleChangeDetail.jasper"]]></subreportExpression> </subreport> <textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None" > <reportElement mode="Transparent" x="42" y="0" width="85" height="15" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="false" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="true"/> <textElement textAlignment="Left" verticalAlignment="Top" lineSpacing="Single"> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$F{day_str}]]></textFieldExpression> </textField> <subreport isUsingCache="false"> <reportElement mode="Transparent" x="313" y="0" width="220" height="15" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="true" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="true"> <printWhenExpression><![CDATA[$V{IsTrade}]]></printWhenExpression> </reportElement> <subreportParameter name="key"> <subreportParameterExpression><![CDATA[$F{changekey}]]></subreportParameterExpression> </subreportParameter> <subreportParameter name="active"> <subreportParameterExpression><![CDATA[$F{itemactive}]]></subreportParameterExpression> </subreportParameter> <subreportParameter name="tradeacceptfirst"> <subreportParameterExpression><![CDATA[$F{tradeacptfirstname}]]></subreportParameterExpression> </subreportParameter> <subreportParameter name="tradeacceptlast"> <subreportParameterExpression><![CDATA[$F{tradeacptlastname}]]></subreportParameterExpression> </subreportParameter> <subreportParameter name="tradeoffershift"> <subreportParameterExpression><![CDATA[$F{tradeshift}]]></subreportParameterExpression> </subreportParameter> <subreportParameter name="tradeacceptshift"> <subreportParameterExpression><![CDATA[$F{tradeacptshift}]]></subreportParameterExpression> </subreportParameter> <subreportParameter name="tradedeleted"> <subreportParameterExpression><![CDATA[$F{tradedeleted}]]></subreportParameterExpression> </subreportParameter> <subreportParameter name="tradeacceptdeleted"> <subreportParameterExpression><![CDATA[$F{tradeacceptdeleted}]]></subreportParameterExpression> </subreportParameter> <connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression> <subreportExpression class="java.lang.String"><![CDATA[$V{ReportLocation}+"ScheduleTradeDetail.jasper"]]></subreportExpression> </subreport> <subreport isUsingCache="false"> <reportElement mode="Transparent" x="313" y="0" width=&
- September 12, 2006
- - iReport Designer
Different output when printing

2004 IR Help posted a topic in Products

By: sam - sammak168 Different output when printing 2006-09-03 17:48 I have used a jpeg file as the background using iReport. There are some fields in the report to be filled in my java program. Then I tried to use JRPrintServiceExporter to print the report out. However, the output image seems to be diminished and some information on the top of the page is cut. Is there any parameter/setting to resolve this ?
- September 5, 2006
- - JasperReports Library
HyperLink types for a text field

2004 IR Help posted a topic in Products

By: query - query HyperLink types for a text field 2004-12-01 00:53 Hi, Iam using ireports 0.3.0 Can anyone tell me the purpose of LocalPage, LocalAnchor, RemoteAnchor, RemotePage options for a hyperlink of a text field and how they r used Thanx in Advance query By: Giulio Toffoli - gt78 RE: HyperLink types for a text field 2004-12-02 09:09 In a pdf, as in HTML you can export liks. LocalPage = page number (used for PDF) LocalAnchor = #anchor (used for HTML) RemoteAnchor= http://xys.com?myfsdfsf=fdsaf.... RemotePage = a page in the document pointed by RemoteAnchor Giulio By: query - query RE: HyperLink types for a text field 2004-12-03 04:27 Hi Giulio, Thank U for the info. But I have few clarifications here. I have a report where each employee record contains a column called Availability which is to read from an excel sheet. How do I do this using ireports 0.3.0 and my report also contains a hyperlink called SkillSetDetails for each employee record. Clicking this the employee skill details shud be displayed. How do I associate a query to this link. seems my query is too long. but these r the requirements I have at present in my project. Hope U can give me the best solution query By: query - query RE: HyperLink types for a text field 2004-12-06 20:18 Can anyone help me out in solving the above problems. By: ginia - ginia_patel RE: HyperLink types for a text field 2005-12-07 03:11 hi, i have the same problem. on clicking a field say employeeid i should get a report showing its detail . did u get the solution for it. please reply me on giniapatel@gmail.com if u know the solution. i will be really very thankful to u.
- September 3, 2006
- - iReport Designer
class file wrong version 49.0, should be 48.0

2004 IR Help posted a topic in Products

By: tc - tcsource class file wrong version 49.0, should be 48.0 2004-09-30 08:27 Is there a compatability issue somewhere? jdk1.5.0 jre1.5.0 iReport-0.3.2 jasperreports-0.6.1 Here's the error message: Errors compiling test.jasper! C:usrlocalbiniReportiReport-0.3.2classic.java:17: cannot access java.lang.Object bad class file: C:usrlocalbinJavajre1.5.0librt.jar(java/lang/Object.class) class file has wrong version 49.0, should be 48.0 Please remove or make sure it appears in the correct subdirectory of the classpath. public class classic extends JRCalculator ^ 1 error thanks By: Daren O - rckrll106 RE: class file wrong version 49.0, should be 2005-11-01 12:44 I know this was an old post. I ran into the same problem and always good to post a solution. Check to make sure you have the 1.5 tools.jar in the ireport lib. this error refers for a java version difference between 1.4 and 1.5
- September 3, 2006
- - iReport Designer
Dimension of the bands

2004 IR Help posted a topic in Products

By: aletasso - aletasso Dimension of the bands 2004-11-02 01:56 I need to set the dimension on a band depending on the thigs that i print.. i have some field that appear or not at the bottom of a band but the band must be shoter if they do not appear.. how can i do? please help By: miami - enrico1985 RE: Dimension of the bands 2005-11-07 01:11 i don't know, but try to set the check Split alowed
- September 3, 2006
- - iReport Designer
Char labels are displayed too small

2004 IR Help posted a topic in Products

By: Huy Nguyen - huyntminh Char labels are displayed too small 2004-12-12 19:33 I created a 2D-Pie chart. Everything seems OK but when the chart display, the problem is that the labels are too small. I have to zoom more than 200% in order to see those labels clearly. But with that large zoom, the chart become too large. Please show me if there are any way too change those labels' font size. Thanks a lot, I'm looking forward to your help. By: Dane L - danelav RE: Char labels are displayed too small 2005-07-30 19:19 Please post again if you solved this problem. I'm trying to figure it out myself. By: blossom - blossom RE: Char labels are displayed too small 2005-10-25 11:23 I have the same problem.I have no time to spend on this. I looked inside entire IReport Designer tool. THere is no such option to adjust place between the labels on x-axis. I used both 2D and 3D charts. No use. without that charts are useless Help pls Blossom
- September 3, 2006
- - iReport Designer
External TrueType PDF Font

2004 IR Help posted a topic in Products

By: timtas - timtassonis External TrueType PDF Font 2004-09-23 02:09 Hi I want to use a special Font installed in Windows. At the font properties of the text field, I can select the font as "Font Name". In the Box PDF Font Name, the font does not appear, however there is the option "External TTF font...". But if I select this, the box "TrueType font" is empty. What do I have to do, to get my font into this list, so it will be used in the generated PDF? This is on Windows NT, btw. Tim By: timtas - timtassonis RE: External TrueType PDF Font 2004-09-27 02:20 So, I found the relevant code in FontListLoader.java: public static Vector loadTTFFonts() { Vector fonts = new Vector(); String path = System.getProperty("java.class.path"); //path += System.getProperty("path.separator") + "C:\winnt\fonts"; The commented line would load the fonts from the system location. So, I manually added c:winntfonts to CLASSPATH, in ireport2.bat, and bingo, the fonts loaded OK in the "TrueType font" box! So, there is probably no portable way to do this, one just has to add the font directory to the CLASSPATH? But it is... To me, it seems that the "Font Name" select box lists all system installed fonts (I can select it from there), but the TrueType font goes to some other source that has no entry at all on my installation. It is completely empty, whereas the "Font Name" is full of all my local fonts. By: it-xman - it-xman RE: External TrueType PDF Font 2004-09-27 01:28 It should not be empty. Please make sure that you actually installed the font into windows NT because it follows the system font. By: jane_lim - jane_lim RE: External TrueType PDF Font 2005-09-30 01:57 I encounter the same problem ... to enable iReport support chinese word, i copy the simhei.ttf from C:WINDOWSFonts to C:iReport-0.5.1fonts after i restart my iReport, Font Name: SimHei PDF Font Name: External TTF font .. but the TrueType Font blank .... m sure i have installed the font in my windows, cos i copy the font from there to iReport font ... when i open the xml, i found the pdfFontName="', i need to manually set pdfFontName="C:WINDOWSFontssimhei.ttf" in order can compile and see the chinese word in pdf .. Is this a bugs?? i search online, a lot people encounter same problem ..... By: C-Box - c-box RE: External TrueType PDF Font 2005-09-30 05:57 Uhh guys... I'm sure having post the solution to that problem some days ago in that forum... just use the SEARCH FUNCTION with keywords "external font" ... and voilá´he second entry gives you the solution: http://sourceforge.net/forum/message.php?msg_id=3354851 hth C-Box
- September 3, 2006
- - iReport Designer
groups

2004 IR Help posted a topic in Products

By: aletasso - aletasso groups 2004-10-27 06:57 How can i do to count the number of breaks in a group and display it in my report? Please help me By: aletasso - aletasso RE: groups 2004-10-27 08:38 Sorry giulio you are so nice to ansver to my problems... Yet when i declare the variable Var1 end then i write new Integer(Var1.intValue()+1) Jasper writes cannot resove symbol Var1... please help By: Giulio Toffoli - gt78 RE: groups 2004-10-27 10:30 Replace Var1 with $V{Var1} and Var2 with $V{Var2} Giulio By: Giulio Toffoli - gt78 RE: groups 2004-10-27 07:46 Use two variable. the first variable is a number reset to 0 at every new break (or start) of the group XYZ and incremented by one at every record. Var1 Type: Integer Expression: new Integer(Var1.intValue()+1) Initvalue: new integer(0) ResetType: Group (XYZ) The second incremets at every time Var1 is 0 Var2 Type: Integer Expression: new Integer(Var1.intValue()+ ((Var1.intValue() == 0 ) ? 1 : 0)) Initvalue: new integer(0) ResetType: Report (Var2 + 1) is your value. Giulio By: HSL - lhshyong RE: groups 2005-08-11 23:43 hi, gt78 , i am new here. i am using ireport 0.50 and follow what u teach here but mine not work coz the Var2 execute before the Var1, the Var2 assign to 0 before the Var1 reset.. any comment here.?
- September 3, 2006
- - iReport Designer
Chart Creation thru iReport 0.4.0 - help

2004 IR Help posted a topic in Products

By: Ashok - k_s_ashok Chart Creation thru iReport 0.4.0 - help 2004-10-13 05:33 Hi Giulio, I tried to create Chart. But i got stuckup. In the Chart Properties - What is Data Option and Report Series ? How can i pass my query result value for chart creation ? By: Ashok - k_s_ashok RE: Chart Creation thru iReport 0.4.0 - help 2004-10-14 22:23 Hi Giulio, Any update ? By: Giulio Toffoli - gt78 RE: Chart Creation thru iReport 0.4.0 - help 2004-10-17 13:37 You have to put tools.jar from your JDK into iReport lib directory Giulio By: rockmuncher - rockmuncher RE: Chart Creation thru iReport 0.4.0 - help 2004-10-17 20:27 Giulio, I'm looking forward to the tutorial. In the mean time I have a related "what did I do wrong?" question. I have a basic report with report query set to select group_name, count(site_code) as sites from prop_group a, prop_site_group b where group_type=9 and a.group_code=b.group_code group by group_name There are no grouping levels on the report, just detail. Detail contains a chart which has pie chart type selected, $F{GROUP_NAME} as Label series and $F{SITES} as Serie1 series. My report prints chart nicely, first with 1 GROUP_NAME element, then 2, 3, 4, until it reaches max GROUP_NAME elements (which is how it should look). Why am I not getting just the last chart? By: rockmuncher - rockmuncher RE: Chart Creation thru iReport 0.4.0 - help 2004-10-17 20:35 Re my last post: The report does out as expected if the chart is inserted into the Report Summary section only (ie. not in the Detail section). Is that how charts are intended to be used? In Summary and Footer sections? By: djiska - djiska RE: Chart Creation thru iReport 0.4.0 - help 2004-10-18 14:55 Hi Giulio It is true. The tools.jar has been forgotten to me. Also, I put the charts in footer section and not in Sumary section. Now I think I have put it in its place but it still gives me a Exception and it is different. 594955?[Thread-9]?ERROR?digester.Digester??-?End?event?threw?exception java.lang.reflect.InvocationTargetException ????at?sun.reflect.NativeMethodAccessorImpl.invoke0(Native?Method) ????at?sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) ????at?sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) ????at?java.lang.reflect.Method.invoke(Method.java:324) ????at?org.apache.commons.beanutils.MethodUtils.invokeMethod(MethodUtils.java:250) ????at?org.apache.commons.digester.SetNextRule.end(SetNextRule.java:260) ????at?org.apache.commons.digester.Digester.endElement(Digester.java:1036) ????at?org.apache.xerces.parsers.AbstractSAXParser.endElement(Unknown?Source) ????at?org.apache.xerces.parsers.AbstractXMLDocumentParser.emptyElement(Unknown?Source) ????at?org.apache.xerces.impl.dtd.XMLDTDValidator.emptyElement(Unknown?Source) ????at?org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanStartElement(Unknown?Source) ????at?org.apache.xerces.impl.XMLDocumentFragmentScannerImpl$FragmentContentDispatcher.dispatch(Unknown?Source) ????at?org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown?Source) ????at?org.apache.xerces.parsers.XML11Configuration.parse(Unknown?Source) ????at?org.apache.xerces.parsers.DTDConfiguration.parse(Unknown?Source) ????at?org.apache.xerces.parsers.XMLParser.parse(Unknown?Source) ????at?org.apache.xerces.parsers.AbstractSAXParser.parse(Unknown?Source) ????at?org.apache.commons.digester.Digester.parse(Digester.java:1514) ????at?net.sf.jasperreports.engine.xml.JRXmlLoader.loadXML(JRXmlLoader.java:400) ????at?net.sf.jasperreports.engine.xml.JRXmlLoader.load(JRXmlLoader.java:384) ????at?net.sf.jasperreports.engine.xml.JRXmlLoader.load(JRXmlLoader.java:338) ????at?net.sf.jasperreports.engine.xml.JRXmlLoader.load(JRXmlLoader.java:322) ????at?net.sf.jasperreports.engine.JasperCompileManager.compileReportToFile(JasperCompileManager.java:128) ????at?it.businesslogic.ireport.IReportCompiler.run(IReportCompiler.java:336) ????at?java.lang.Thread.run(Thread.java:536) Caused?by:?net.sf.jasperreports.engine.JRException:?Duplicate?declaration?of?parameter?:?REPORT_DATA_SOURCE ????at?net.sf.jasperreports.engine.design.JasperDesign.addParameter(JasperDesign.java:671) ????...?25?more java.lang.reflect.InvocationTargetException ????at?org.apache.commons.digester.Digester.createSAXException(Digester.java:2312) ????at?org.apache.commons.digester.Digester.createSAXException(Digester.java:2332) ????at?org.apache.commons.digester.Digester.endElement(Digester.java:1039) ????at?org.apache.xerces.parsers.AbstractSAXParser.endElement(Unknown?Source) ????at?org.apache.xerces.parsers.AbstractXMLDocumentParser.emptyElement(Unknown?Source) ????at?org.apache.xerces.impl.dtd.XMLDTDValidator.emptyElement(Unknown?Source) ????at?org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanStartElement(Unknown?Source) ????at?org.apache.xerces.impl.XMLDocumentFragmentScannerImpl$FragmentContentDispatcher.dispatch(Unknown?Source) ????at?org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown?Source) ????at?org.apache.xerces.parsers.XML11Configuration.parse(Unknown?Source) ????at?org.apache.xerces.parsers.DTDConfiguration.parse(Unknown?Source) ????at?org.apache.xerces.parsers.XMLParser.parse(Unknown?Source) ????at?org.apache.xerces.parsers.AbstractSAXParser.parse(Unknown?Source) ????at?org.apache.commons.digester.Digester.parse(Digester.java:1514) ????at?net.sf.jasperreports.engine.xml.JRXmlLoader.loadXML(JRXmlLoader.java:400) ????at?net.sf.jasperreports.engine.xml.JRXmlLoader.load(JRXmlLoader.java:384) ????at?net.sf.jasperreports.engine.xml.JRXmlLoader.load(JRXmlLoader.java:338) ????at?net.sf.jasperreports.engine.xml.JRXmlLoader.load(JRXmlLoader.java:322) ????at?net.sf.jasperreports.engine.JasperCompileManager.compileReportToFile(JasperCompileManager.java:128) ????at?it.businesslogic.ireport.IReportCompiler.run(IReportCompiler.java:336) ????at?java.lang.Thread.run(Thread.java:536) NESTED?BY?: net.sf.jasperreports.engine.JRException:?Error?at?(24,?88:?null ????at?net.sf.jasperreports.engine.xml.JRXmlLoader.loadXML(JRXmlLoader.java:404) ????at?net.sf.jasperreports.engine.xml.JRXmlLoader.load(JRXmlLoader.java:384) ????at?net.sf.jasperreports.engine.xml.JRXmlLoader.load(JRXmlLoader.java:338) ????at?net.sf.jasperreports.engine.xml.JRXmlLoader.load(JRXmlLoader.java:322) ????at?net.sf.jasperreports.engine.JasperCompileManager.compileReportToFile(JasperCompileManager.java:128) ????at?it.businesslogic.ireport.IReportCompiler.run(IReportCompiler.java:336) ????at?java.lang.Thread.run(Thread.java:536) Caused?by:?java.lang.reflect.InvocationTargetException ????at?org.apache.commons.digester.Digester.createSAXException(Digester.java:2312) ????at?org.apache.commons.digester.Digester.createSAXException(Digester.java:2332) ????at?org.apache.commons.digester.Digester.endElement(Digester.java:1039) ????at?org.apache.xerces.parsers.AbstractSAXParser.endElement(Unknown?Source) ????at?org.apache.xerces.parsers.AbstractXMLDocumentParser.emptyElement(Unknown?Source) ????at?org.apache.xerces.impl.dtd.XMLDTDValidator.emptyElement(Unknown?Source) ????at?org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanStartElement(Unknown?Source) ????at?org.apache.xerces.impl.XMLDocumentFragmentScannerImpl$FragmentContentDispatcher.dispatch(Unknown?Source) ????at?org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown?Source) ????at?org.apache.xerces.parsers.XML11Configuration.parse(Unknown?Source) ????at?org.apache.xerces.parsers.DTDConfiguration.parse(Unknown?Source) ????at?org.apache.xerces.parsers.XMLParser.parse(Unknown?Source) ????at?org.apache.xerces.parsers.AbstractSAXParser.parse(Unknown?Source) ????at?org.apache.commons.digester.Digester.parse(Digester.java:1514) ????at?net.sf.jasperreports.engine.xml.JRXmlLoader.loadXML(JRXmlLoader.java:400) ????...?6?more If do you have got any idea of this Exception? also you help me so much. Thank you very much for your reponds of over. And see you. By: Giulio Toffoli - gt78 RE: Chart Creation thru iReport 0.4.0 - help 2004-10-19 09:31 Perhaps you have declared the built in Parameter: REPORT_DATA_SOURCE remove it from your parameters Giulio By: Alessandro - alebr RE: Chart Creation thru iReport 0.4.0 - help 2004-10-20 12:40 Hi, We wanna do a Stacked Chart with 3 series with iReport 0.4.0 (Chart tool): - 2 bar series(stacked); - 1 line series (combined with stacked) Can you help us ! How much costs to you make an example ??? We really need do that !!! By: djiska - djiska RE: Chart Creation thru iReport 0.4.0 - help 2004-10-20 09:39 Hello Giulio again. I have deleted the parameter REPORT_DATA_SOURCE. Now it doesn't give me any errors. But the chart is empty. I don't know why?. the query has got datas. thank you very much. greets By: Matteo - jyotaro RE: Chart Creation thru iReport 0.4.0 - help 2004-10-21 00:37 I have had tha same problem. The problem was the dimension of the chart. Modifing them as x 545 and y 757, I was able to view the data. I hope this help you. Bye, Matteo By: djiska - djiska RE: Chart Creation thru iReport 0.4.0 - help 2004-10-21 14:30 Hi guys I have not found the option x,y. I suppose it is width 545 and height 757. if is it so?, I run and it happens the same. it doesn't show anything. any idea? thank you very much for your help. By: djiska - djiska RE: Chart Creation thru iReport 0.4.0 - help 2004-10-25 16:05 hi again. I have tested the thread the before. And it doesn't work. I can not change the screen resolution of my monitor. I am running the reports with chart to (800,600). it can be that why doesn't it work?. Have somebody tested this option?, if someone does it, it would be to me the grant help. thank you. By: MBincole - mbincole RE: Chart Creation thru iReport 0.4.0 - help 2004-11-02 07:47 Ciao a tutti, I've tried to build-up a report with a chart in the lastPageFooter but when I make the whole document, iReport 0.4.0 can't display the chart correctly. I can see only the grid on the axis... I think I haven't set all the parameters... Now I ask, could someone ( with a simple example ) make a short demonstration and show how to build one? Thanks to everyone who read. MBincole By: djiska - djiska RE: Chart Creation thru iReport 0.4.0 - help 2004-10-25 15:44 Hi I am trying to do that works. But it still don't work. Maybe it can be for the jdk. I am using the jdk1.4.1. thank you By: duhu - duhu RE: Chart Creation thru iReport 0.4.0 - help 2004-12-14 00:34 I have a problem like this one. I can make a report with a chart in iReport and it runs ok, but if I run it from a JSP page I get an error like this: org.apache.jasper.JasperException: Error evaluating expression : image_1 Source text : (java.awt.Image)it.businesslogic.ireport.chart.DefaultChartFactory.drawChart(new String[]{"chartName=Pie3D","depthFactor=0.2","titlePosition=1","width=227","serie1=SERIE_numeros","plotBackground=[255,255,255]","serie0=SERIE_nombres","foregroundAlpha=0.33","tooltips=false","chartBackground=[255,255,255]","subtitle=","title=","legend=false","quality=2","height=170","antialias=true"}, (it.businesslogic.ireport.IReportScriptlet)$P{REPORT_SCRIPTLET}) at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:254) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:295) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:24 (...) The code of my JSP is: <% File reportFile = new File(application.getRealPath("/reports/prueba3.jasper")); JasperReport jasperReport = (JasperReport)JRLoader.loadObject(reportFile.getPath()); Map parameters = new HashMap(); //parameters.put("REPORT_SCRIPTLET", new pruebaScriptlet()); //parameters.put("chart-1", createEmployeeChartImage()); //parameters.put("BaseDir", reportFile.getParentFile()); Context context = new InitialContext(); DataSource dataSource =(DataSource)context.lookup("java:jdbc/prueba"); Connection conexion = dataSource.getConnection(); JasperPrint jasperPrint = JasperFillManager.fillReport(jasperReport,parameters,conexion); JRHtmlExporter exporter = new JRHtmlExporter(); StringBuffer sbuffer = new StringBuffer(); exporter.setParameter(JRExporterParameter.JASPER_PRINT, jasperPrint); exporter.setParameter(JRExporterParameter.OUTPUT_WRITER, out); exporter.exportReport(); %> By: Delia - ce_medinadelia RE: Chart Creation thru iReport 0.4.0 - help 2005-02-15 13:36 I have a problem like this one. I can make a report with a chart in iReport and it runs ok, but if I run it from a JSP page I get an error like this: And i have in the classpath the iReport.jar C:jakarta-tomcat-4.1.30webappssappiereporteresumenreporte_resumen.java:137: package it.busines slogic.ireport does not exist value = (java.awt.Image)((java.awt.Image)it.businesslogic.ireport.chart.DefaultChart Factory.drawChart(new String[]{"antialias=true","tooltips=false","legend=false","chartName=Bar3D","p lotOrientation=2","foregroundAlpha=0.33","valueLabel=Serie1","subtitle=","plotBackground=[255,255,25 5]","quality=1","height=139","titlePosition=1","chartBackground=[255,255,255]","width=488","serie2=S ERIE_Serie_Ejecutado","serie1=SERIE_Seri_listado","serie0=SERIE_Serie_Mes","categoryLabel=Serie2","t itle="}, (it.businesslogic.ireport.IReportScriptlet)((net.sf.jasperreports.engine.JRAbstractScriptle t)parameter_REPORT_SCRIPTLET.getValue()))); By: djiska - djiska RE: Chart Creation thru iReport 0.4.0 - help 2004-10-16 14:10 Hi Giulio I have got the same trouble this guy. I try to create a chart. But it doesn't work. I describe you, I am doing. Maybe I am making a bad step. I am sure that last :). 1) I create the query (DataSource-> Report query).fe: SELECT ASIGNATURA_MATRI_P.NOTA10 FROM ASIGNATURA_MATRI_P GROUP BY ASIGNATURA_MATRI_P.NOTA10 2) I create with chart tool a chart. 3) I select the first kind.(Properties->Chart->Edit chart properties-> chart type). 4) I insert in Serie1 (SERIE_Aprobado, SERIE_Suspenso, SERIE_Notable, SERIE_Sobresaliente, SERIE_NoPresentado). It is from here when I have got all my doubts. I compile it and it gives me this exceptions: Error compiling the Scriptlet java source! java.lang.ClassNotFoundException:?com.sun.tools.javac.Main ????at?java.net.URLClassLoader$1.run(URLClassLoader.java:198) ????at?java.security.AccessController.doPrivileged(Native?Method) ????at?java.net.URLClassLoader.findClass(URLClassLoader.java:186) ????at?java.lang.ClassLoader.loadClass(ClassLoader.java:299) ????at?sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:265) ????at?java.lang.ClassLoader.loadClass(ClassLoader.java:255) ????at?java.lang.ClassLoader.loadClassInternal(ClassLoader.java:315) ????at?java.lang.Class.forName0(Native?Method) ????at?java.lang.Class.forName(Class.java:217) ????at?net.sf.jasperreports.engine.util.JRClassLoader.loadClassForName(JRClassLoader.java:116) ????at?net.sf.jasperreports.engine.design.JRJdk13Compiler.compileClass(JRJdk13Compiler.java:111) ????at?it.businesslogic.ireport.IReportCompiler.run(IReportCompiler.java:233) ????at?java.lang.Thread.run(Thread.java:536) NESTED?BY?: net.sf.jasperreports.engine.JRException:?Error?compiling?report?java?source?file?:?C:Documents?and?SettingsAdministrador.ireporthistogramas_quesoScriptlet.java ????at?net.sf.jasperreports.engine.design.JRJdk13Compiler.compileClass(JRJdk13Compiler.java:124) ????at?it.businesslogic.ireport.IReportCompiler.run(IReportCompiler.java:233) ????at?java.lang.Thread.run(Thread.java:536) Caused?by:?java.lang.ClassNotFoundException:?com.sun.tools.javac.Main ????at?java.net.URLClassLoader$1.run(URLClassLoader.java:198) ????at?java.security.AccessController.doPrivileged(Native?Method) ????at?java.net.URLClassLoader.findClass(URLClassLoader.java:186) ????at?java.lang.ClassLoader.loadClass(ClassLoader.java:299) ????at?sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:265) ????at?java.lang.ClassLoader.loadClass(ClassLoader.java:255) ????at?java.lang.ClassLoader.loadClassInternal(ClassLoader.java:315) ????at?java.lang.Class.forName0(Native?Method) ????at?java.lang.Class.forName(Class.java:217) ????at?net.sf.jasperreports.engine.util.JRClassLoader.loadClassForName(JRClassLoader.java:116) ????at?net.sf.jasperreports.engine.design.JRJdk13Compiler.compileClass(JRJdk13Compiler.java:111) I know the problem is in the scriptle. But I don't know if I have got to write something there (scriptle experimental) or in (properties->common->Print when Expresion). And what do I write?. fe. the thread over, the parameter REPORT_SCRIPTLET, I don't have got it. I have got to create it or with the formulas of expression editor is enouph. But there are anothers parameters whitch I don't know How to inicialice it. I don't know if you understand me. I have got to give you the congratulations for this application. Because it is very good tool. I hope your respond. greets, By: Mufasa - mufasa RE: Chart Creation thru iReport 0.4.0 - help 2005-01-04 13:37 Same problem here too... By: Narso - narso RE: Chart Creation thru iReport 0.4.0 - help 2005-07-20 13:48 I had the same problem too. All you have to do is add tools.jar (from the JDK's 'lib' directory) to the iReports classpath. To do this in iReport, go to Tools->Classpath and locate tools.jar in the JDK directory. Hope this helps. :) By: Giulio Toffoli - gt78 RE: Chart Creation thru iReport 0.4.0 - help 2004-10-15 04:18 No query to make a serie. You can create an iReport handled serie sepcifing a field or an expression to collect. For each record, iReport will take the expression value and it'll put in a Vector. An iReport serie is simply a Vector. You can handle your own serie using IReportScriptlet: suppose to want create a serie of FIELD1, put a fake element like a line in details, set as PrintWhenExpression this expression: ((it.businesslogic.ireport.IReportScriptlet)$P{REPORT_SCRIPTLET}).addValueToSerie("MySerie", $F{FIELD1}) Set MySerie as Serie1 in chart properties. If this is not clear, please wait the tutorial, I'm looking for a pair of hours to write it... :-) Giulio By: Narso - narso RE: Chart Creation thru iReport 0.4.0 - help 2005-07-20 15:20 Thanks! This was a big help in creating a custom series using report variables (sums) that I had made. I'm sure it would be a lot nicer if we could create custom series using an intuitive GUI system instead of hiding the code in expressions in line elements, though. ;) Just a suggestion/ feature request. By: Narso - narso RE: Chart Creation thru iReport 0.4.0 - help 2005-07-20 15:22 Also, it would be great to put instructions for creating non-field series on the tutorial page... It was really a pain to have to wade through the forums just to find out this information.
- September 3, 2006
- - iReport Designer
CSV DataSource

2004 IR Help posted a topic in Products

By: kamgra01 - kammeradgranato CSV DataSource 2004-10-07 13:53 Problem with the Custom DataSource I read the tutorial: 4.4 Implementing a new custom datasource and tried to run this tutorial on my computer. I design the .jrxml or xml file with iReport I put the .jasper, .jrxml and test.csv on the same folder an the CSVDatasourceTestFactory.java, ,JRCSVDataSource.java .class, in teh folder itbusinesslogicireportconnection. Then I adapt the compiler directory. Then selected the menu BUIL->compile all, then Built-> run with active connection(The connection test was successful). The result is: Compiling to file... C:Dokumente und EinstellungenAAZIGE.ireportbspDataSourcemyDataSource. -> C:Dokumente und EinstellungenAAZIGE.ireportbspDataSourceuntitled_report_1.java Errors compiling C:Dokumente und EinstellungenAAZIGE.ireportbspDataSourcemyDataSource.! dori.jasper.engine.JRException: Report design not valid : 1. Field not found : COLUMN_3 2. Field not found : COLUMN_1 3. Field not found : COLUMN_2 at dori.jasper.engine.design.JRAbstractJavaCompiler.compileReport(JRAbstractJavaCompiler.java:111) at dori.jasper.engine.design.JRDefaultCompiler.compileReport(JRDefaultCompiler.java:137) at dori.jasper.engine.JasperCompileManager.compileReportToFile(JasperCompileManager.java:138) at dori.jasper.engine.JasperCompileManager.compileReportToFile(JasperCompileManager.java:126) at it.businesslogic.ireport.IReportCompiler.run(IReportCompiler.java:321) at java.lang.Thread.run(Unknown Source) Compilation running time : 31 Filling report... pdfExporting Exporting pdf to file... "C:Dokumente und EinstellungenAAZIGE.ireportbspDataSourcemyDataSource.pdf" Running time : 297 Executing: C:ProgrammeAdobeAcrobat 5.0ReaderAcroRd32.exe C:Dokumente und EinstellungenAAZIGE.ireportbspDataSourcemyDataSource.pdf Finished... my test.csv: COLUMN_1;COLUMN_2;COLUMN_3; 1Spalte1Zeile;2Spalte1Zeile;3Spalte1Zeile; 1Spalte2Zeile;2Spalte2Zeile;3Spalte2Zeile; 1Spalte3Zeile;2Spalte3Zeile;3Spalte3Zeile; What is wrong? By: HappyMan2005 - happyman2005 RE: CSV DataSource 2005-06-08 14:32 I have a same problem and I would like to know if any one have an answer to this problem. Thanks..... Problem with the Custom DataSource I read the tutorial: 4.4 Implementing a new custom datasource and tried to run this tutorial on my computer. I design the .jrxml or xml file with iReport I put the .jasper, .jrxml and test.csv on the same folder an the CSVDatasourceTestFactory.java, ,JRCSVDataSource.java .class, in teh folder itbusinesslogicireportconnection. Then I adapt the compiler directory. Then selected the menu BUIL->compile all, then Built-> run with active connection(The connection test was successful). The result is: Compiling to file... C:Dokumente und EinstellungenAAZIGE.ireportbspDataSourcemyDataSource. -> C:Dokumente und EinstellungenAAZIGE.ireportbspDataSourceuntitled_report_1.java Errors compiling C:Dokumente und EinstellungenAAZIGE.ireportbspDataSourcemyDataSource.! dori.jasper.engine.JRException: Report design not valid : 1. Field not found : COLUMN_3 2. Field not found : COLUMN_1 3. Field not found : COLUMN_2 at dori.jasper.engine.design.JRAbstractJavaCompiler.compileReport(JRAbstractJavaCompiler.java:111) at dori.jasper.engine.design.JRDefaultCompiler.compileReport(JRDefaultCompiler.java:137) at dori.jasper.engine.JasperCompileManager.compileReportToFile(JasperCompileManager.java:138) at dori.jasper.engine.JasperCompileManager.compileReportToFile(JasperCompileManager.java:126) at it.businesslogic.ireport.IReportCompiler.run(IReportCompiler.java:321) at java.lang.Thread.run(Unknown Source) Compilation running time : 31 Filling report... pdfExporting Exporting pdf to file... "C:Dokumente und EinstellungenAAZIGE.ireportbspDataSourcemyDataSource.pdf" Running time : 297 Executing: C:ProgrammeAdobeAcrobat 5.0ReaderAcroRd32.exe C:Dokumente und EinstellungenAAZIGE.ireportbspDataSourcemyDataSource.pdf Finished... my test.csv: COLUMN_1;COLUMN_2;COLUMN_3; 1Spalte1Zeile;2Spalte1Zeile;3Spalte1Zeile; 1Spalte2Zeile;2Spalte2Zeile;3Spalte2Zeile; 1Spalte3Zeile;2Spalte3Zeile;3Spalte3Zeile; What is wrong? By: Giulio Toffoli - gt78 RE: CSV DataSource 2005-06-08 15:41 You have to define your fields inthe values dialog Giulio By: HappyMan2005 - happyman2005 RE: CSV DataSource 2005-06-09 10:52 Hi Thank you for your help. But could you provide me with an example, So I can see what am I doing wrong. Because I have provide fields but how would it know COLUMN_1 vs COLUMN_2 vs COLUMN_3 and etc. Thanks for your time and response again. By: Giulio Toffoli - gt78 RE: CSV DataSource 2005-06-10 02:28 Look inside CVSDataSource.java Giulio
- September 3, 2006
- - iReport Designer
Line chart: Using date on x-axis (JFreeChart)

2004 IR Help posted a topic in Products

By: ToRaX - torax Line chart: Using date on x-axis (JFreeChart) 2004-10-25 05:12 Hi, I have a problem. I'm not able to create a line chart with the date on x-axis. What I want to do: My report should show how many occurences there are for the different "ResultCode"s. For every single day I have a group. And every group contatins fields for "ResultCode" and "Count". My report generation is working, it shows for every day the number of different ResultCodes. Example: ----------------------------------- 09.09.2004 ResultCode Count ----------------------------------- 125 1.029 471 301 496 226 459 212 493 172 486 143 402 68 470 68 481 9 350 6 487 3 411 2 ------------------------------------ But I couldn't figure out how to create a chart using the JFreeChart line chart where the x-axis is using Date values. I found a workaround where I am incrementing a counter for each group and then use the resulting series of Integer values (0...x) for the x-axis of the chart. This is working, but I can see only dots instead of the values from 0 to x. Instead of seeing dots or values from 0 to x I would like to see Date values... I hope someone can understand what I'm trying to say... any help is appreciated! By: ToRaX - torax RE: Line chart: Using date on x-axis (JFreeChart) 2004-10-27 00:16 Exactly. I think it throws a NumberFormatException because it tries to convert the date (e.g. 2004-10-26) to a numerical value. And then it throws the exception because of the "-" signs, iirc. By: Xeno - xenoryet RE: Line chart: Using date on x-axis (JFreeCh 2004-10-25 10:16 I had this same problem. If I tried to use a Date on the x axis. It gave me an InvalidNumberFormat exception. So far I have only been able to get the x axis to take Ints or Doubles. It won't do any non-numerical values, such as strings or dates. Anyone know how to fix this? By: Leo Tai - hkleo RE: Line chart: Using date on x-axis (JFreeCh 2005-04-27 03:32 I had the same problem. I use to_char(the_date,'YYYYMMDD') in sql select to convert it to string, which is acceptable in JFreeChart. Please try! By: Giulio Toffoli - gt78 RE: Line chart: Using date on x-axis (JFreeChart) 2004-10-27 01:55 There is a lot of work to do on charting.... Anyway, you can modify the code in the Chart factory class (package it.businesslogic.ireport.chart.*) Giulio By: webbo - webbo_uk RE: Line chart: Using date on x-axis (JFreeCh 2005-06-17 05:14 In order to make this work you can modify it.businesslogic.ireport.chart.DefaultChartFactory.java as Giulio suggests. Line 187-9: dataset.addValue( (Number)new Double(""+ ((valuesX.get( i ) != null) ? valuesX.get( i ) : "0")), (Comparable)theSerie, (Comparable)new Double(""+ ((valuesY.get( i ) != null) ? valuesY.get( i ) : "0"))); Should be changed to: dataset.addValue( (Number)new Double(""+ ((valuesX.get( i ) != null) ? valuesX.get( i ) : "0")), (Comparable)theSerie, (Comparable) ((valuesY.get( i ) != null) ? valuesY.get( i ) : "0")); And the same change made on Line 233 for the Area chart. I tested this and it works
- September 3, 2006
- - iReport Designer
Impossible to add series

2004 IR Help posted a topic in Products

By: Maxim - lazy-max Impossible to add series 2004-10-11 09:00 Why I can't to add more series with iReport 0.4.0? Button "Add Serie" disabled, why? By: Giulio Toffoli - gt78 RE: Impossible to add series 2004-10-11 10:22 You have all you need: you have three fields 1. X axis 2. Y axis 3. Number of serie Please note that iReport use for now only CategoryDataset (see JFreeChart docs for more details about difference between XYDataset and CategoryDataset). Giulio By: koalaffbg - koalaffbg RE: Impossible to add series 2005-03-10 07:06 Yes, But I don't really understand say I want to show how many males and females per month registered to some service. are the meaning of the three fields the following: 1. X axis: serie of "couple of numbers" : {number of males, number of females} 2. Y axis: serie with {January}, {February}, ..., {December} 3. Number of serie ?. here it would be two right ? one for male and one for female. ? and if so, how do I create a serie of "couple of numbers" (I've tried addValueToSerie(my_master_serie, my_couple _of_numbers), my_couple_of_numbers being a serie itself, that I constructed by adding values to as many series as there are months. I hope I'm being understood, and someone has the answer. thanks By: Francisco Rosa Santana - casperbox RE: Impossible to add series 2005-05-11 05:58 Hi, my name is Francisco and I'm having the same problem that you had with adding series in a chart with the iReport tool. I want to know if you?ve solved the problem. I'm trying to make a bar chart with three series and five categories, and I don't know how can I pass the data. Could you help me with this doubt?
- September 3, 2006
- - iReport Designer
J2SE 5.0 and iReport 4.0

2004 IR Help posted a topic in Products

By: Gokhan - cougar123 J2SE 5.0 and iReport 4.0 2004-12-23 14:21 Hi, iReport 4.0 with j2se 1.4.2 works fine but I need to upgrade my JRE to J2SE5.0, but iReport prints the following message when i press "Read Fields" in Report Query section. am I doing smthing wrong? How may I switch to j2se 5.0? Thanks Exception in thread "AWT-EventQueue-0" java.lang.NullPointerException at it.businesslogic.ireport.gui.ReportQueryDialog.processQueryChanged(Re portQueryDialog.java:143) at it.businesslogic.ireport.gui.ReportQueryDialog.access$400(ReportQuery Dialog.java:55) at it.businesslogic.ireport.gui.ReportQueryDialog$2.actionPerformed(Repo rtQueryDialog.java:118) at javax.swing.Timer.fireActionPerformed(Unknown Source) at javax.swing.Timer$DoPostEvent.run(Unknown Source) at java.awt.event.InvocationEvent.dispatch(Unknown Source) at java.awt.EventQueue.dispatchEvent(Unknown Source) at java.awt.EventDispatchThread.pumpOneEventForHierarchy(Unknown Source) at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source) at java.awt.EventDispatchThread.pumpEvents(Unknown Source) at java.awt.EventDispatchThread.pumpEvents(Unknown Source) at java.awt.EventDispatchThread.run(Unknown Source) By: Tobias Gaekle - ike987 RE: J2SE 5.0 and iReport 4.0 2005-02-28 04:24 i'm having exactly the same problem, any ideas? By: Giulio Toffoli - gt78 RE: J2SE 5.0 and iReport 4.0 2005-03-01 10:14 I use iReport with java 1.5. Try to recompile the iReport source code. Giulio
- September 3, 2006
- - iReport Designer

Sign In

2004 IR Help

Posts

Joined

Last visited

Recent Profile Visitors

2004 IR Help's Achievements

Grand Master (14/14)

Recent Badges

Reputation

missing mandatory parameter

Date Paramters

Upgrade problems iReport 0.2.2 to 0.2.3

Different output when printing

HyperLink types for a text field

class file wrong version 49.0, should be 48.0

Dimension of the bands

Char labels are displayed too small

External TrueType PDF Font

groups

Chart Creation thru iReport 0.4.0 - help

CSV DataSource

Line chart: Using date on x-axis (JFreeChart)

Impossible to add series

J2SE 5.0 and iReport 4.0

Activity

Products

Explore