Summation Problem

[jgamble]

I am reading in an SQL query from a jdbc connection.

 

I need to sum integers in a field column for a subtotal, but there are a couple of rows that I need to exclude from the summation. These rows can be identified by their integer values. I haven't been able to figure out how to do it. Is it possible?

 

Any suggestions would be appreciated. I am new to Jasper and iReport.

Post edited by: jgamble, at: 2006/09/22 18:54

[lucianc]

You could do

Code:

<variable name="sum" class="java.lang.Integer" calculation="Sum">
  <variableExpression>..condition.. ? $F{field} : new Integer(0)</variableExpression>
</variable>

 

You can also use null instead of new Integer(0).

 

HTH,

Lucian

[jgamble]

Thank you. That did the trick!

:)