Skip to Content

Boolean as command parameter

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?

param.jpg (102.4 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • May 16, 2017 at 07:50 PM

    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?

    Add comment
    10|10000 characters needed characters exceeded