I am trying to pass boolean values to a report from Xojo. Using/passing only string values works fine.
I have defined some parameters as boolean. Because of issues trying to use the parameter directly in a print_if conditional (see below), I included the parameter in the query. But since the function SetParameterValue only takes string values, I have to pass string values of "true" or "false", which then generates this valentina exception:
Datasource error: "ERROR: failed to find conversion function from unknown to boolean".
On the print_if conditional issue, I was trying to do as discussed here, but no matter what types and values I use, I can't get it to work. It always gives the following error in preview within studio:
Page 1: ERROR: syntax error at or near "$"
Seems like print_if can't use parameters.