FortesReport checkbox

[JanRoza]

I have a database (SQLite) with a boolean field and want to print that with FortesReport.
Now FortesReport prints "yes" or "no" in the report but I want this to be printed as a checkbox.
Is there a way to do this in FortesReport?

[balazsszekely]

You have bands and OnBeforePrint event in fortesreport. Place two image(TRLImage) on the band, overlapping each other. Load a checked checkbox image in the first and an unchecked checkbox image in the second TRLImage. Now toggle the visibility in function of your boolean field.

Code: Pascal  [Select][+][-]

1. ImageChecked.Visible := SQLQuery.FieldByName('MyBooleanField').AsBoolean = True;
2. ImageUnchecked.Visible := not ImageChecked.Visible;

[JanRoza]

Thanks GetMem,

That's a neat solution that will do fine.