Display boolean column as checkbox

Hi

I have a table in my BIRT report which is linked to a mySQL database table having a boolean column. The values in the column are shown in BIRT as "true" or "false".

Is it possible to instead display them as a checkbox; being checked if the value is true and unchecked if the value is false?

Find more posts tagged with

Comments

mwilliams

Hi Mihsah,

This sounds like something you could do by inserting an image of a checked box when the value is true and the image of an empty box when the value is false. I don't know that there is anything built in like this. I'd have to check it out.

Mihsah

Thanks. Inserting a conditional image will work fine!

Mr.Reed

Hi there,

is there any other solution by now then displaying images (doesn't feel like the right way for me)?
I'd like to generate a pdf and putting checkboxes on it, checked if a boolean is true, not checked if a boolean is false.

It should be possible to extend birt by writing a new report item to get a standard solution for this problem? Isn't there maybe a solution by now?

Thanks in advance.

mwilliams

You might be able to build an html checkbox for display in a text control to do this rather than using an image. I haven't done it, but it should be possible.

Let me know if you have questions.