subtract two values

[Subramanian Meyyappan]

hi experts,

using ireport3.0.0.i want to subtract two number.

i created a variable named CloseBal.in variable expersion i wrote like this.
$F{DEBIT_AMOUNT} -  $F{CREDIT_AMOUNT}

but the while compiling
The Operator - is undefined for the argument type(s)java.math.bigDecimal,java.math.bigDecimal
Line 218 column 23 /jasperReport/variable[3]/variableExperssion[1]

in my fields Section DEBIT_AMOUNT and CREDIT_AMOUNT both of the fields is of java.lang.BigDecimal

some more info.

net.sf.jasperreports.engine.JRException: Errors were encountered when compiling report expressions class file:
1. The operator - is undefined for the argument type(s) java.math.BigDecimal, java.math.BigDecimal
                value = (java.math.BigDecimal)(((java.math.BigDecimal)field_DEBIT_AMOUNT.getValue())- ((java.math.BigDecimal)field_CREDIT_AMOUNT.getValue()));//$JR_EXPR_ID=10$
                                              <------------------------------------------------------------------------------------------------------------->
2. The operator - is undefined for the argument type(s) java.math.BigDecimal, java.math.BigDecimal
                value = (java.math.BigDecimal)(((java.math.BigDecimal)field_DEBIT_AMOUNT.getOldValue())- ((java.math.BigDecimal)field_CREDIT_AMOUNT.getOldValue()));//$JR_EXPR_ID=10$
                                              <------------------------------------------------------------------------------------------------------------------->
3. The operator - is undefined for the argument type(s) java.math.BigDecimal, java.math.BigDecimal
                value = (java.math.BigDecimal)(((java.math.BigDecimal)field_DEBIT_AMOUNT.getValue())- ((java.math.BigDecimal)field_CREDIT_AMOUNT.getValue()));//$JR_EXPR_ID=10$
                                              <------------------------------------------------------------------------------------------------------------->
3 errors

    at net.sf.jasperreports.engine.design.JRAbstractCompiler.compileReport(JRAbstractCompiler.java:193)
    at it.businesslogic.ireport.IReportCompiler.run(IReportCompiler.java:591)
    at java.lang.Thread.run(Unknown Source)

 

could any one help me where am ?

 

 

Post Edited by adfpeoples at 05/28/2012 06:33

[Subramanian Meyyappan]

i gave a look to those thread . it's help me.

• subtracting two variable total fields in ireport
• error compiling BigDecimal values