# Boolean property binding in a report not working

**URL:** <https://forum.inductiveautomation.com/t/boolean-property-binding-in-a-report-not-working/107637>\
**Category:** Ignition\
**Tags:** perspective\
**Created:** [June 20, 2025, 7:53pm UTC](https://forum.inductiveautomation.com/t/boolean-property-binding-in-a-report-not-working/107637 "2025-06-20T19:53:33Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Ryan\_Deardorff](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/ryan_deardorff/32/63815_2.png) [@Ryan\_Deardorff](https://forum.inductiveautomation.com/u/Ryan_Deardorff)\
**Post date:** [June 20, 2025, 7:53pm UTC](https://forum.inductiveautomation.com/t/boolean-property-binding-in-a-report-not-working/107637/1 "2025-06-20T19:53:33Z")

</div>

Thanks to @paul-griffith, I've figured out how to use a nested query to populate a chart for an arbitrary number of machines in a Report. I have it layed out so that four charts fit on each page. I want the legend to only appear once per page, so I created a legend column in the query data to bind to the legend visible property of the chart, but neither values of 'true/false' or 0/1 seem to work:

```python
CASE 
	WHEN ROW_NUMBER() OVER (ORDER BY cnt.prod_date) % 4 = 0 THEN 'true' 
	ELSE 'false'
END AS legend

```

```python
CASE 
	WHEN ROW_NUMBER() OVER (ORDER BY cnt.prod_date) % 4 = 0 THEN 1 
	ELSE 0
END AS legend

```

The data in the XML correctly shows every fourth entry having either 1 or 'true' (if I don't include the quotation marks in the query it shows as a 1/0). How can I return a value that will bind properly to a boolean property?

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

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

---

<div class="post-metadata">

**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:** [June 20, 2025, 8:07pm UTC](https://forum.inductiveautomation.com/t/boolean-property-binding-in-a-report-not-working/107637/2 "2025-06-20T20:07:58Z")

</div>

Try returning `'true'` (really, any string) and `NULL`; per:

> **[Keychain Expressions | Ignition User Manual](https://docs.inductiveautomation.com/docs/8.1/ignition-modules/reporting/report-design/data-keys/keychain-expressions#operators-and-functions)**
>
> It's possible to perform calculations on data keys. This section documents the various operators and functions that are available.

Which ultimately comes from:

> **[keychains.pdf](https://www.reportmill.com/support/keychains.pdf)**
>
> 73.27 KB

> The second is that RM will evaluate 'null' as false and non-null as true

---

<div class="post-metadata">

**Author:** ![Ryan\_Deardorff](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/ryan_deardorff/32/63815_2.png) [@Ryan\_Deardorff](https://forum.inductiveautomation.com/u/Ryan_Deardorff)\
**Post date:** [June 20, 2025, 8:20pm UTC](https://forum.inductiveautomation.com/t/boolean-property-binding-in-a-report-not-working/107637/3 "2025-06-20T20:20:02Z")

</div>

Thanks, that does work...but so do 1/0 and 'true/false' it turns out. The real problem was that I put the legend calculation into the _sub_-query, not the machines query, so it was applying to the _chart_ data rows...