Boolean property binding in a report not working

Ignition
1

Thanks to @PGriffith, 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:

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

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
image452×514 21.6 KB

image
image1139×799 145 KB

2

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

Which ultimately comes from:

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

3

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...

2 Likes