count different numbers

[pelmenipeter]

Hallo,

 

i´m searching for 2 days of a solution.

I have a integer field called $F{REJECT}

Then a variable called $V{REJECT_1} This variable should count how often the number 3 exist in $F{REJECT}

I could count all numbers but i dont know how to count only the number "3".

Please help.

Thanks in advance.

[kchaudhry]

Try this in the variable expression.

Code:

($F{REJECT}.intValue() = 3)

[pelmenipeter]

if i use this in variable expression IReport said:

The left-hand side of an assignment must be variable

[mdahlman]

pelmenipeter,

 

You'll need to do a variable that does a sum (rather than a count) more like this:

 

new Integer( ($F{REJECT}.intValue() == 3) ? 1 : 0 )

I didn't test the syntax, but this idea should be what you need.

Regards,Matt

[iddsathish]

Hello,

U can try this out also

First u set $V{REJECT_1} as new Integer(0) in initial expression

Then put this expression in variable expression $V{REJECT_1} .intValue()  + ( $F{REJECT}.intValue() == 3? 1:0) 

Try this out it will work.

[pelmenipeter]

hello,

thanks for your answers but i have found the correct expression, but i´m not @ work, so i´ll post the code on monday.

But i have the problem, that i couldn´t set a field from an xml file to integer. I have this problem in version 3.1.4 and in 3.5. If i set the field to integer in version 2.0.5 the report works.

In the two older versions i´ve tested, i get an NullPointerException. I dont know why. I have to set the field to string an it works, but the string isn´t usefull.

Code:

Here is the code for count the number 0 in the field USAGE($V{USAGE}.intValue()==0?"":null)

Post Edited by Peter König at 03/30/09 05:17