How to display TRUE if my field value is 1

[technicalguy]

Hi

I am new to jReports and I am trying to write an expression. The underlying field is INT and it stores 1 or 0 I would like to display on the reoprt TRUE if the value is 1 and FALSE if the value is 0.

How may this be done please.

Ivan

Post Edited by icarey at 04/06/2011 11:58

[dgangstaz]

 Try this:

$F{int_field}==1?'TRUE': 'FALSE'

[technicalguy]

Thank you for your reply

I tried this and the field goes blank

 

[dgangstaz]

http://books.google.com/books?id=GeLCEnT1VpMC&pg=PA22&lpg=PA22&dq=ireports+field+groovy&source=bl&ots=acR5wMk4y0&sig=yFZrJQnPWmGRa1UzOfTR2oP6JMQ&hl=ro&ei=ELGdTbM_jd2yBovtjb0E&sa=X&oi=book_result&ct=result&resnum=3&ved=0CCgQ6AEwAg#v=onepage&q&f=false

[kalvarez]

Hi!!

The field is an integer, and you want to show a string, so you have to set the expression class as java.lang.string

$F{int_field}==1?'TRUE': 'FALSE'

 

 

[dgangstaz]

Indeed, I forgot to mention this

[technicalguy]

Thans everyone.

I can now display this on the report. I am using the XML generated file and parse it to phpjasperxml which then uses fpdf to produce a pdf of the report. When using an expression to dipslay TRUE FALSE the field appears blank on the pdf. If i just leave the feild as is it displays 1 or 0. I would like to be able to display in the pdf TRUE or FALSE.

I have been able to display on the pdf as I require by placing an IF in the SQL select statment

IF(`WorkRelated` = 1, 'TRUE', 'FALSE')

Ivan

Post Edited by icarey at 04/09/2011 03:06