And/or filter field not enabled in the group filter tab

Howdy,

I have a table that has a group. In this group, I want to filter by 2 different expressions, concatenated with an OR. BUT I can't change the "And/Or" column value for the first entry because it is grayed out. The column will automatically change to an OR value if both my expression column fields are the same (which I don’t want) but if I put any other value in to the expression field of the second row, the "And/Or" field of the first row automatically changes to an AND.

PLEASE! How do I get the And/Or field "ungrayed" so I can change it to what I want?

The 2 filters I and using check the UserID = to the user, and the other is checking a count to get the Top N 1. (So just showing the current user and the top producer)

The OR gets only enabled if the filter expressions of two filters are identical.

Note: another option is to use OR directly in your filter expression. Example:
Filter expression: =(condition1 OR condition2)
Filter type: =
Filter value: =True

-- Robert

|||

Ok,

Is there any plans to make it a changeable field? a couple online articles made it sound like you could choose, rather than it auto populating.

|||Check the Product Feedback Center

http://lab.msdn.microsoft.com/productfeedback/|||Nathan,

Please corrobate the issue here:

file:///C:/Documents%20and%20Settings/chauvinr/Desktop/MSDN%20Product%20Feedback%20Center.URL

|||

"The OR gets only enabled if the filter expressions of two filters are identical."

Who's idea was this?

What is the logic behind making this kind of decision?

I just can't comprehend someone deisgning an application like RS and saying... "lets ONLY give them an OR if the fields used in the field expression is identical"

|||I couldnt imaginge it too having only identical field to use OR.|||

But I realy need to put a Or with different expressions, like "pruductId< 100 or quantity>10"....
Isn’t it possible?

|||

Yes, it is possible. Take a look at Robert's reply post on this thread.

Jarret

|||Sorry but I can't understand....

Filter expression: =(pruductId< 100 or quantity>10)
Filter type: =
Filter value: = ?

But what I have to put on value?

I will apreciate your help.
Thanks.

|||Put '=True' as the value (without the single quotes).|||it only work with the expression:
=IIf((productId >100 or quantity<200), "True"," False")

Many thanks.