# How to address the bit level of a integer value in a report query

**URL:** <https://forum.inductiveautomation.com/t/how-to-address-the-bit-level-of-a-integer-value-in-a-report-query/86368>\
**Category:** Ignition\
**Tags:** ignition79, reporting\
**Created:** [February 26, 2024, 3:57pm UTC](https://forum.inductiveautomation.com/t/how-to-address-the-bit-level-of-a-integer-value-in-a-report-query/86368 "2024-02-26T15:57:12Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![koenigs.alex](https://avatars.discourse-cdn.com/v4/letter/k/919ad9/32.png) [@koenigs.alex](https://forum.inductiveautomation.com/u/koenigs.alex)\
**Post date:** [February 26, 2024, 3:57pm UTC](https://forum.inductiveautomation.com/t/how-to-address-the-bit-level-of-a-integer-value-in-a-report-query/86368/1 "2024-02-26T15:57:12Z")

</div>

I have an integer valve being stored in my database. The integer is used as bits that represent boolean statuses. Is it possible to either query just one of the bits or address the bit level of my integer after the query?

---

<div class="post-metadata">

**Author:** ![Transistor](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/transistor/32/3380_2.png) [@Transistor](https://forum.inductiveautomation.com/u/Transistor)\
**Post date:** [February 26, 2024, 4:57pm UTC](https://forum.inductiveautomation.com/t/how-to-address-the-bit-level-of-a-integer-value-in-a-report-query/86368/2 "2024-02-26T16:57:20Z")

</div>

I've never done it but see if [Keychain Expressions | Ignition User Manual](https://docs.inductiveautomation.com/docs/8.1/ignition-modules/reporting/report-design/data-keys/keychain-expressions) is of any help.

---

<div class="post-metadata">

**Author:** ![koenigs.alex](https://avatars.discourse-cdn.com/v4/letter/k/919ad9/32.png) [@koenigs.alex](https://forum.inductiveautomation.com/u/koenigs.alex)\
**Post date:** [February 29, 2024, 1:15pm UTC](https://forum.inductiveautomation.com/t/how-to-address-the-bit-level-of-a-integer-value-in-a-report-query/86368/3 "2024-02-29T13:15:45Z")

</div>

Thanks for the suggestion. But after reading about keychain expressions I don't think they work in reporting.

---

<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 29, 2024, 1:29pm UTC](https://forum.inductiveautomation.com/t/how-to-address-the-bit-level-of-a-integer-value-in-a-report-query/86368/4 "2024-02-29T13:29:05Z")

</div>

> [@koenigs.alex](#):
>
> reading about keychain expressions I don't think they work in reporting.

?

Keychain expressions _ **only** _ work in reporting.