missing mandatory parameter

2004 IR Help · September 12, 2006

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

tirocerto · June 6, 2007

Eu tive o mesmo problema e a soluÃ§Ã£o foi simples:

Meu cÃ³digo comeÃ§ava assim:

-- FormulÃ¡rio XYZ

select * from ......

o erro era causado pelo comentÃ¡rio no inÃcio do cÃ³digo(-- FormulÃ¡rio XYZ).

Bastou apagar esse comentÃ¡rio para acabar com o erro

-----------------------------------

I heave a same problem and the solution was simple:

My code start like:

-- form <name form>

select * from ......

And the error was caused by the coment (-- form <name form>).

when I del it the error go out.

krasbutch · July 11, 2007

Thanks a lot! It helps to gain a victory over the strange bug :0)

Sign In

missing mandatory parameter

Recommended Posts

2004 IR Help

Link to comment

Share on other sites

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Popular Days

tirocerto

Link to comment

Share on other sites

krasbutch

Link to comment

Share on other sites

Create an account or sign in to comment

Create an account

Sign in

Activity

Products

Explore