suppress leading zeroes in a crosstab

[jkeri]

I created my first crosstab report and some of the cells have zero value and its printing a zero.. I want the cell to be blank if its a zero.

 

Im not a Java devloper, is there any way I can supress the zero values?

 

 

[lisaws]

You can use an expression:

$F{field} == 0 ? "" : $F{field}

Which reads "If value is zero, print blank cell. Otherwise print the value"

 

[lisaws]

deleted

[nessrineselmi215]

hi lisazollwakana

can u help  me to resolve my problem

How to modify a report template ".jasper"???

 

[jkeri]

I just checked my code, looks like the field i want is a measured field   $V{AMOUNT_MEASURE} == 0? "":$V{AMOUNT_MEASURE}     if the value  is zero then print blanks.

 

When i do this expression i get 'incompatiable operands types BigDecimcal and int'

 

 

[lisaws]

How about: $V{AMOUNT_MEASURE}.equals(0)? "":$V{AMOUNT_MEASURE}

 

[jkeri]

$V{AMOUNT_MEASURE}.equals(0)? "":$V{AMOUNT_MEASURE}

 

I tried that ExPRESSION  and got :     java.math.BigDecimal cannot be cast to java.lang.String  error

[jkeri]

This is the correct EXPRESSION that i needed:                            new Boolean($V{AMOUNT_MEASURE}.toString().equals("0"))? " ":$V{AMOUNT_MEASURE}

 

This work... thank you for pointing me in the right direction and your time.