iReport Checkbox

[Pdor]

Hi all

I've create a report with iReport, that contain a field that diplay a "checkbox" field of SugarCRM.
On report, if the checkbox is select, give me result of "true".
My question is: there is a way to display on report another "custom text" instead of "true" text???

Thanks in advance.

[Markku]

You can probably use the following example to convert true/false values to something else.

Name of the table is "test_table" and first row contains field names.

name		true_false_field
Company A 	true
Company B 	false
Company C   NULL

Query:

Select name, 
(case 
when (true_false_field = "true") then "Field value is true" 
when (true_false_field = "false") then "Field value is false"
else "Field value is something else" end) AS true_false_field 
from test_table

and the result should be:

name 		true_false_field
Company A 	Field value is true
Company B 	Field value is false
Company C 	Field value is something else