I would like to filter a report using multiple Like conditions
or - Change a filter in Reporting Services to OR rather than AND..
Example: (SameFieldName Like *1100) or (SameFieldName Like *1200).
When I try doing this on the Report's table properties - Filters tab - the And/Or automatically changes to "And" with using the "Like" Operator.
The only time "Or" appears is when I use the " = " Operator.
Or can someone show me how to use an expression to filter on multiple Like conditions.
Thanks!
Try the following filter:
Filter expression:
=(Fields!FName.Value like "*1100" OR Fields!FName.Value like "*1200")
Filter operator:
=
Filter value:
=True
-- Robert
|||You got it! It works!Thank you
BBK
No comments:
Post a Comment