# Displaying a checkmark in a report?

**URL:** <https://forum.inductiveautomation.com/t/displaying-a-checkmark-in-a-report/58715>\
**Category:** Ignition\
**Tags:** ignition80\
**Created:** [April 21, 2022, 7:31pm UTC](https://forum.inductiveautomation.com/t/displaying-a-checkmark-in-a-report/58715 "2022-04-21T19:31:23Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![bkarabinchak.psi](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/bkarabinchak.psi/32/83567_2.png) [@bkarabinchak.psi](https://forum.inductiveautomation.com/u/bkarabinchak.psi)\
**Post date:** [April 21, 2022, 7:31pm UTC](https://forum.inductiveautomation.com/t/displaying-a-checkmark-in-a-report/58715/1 "2022-04-21T19:31:23Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![josborn](https://avatars.discourse-cdn.com/v4/letter/j/4bbf92/32.png) [@josborn](https://forum.inductiveautomation.com/u/josborn)\
**Post date:** [April 21, 2022, 7:35pm UTC](https://forum.inductiveautomation.com/t/displaying-a-checkmark-in-a-report/58715/2 "2022-04-21T19:35:17Z")

</div>

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

> [@Reporting checkboxes?](https://forum.inductiveautomation.com/t/reporting-checkboxes/17503/4):
>
> 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 ? "ballot_box_with_check": "☐" @ , assuming my table has a key called Number.[checkboxes.proj](https://us1.discourse-cdn.com/inductiveautomation/original/2X/a/a015855451a0005d107c97d5e4c1cf1399964cbf.proj) (6.4 KB)
