Displaying a checkmark in a report?

[bkarabinchak.psi]

Have a report with a table. One of the columns is boolean. I want to show a check mark if it the value is 1 and nothing if it is zero. How can I accomplish this?

Right now part of our datasource query is manually selecting a checkmark character instead of a 1, but this does not come through on the PDF Viewer when viewing a saved PDF from the db.

[josborn]

There is a topic that talks about doing something similar, should get you started.

Reporting checkboxes?

You can use a keychain expression. For example, to get a checked box when a number is even and an empty box when it’s odd, I can use the keychain expression @Number % 2 == 0 ? "": "☐" @ , assuming my table has a key called Number.checkboxes.proj (6.4 KB)