Post reply

"Value is not a boolean" error for filter based on a boolean ... what value should I use for True?

  • July 24, 2012 at 1:40 pm

    #1517052

    Remember that bit is not boolean, so you have to compare it to 1.

    e.g. bit_field = 1

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

  • July 25, 2012 at 8:18 am

    #1517384

    Hopefully you'll be able to see the screenshot I uploaded.

    I've come up with a workaround using expressions, but to my mind the approach shown in the screenshot SHOULD work.

    I'm going to write it off to an idiosyncracy.

    Chris

  • July 25, 2012 at 9:04 am

    #1517418

    That's the problem we face when SQL Server does not use the same datatypes for all of its tools.

    the value you're looking for should be: true (with no quote marks).

    I'm relatively new to SSRS too, but I'm using 2008 and it works fine.

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

  • July 25, 2012 at 10:06 am

    #1517473

    Good job!

    I tried using True yesterday but it kept throwing the error.

    Today when I use True (it's not case sensitive because I tested true, True, TRUE) SSRS accepted the Value.

    Go figure.

    Thanks again

Viewing 4 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply