I’m trying to use a simple keychain expression that checks the value of a boolean and returns yes or no to the report. When I run the report, the expression doesn’t seem to evaluate. I’ve placed it below.
@manual_entry == “true”?“Yes”:“No”@
I’ve tried testing for both “true” and “1” with no success. This seems like a bug. I’m using version 7.9.5.
To clarify, I’m reading a value from a SQL database that is a “bit” type. When I run the report without the expression, the values “true” and “false” are returned.