# Reporting Dynamic Data Key Help

**URL:** <https://forum.inductiveautomation.com/t/reporting-dynamic-data-key-help/113791>\
**Category:** Ignition\
**Created:** [February 5, 2026, 5:10pm UTC](https://forum.inductiveautomation.com/t/reporting-dynamic-data-key-help/113791 "2026-02-05T17:10:12Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![jonathanf](https://avatars.discourse-cdn.com/v4/letter/j/eb8c5e/32.png) [@jonathanf](https://forum.inductiveautomation.com/u/jonathanf)\
**Post date:** [February 5, 2026, 5:10pm UTC](https://forum.inductiveautomation.com/t/reporting-dynamic-data-key-help/113791/1 "2026-02-05T17:10:12Z")

</div>

Hi,

How do I get dynamic data keys to work with MS SQL Bit data types?

In the example below I'm trying to use the visible key to make the circle appear around the Yes or No if the SQL field is True or False.

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/5/7/578e1a837ad713914bfa7c5c15699efdc81f0916.png)

I have tried `query2.trailerCleanSafe == 1` and `query2.trailerCleanSafe == 0`, which will always make both items visible.

![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/3/a/3a01623082a25e530819c7a780fa36dd4d1c957a.png)

And `query2.trailerCleanSafe == True` and `query2.trailerCleanSafe == False` , which will always make both items not visible.

I can get it to work with other SQL data types.

My workaround has been to change the data type in my SQL query before using it in the data key.

---

<div class="post-metadata">

**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:** [February 5, 2026, 5:20pm UTC](https://forum.inductiveautomation.com/t/reporting-dynamic-data-key-help/113791/2 "2026-02-05T17:20:25Z")

</div>

Don't use `==` or `!=` comparisons with values that are booleans. Just put `value` to check for true, and use `!value` to check for false.

---

<div class="post-metadata">

**Author:** ![jonathanf](https://avatars.discourse-cdn.com/v4/letter/j/eb8c5e/32.png) [@jonathanf](https://forum.inductiveautomation.com/u/jonathanf)\
**Post date:** [February 5, 2026, 5:28pm UTC](https://forum.inductiveautomation.com/t/reporting-dynamic-data-key-help/113791/3 "2026-02-05T17:28:37Z")

</div>

That worked!

Thanks, I’ve been trying to figure that out for 2 days 😆 .