IReport 3.0.0: How to compare big decimals in field expression

bigdecimalexpressionireportjasper-reports

Can anyone tell me how to compare two Big Decimal values in field expression (textFieldExpression)? I'm using iReport 3.0.0.

What is the syntax for greater then?

This is my expression, and it works but only shows if two values not equal, and I need to check which one is greater (amount > paid_amount).

I'm using this expression:

($F{paid_date}!=null & ($F{amount}.equals($F{paid_amount}))) ? new String ("PAID") :(
($F{paid_date}==null) ? new String ("NOT PAID"): (
($F{paid_date}!=null & (!$F{amount}.equals($F{paid_amount}))) ? new String ("PARTIALLY PAID"):(new String ("INVOICE MISSING "))))

Best Answer

For fields like this:

<field name="amount" class="java.math.BigDecimal"/>
<field name="paid_amount" class="java.math.BigDecimal"/>

you should use this expression:

<textFieldExpression class="java.lang.String"><![CDATA[$F{amount}.compareTo($F{paid_amount}) == 1 
? "The amount value is greater than the paid_amount value" 
: $F{amount}.compareTo($F{paid_amount}) == 0 ? 
"The amount value is equal to the paid_amount value" : 
"The amount value is less than the paid_amount value"]]></textFieldExpression>

This expression based on using int BigDecimal.compareTo(java.math.BigDecimal val) method.

Related Solutions

Java – Field Expression in iReport

Try this. Define a style as below.

     <style name="myStyle" isDefault="false" mode="Transparent">
          <conditionalStyle>
              <conditionExpression><![CDATA['YOUR CONDITION']]></conditionExpression>
              <style isDefault="false" style="myStyle" backcolor="#E6DAC3"/>
          </conditionalStyle>
     </style>

And use it in your textFieldExpression

     <reportElement style="myStyle" x="1" y="0" width="100" height="15"/>

Formatting field data color based on condition

I know this is an old question, but in I am assuming Jasper Reports has changed. You can now accomplish this with Conditional Styles.

In iReport you create a new Style and give it a name. You can put any default settings, such as font, color, text size, etc. in the style. Then you right click the Stlye and select Add Conditional Style. Then on the field or fields you want to apply it to you set the style to one you created.

So in your example I would set the Forecolor in the main stlye to be black, set the Condition Expression in the Conditional Style to be

$F{y} > $F{x}

and the Forecolor in the conditional Stlye to red. Then in the detail section where you have the y field placed set the style to the one we created.

Best Answer

Related Solutions

Java – Field Expression in iReport

Formatting field data color based on condition

Related Topic