Custom COUNT in crosstab

[pirrimaison1980]

Hi all.

I need add a custom COUNT measure row in a crosstab in order to remove from the count values lower than a given number.

Can someone help me? Any link with documentation about it?

Thanks in advance.

[sjoerd.jump]

(if $V{variable} <= 10) "" ? $F{variable}[/code]

somethink like this?

 

[Thomas Zimmer]

Simply implement the increment(..) Method of the Incrementer interface and the net.sf.jasperreports.engine.fil.JRIncrementerFactory

 to get an instance of your incrementer. Compile, pack as jar, put into classpath and edit the "Incrementer Factory" of your crosstab measure. that will do it.

 

Cheers, Thomas

 

http://www.thomaszimmer.net

[pirrimaison1980]

Thanks to both.

I noticed that NULLs values are not counted by default, and just adding this Value expression to the COUNT measure properties, it seems to works fine.

Integer.valueOf($F{Value}) <= Integer.valueOf(0) ? null : Integer.valueOf($F{Value})

Thank yoy very much.

[Thomas Zimmer]

That was NOT your question ("... count values lower than a given number ..."). Like this, the answer was another one...

;-)