Hi All,
I’m try to add this boolean filter that is also visible on the UI.
The true value seems to be working but when the checkbox is unselected on the UI, it doesnt fetch any data from the system.
I appreciate all the help.
Thanks,
Question
Boolean Filter on Report Designer not working
You need to have something like this ( @QC IsNull OR YourDAC.YourField Equal @QC)
You need to have something like this ( @QC IsNull OR YourDAC.YourField Equal @QC)
Hi,
It’s still giving me the same result.
Below is the UI checkbox.
And below is the schema builder relationship.The checkbox is present under the PREmployee table. Maybe it has something to do with the relationship?
+1hi
I think the problem here may be from the table value itself. Can you try to add: OR YourDAC.YourField isNull to this: @QC IsNull OR YourDAC.YourField Equal @QC.
I think that the value in the table is null and not false, in that case this behavior would be expected.
Also please check the brackets for the whole part to be correct
hi
I think the problem here may be from the table value itself. Can you try to add: OR YourDAC.YourField isNull to this: @QC IsNull OR YourDAC.YourField Equal @QC.
I think that the value in the table is null and not false, in that case this behavior would be expected.
Also please check the brackets for the whole part to be correct
I did add the two lines that you mentioned on the filter section.
+1
I am asking to add Or PREmployee.UsrQCEmpl… isNull to the last brackets
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.