print dash when value is ZERO

[atmaling]

HI All,

While using iReport i got one problem.

I am displaying values from a table. column fields are "name","roll","marks".

I want to display dash i.e. "--" when the value of "marks" field is ZERO.

As now I am getting following output.

Name    Roll    Marks

John    51    66

Tom    21    0

Harry    12    0

 

Expected Output

 

I want following OUTPUT

Name    Roll    Marks

John    51    66

Tom    21    --

Harry    12    --

 

 

Please help me

 

Thanks in Advance

Code:

Code:

[code]

Code:

[code]

Code:

[code]

[C-Box]

Use this for the TextExpression:

 

Code:

(BigDecimal.ZERO)equals($F{marks})?"--":$F{marks}.toString()

 

(assume, that your field "marks" is BigDecimal!?!?

Should work.

 

hth

C-Box

[atmaling]

Thanks friend, CBox....

 

I tried ur method but its giving error as "BigDecimal.ZEROÂcannotÂbeÂresolvedÂtoÂaÂtype".

I dont know too much about iReport.

 

PLzz help me.

 

Thanks in advance.

[C-Box]

Hmmm

 

perhaps I forgot just a point before equals (answered just from mind, without any iReport/IDE open)

 

try this one:

 

Code:

(BigDecimal.ZERO).equals($F{marks})?"--":$F{marks}.toString()

 

This is just a simple Java comparison.

 

Means:

 

If your field "marks" is BigDecimal Zero than print "--" otherwise print the content of your field "marks"

 

hth now

C-Box

[C-Box]

otherwise try this:

 

Code:

(BigDecimal.ZERO.compareTo($F{marks}) == 0)?"--":$F{marks}

 

this should also work.

C-Box

 

(Still assume, that your field is of type "BigDecimal")

[atmaling]

Thanks very much friend.

BUt this is not working. Its giving error message as "IncompatibleÂconditionalÂoperandÂtypesÂStringÂandÂBigDecimal"

 

But I did by other method and its working fine.

I changed the field type "marks" to String and then I wrote following expression in Text field expression

"$F{marks}.equals("0") ? "--" : $F{marks}"

 

make sure that "marks" field should be String

[C-Box]

That's why I wrote:

 

(Still assume, that your field is of type "BigDecimal")

 

But anyway, fine if it's working now! :-)

 

regards

C-Box

[ramy]

I have a similar question to the one above except that I'd like to keep my output as a double. So, my code looks like this:

 

($F{WinnersReturn} == null) ? "N/A" : $F{WinnersReturn}

 

The reason I don't want to use the "toString()" function at the end of $F{WinnersReturn} is because I want to format the output to a percentage if the field is NOT NULL.

I tried tricking it into thinking "N/A" was a double by doing:

new Double("N/A")

but, obviously, that gave me an error while filling.

Thanks in advance,

_ramy