Replace True/False to Yes/No in Boolean?

[markos17]

How can I replace boolean values, so in report it would be Yes/No instead of True/False?

[svenn]

( your boolen field == Boolean.TRUE ? "Yes":"No")

[markos17]

Thanks for reply. Anyway, I still have problems with that. I've tried to use Your syntax in report, eg.

$F{(Field_1 == Boolean.TRUE ? "Yes":"No")}

 

or in SQL:

SELECT xyz

FROM XYZ .abc

WHERE

Field_1 == Boolean.TRUE ? "Yes":"No"

 

and still get errors messages. Where should I set this syntax?

Post Edited by markos17 at 08/12/2009 13:37

[svenn]

You use that syntax in the textfield element not in your SQL.

[markos17]

I am giving up :) all the time I get message: "Cannot cast from String to Boolean".

The thing is, that Boolean class is set in my_field: ($F{my_field}==Boolean.TRUE?"Yes":"No")

I also tried to use variable, all the time the same error.

 

EDIT:

Problem solved. I had to change class of the field in report into String.

Post Edited by markos17 at 08/13/2009 12:02

[dineshsankaran90]

Try this:

( your boolen field == true ? "Yes":"No")

eg:  $P{Expired_ID}==true? "Yes":"No"