I'm using a Filter for the first time.
In the Dataset Properties dialog box in the Filters tab I clicked on Add then selected the field I want to filter on from the Expression dropdown list. SSRS recognizes the field as a Boolean. (The field is defined as BIT, NOT NULL in the source table.)
The Operator is "=".
In the Value field I've tried 1, "1", 0, True, "True", YES, and "YES". Each of them causes a dialog box to pop up saying "<Value>
Value is not a boolean."
What value should I use for a boolean in this context?
Thanks in advance for any assistance.