SQL Report Filter only allows ANDs

Posted By: qwert231 | Oct 8th @ 11:17 AM
page 1 of 1
Comments: 2 | Views: 529
#Oct 8th @ 11:17 AM
qwert231
qwert231
M Kenyon

I want to do a simple filter on a report,

(Field1 <> Field2) or (Field3 <> Field4)

 

So, if the first set or the second set are not equal, show the results. (We may have the first set be equal, but not the second set, and we want to see that.)

 

So, in my table's Filters dialog, I do

Expression: Field1

Operator: !=

Value: Field2

 

Expression: Field3

Operator: !=

Value: Field4

 

the And/Or column for the first filter, shows 'and', and I cannot change it.

 

How do I get the filter I want?

#Oct 9th @ 8:30 AM
qwert231
qwert231
M Kenyon

Hmm... no answers... usually, when nobody answers a question, it's a really simple answer. I've googled, and haven't found anything.

 

I tried doing this:

Expression: (Field1 <> Field2) or (Field3 <> Field4)

Operator: =

Value: True    (I've also tried 1)

 

But that gives me:

The processing of FilterExpression for the table 'table1' cannot be performed. Cannot compare data of types System.Boolean and System.String.

 

#Oct 9th @ 9:38 AM
qwert231
qwert231
M Kenyon

Ahh... this worked:

Expression: (Field1 <> Field2) or (Field3 <> Field4)

Operator: =

Value: CBool(1)

page 1 of 1
Comments: 2 | Views: 529
Microsoft Communities