Problem with sum of all visible fields

[2004 IR Help]

By: Daniel R - doctor_jay

Problem with sum of all visible fields

2004-01-21 03:11

Hi,

 

I got a report with a group which is only displayed when a certain expression is true. Therefore I use the "printWhenExpression".

 

In the group footer of each group there is a double value.

Now I want to sum up only the double values from the groups which are printed, in the summary band. How do I achieve this?

Any help would be appreciated.

Thanks.

 

Daniel

 

 

 

 

By: Giulio Toffoli - gt78

RE: Problem with sum of all visible fields

2004-01-22 07:46

You can use an appropritate sum expression.

 

I.E. if you want sum field XXX, and the group expression is zzz, you can use an expression for sum variable like:

 

(( zzz) ? $F{XXX} : new Double(0.0))

 

Giulio