# Reporting checkboxes? **URL:** \ **Category:** Ignition\ **Created:** [March 26, 2018, 8:19pm UTC](https://forum.inductiveautomation.com/t/reporting-checkboxes/17503 "2018-03-26T20:19:40Z")\ **Posts on this page:** 19\ **Page:** 1
**Author:** ![khashey.ahmed](https://avatars.discourse-cdn.com/v4/letter/k/c5a1d2/32.png) [@khashey.ahmed](https://forum.inductiveautomation.com/u/khashey.ahmed)\ **Post date:** [March 26, 2018, 8:19pm UTC](https://forum.inductiveautomation.com/t/reporting-checkboxes/17503/1 "2018-03-26T20:19:40Z")
Hi all, I am designing some pdf reports? Is there anyway I can add check boxes on them?? Thanks, Khashey ---
**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\ **Post date:** [March 26, 2018, 8:32pm UTC](https://forum.inductiveautomation.com/t/reporting-checkboxes/17503/2 "2018-03-26T20:32:31Z")
You could use unicode char 2611, ‘BALLOT BOX WITH CHECK’: > **[BALLOT BOX WITH CHECK (U+2611)](https://www.fileformat.info/info/unicode/char/2611/index.htm)** > > Get the complete details on Unicode character U+2611 on FileFormat.Info ☑ Will require a font that supports unicode characters, but most modern stuff should. ---
**Author:** ![khashey.ahmed](https://avatars.discourse-cdn.com/v4/letter/k/c5a1d2/32.png) [@khashey.ahmed](https://forum.inductiveautomation.com/u/khashey.ahmed)\ **Post date:** [March 26, 2018, 8:41pm UTC](https://forum.inductiveautomation.com/t/reporting-checkboxes/17503/3 "2018-03-26T20:41:41Z")
Hi PGriifth, Thanks, And How would I link this to data? Thanks, Khashey ---
**Author:** ![KathyApplebaum](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/kathyapplebaum/32/7261_2.png) [@KathyApplebaum](https://forum.inductiveautomation.com/u/KathyApplebaum)\ **Post date:** [March 26, 2018, 9:27pm UTC](https://forum.inductiveautomation.com/t/reporting-checkboxes/17503/4 "2018-03-26T21:27:44Z")
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](https://us1.discourse-cdn.com/inductiveautomation/original/2X/a/a015855451a0005d107c97d5e4c1cf1399964cbf.proj) (6.4 KB) ---
**Author:** ![khashey.ahmed](https://avatars.discourse-cdn.com/v4/letter/k/c5a1d2/32.png) [@khashey.ahmed](https://forum.inductiveautomation.com/u/khashey.ahmed)\ **Post date:** [March 26, 2018, 10:52pm UTC](https://forum.inductiveautomation.com/t/reporting-checkboxes/17503/5 "2018-03-26T22:52:31Z")
Thanks alot work like wonders Kathy ---
**Author:** ![khashey.ahmed](https://avatars.discourse-cdn.com/v4/letter/k/c5a1d2/32.png) [@khashey.ahmed](https://forum.inductiveautomation.com/u/khashey.ahmed)\ **Post date:** [April 3, 2018, 10:02pm UTC](https://forum.inductiveautomation.com/t/reporting-checkboxes/17503/6 "2018-04-03T22:02:10Z")
sorry I had one more question do you know anyway where we can display null value in report as empty rather than \ or N/A ---
**Author:** ![Brian](https://avatars.discourse-cdn.com/v4/letter/b/97f17d/32.png) [@Brian](https://forum.inductiveautomation.com/u/Brian)\ **Post date:** [April 3, 2018, 10:25pm UTC](https://forum.inductiveautomation.com/t/reporting-checkboxes/17503/7 "2018-04-03T22:25:28Z")
I’m assuming it’s a table you are working with… If so, select the cell that you want to behave this way. In the property inspector, there should be a Null Value entry. Change that to something else. I had to put a space character there for my reports, if I remember correctly. ![](https://us1.discourse-cdn.com/inductiveautomation/original/2X/2/237608065588ce020ad0ab7b36e0a8a9af7b0a63.png) ---
**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\ **Post date:** [April 3, 2018, 10:40pm UTC](https://forum.inductiveautomation.com/t/reporting-checkboxes/17503/8 "2018-04-03T22:40:58Z")
You can also change the ‘String for Null’ property for the entire report: [https://docs.inductiveautomation.com/display/DOC79/Report+Component+-+Report+Object](https://docs.inductiveautomation.com/display/DOC79/Report+Component+-+Report+Object) ---
**Author:** ![khashey.ahmed](https://avatars.discourse-cdn.com/v4/letter/k/c5a1d2/32.png) [@khashey.ahmed](https://forum.inductiveautomation.com/u/khashey.ahmed)\ **Post date:** [April 10, 2018, 6:39pm UTC](https://forum.inductiveautomation.com/t/reporting-checkboxes/17503/9 "2018-04-10T18:39:04Z")
Hi All, Sorry to bother again.I have another report coming up here is my question: I am using a querry currently to populate a table on window.My question is how can we call dataset in report.For example my querry returns hourly downtime in 8 h .How can i do that on report. Thanks Again ---
**Author:** ![KathyApplebaum](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/kathyapplebaum/32/7261_2.png) [@KathyApplebaum](https://forum.inductiveautomation.com/u/KathyApplebaum)\ **Post date:** [April 10, 2018, 10:16pm UTC](https://forum.inductiveautomation.com/t/reporting-checkboxes/17503/10 "2018-04-10T22:16:16Z")
Your query will be a datasource, and you’ll use that datasource in your report Here’s the Inductive University video on data in reporting: [report data](https://www.inductiveuniversity.com/video/report-data/7.9) and the video on designing reports: [report designer](https://www.inductiveuniversity.com/video/report-designer/7.9) ---
**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:38pm UTC](https://forum.inductiveautomation.com/t/reporting-checkboxes/17503/11 "2022-04-21T19:38:37Z")
I like this method but question - how would I bring this out from my datasource? Tried `SELECT IF(someCondition, 'U+2611', '')` but just appears as U+2611 on the report now. ---
**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\ **Post date:** [April 21, 2022, 7:45pm UTC](https://forum.inductiveautomation.com/t/reporting-checkboxes/17503/12 "2022-04-21T19:45:42Z")
Depends on your DB flavor. E.G. SQLite has a `CHAR` builtin: `SELECT CHAR(9745)`. ---
**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:49pm UTC](https://forum.inductiveautomation.com/t/reporting-checkboxes/17503/13 "2022-04-21T19:49:26Z")
Using MySQL. Just tried SELECT CHAR(2611) But that comes through as a blob in my workbench which the report then seems to interpret as a NULL value. ---
**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\ **Post date:** [April 21, 2022, 7:53pm UTC](https://forum.inductiveautomation.com/t/reporting-checkboxes/17503/14 "2022-04-21T19:53:20Z")
[https://dev.mysql.com/doc/refman/8.0/en/string-functions.html#function\_char](https://dev.mysql.com/doc/refman/8.0/en/string-functions.html#function_char) `CHAR(X'2611' using utf8)` perhaps? ---
**Author:** ![Priyanka.Khandge](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/priyanka.khandge/32/35989_2.png) [@Priyanka.Khandge](https://forum.inductiveautomation.com/u/Priyanka.Khandge)\ **Post date:** [March 10, 2023, 2:23pm UTC](https://forum.inductiveautomation.com/t/reporting-checkboxes/17503/15 "2023-03-10T14:23:53Z")
![report](https://us1.discourse-cdn.com/inductiveautomation/original/3X/0/7/07dd23ea7c034e45aa16a51d68afa22543dccaba.png) Hi @KathyApplebaum, Can explain in more detail? I have tried to display the checkbox in the report but I'm not able to display it properly. every time shows an empty checkbox. ---
**Author:** ![Corey\_Manshack](https://avatars.discourse-cdn.com/v4/letter/c/e95f7d/32.png) [@Corey\_Manshack](https://forum.inductiveautomation.com/u/Corey_Manshack)\ **Post date:** [January 30, 2024, 5:55pm UTC](https://forum.inductiveautomation.com/t/reporting-checkboxes/17503/16 "2024-01-30T17:55:49Z")
It's the modulus operator. It means divide by whatever number is after the operator and give the remainder. If your checkbox value source is 1/0 and/or True/False this should work. It's the same as this in python -\> ```auto a = 1 b = ("false" if a % 2 == 0 else "true") print (b) ``` The example seems to be backward and the logic should be the following: `@AwSVKataster.eoh % 2 == 0 ? "☐": "☑" @` ---
**Author:** ![seancourtney](https://avatars.discourse-cdn.com/v4/letter/s/43a26b/32.png) [@seancourtney](https://forum.inductiveautomation.com/u/seancourtney)\ **Post date:** [March 11, 2025, 5:19pm UTC](https://forum.inductiveautomation.com/t/reporting-checkboxes/17503/17 "2025-03-11T17:19:01Z")
Is there anything wrong with this syntax, this 'verified value comes from a bool and the database query browser shows values for true and false, but the keychain expression returns the value for true every time. @verified == true ? "☑": "☐" @ ---
**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\ **Post date:** [March 11, 2025, 5:25pm UTC](https://forum.inductiveautomation.com/t/reporting-checkboxes/17503/18 "2025-03-11T17:25:26Z")
Don't _compare_ booleans. Just **use** them. Like `@verified ? "☑" : "☐" @` ---
**Author:** ![seancourtney](https://avatars.discourse-cdn.com/v4/letter/s/43a26b/32.png) [@seancourtney](https://forum.inductiveautomation.com/u/seancourtney)\ **Post date:** [March 11, 2025, 5:44pm UTC](https://forum.inductiveautomation.com/t/reporting-checkboxes/17503/19 "2025-03-11T17:44:19Z")
That worked, thanks pturmel !