cancel
Showing results for 
Search instead for 
Did you mean: 

Boolean as command parameter

Former Member
0 Kudos

I have a WHERE clause in my query which applies only if the boolean parameter is true/checked. Problem is it's not working. How do I make it right?

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

UP

I tried {?Param1} = 1 and it works only when the checkbox is checked otherwise it shows an empty report. Does a boolean parameter return 1/0?