Table "Or" Filter Expression in SSRS 2005  - How to get "Or" Fileter Expression

SQLNewBieUSA
SQLNewBieUSA used Ask the Experts™
on
Hi,

I would like to Apply Filter on Table Using OR Operator.

But reporting Services is not allowing. But Default SSRS considers AND Operator Between two Filter Expression.

=Field!Column1.Value != 0  

OR

=Field!Column2.Value!= 0

This above Expresison, i would like to write in Table Filter Tab.



Any thoughts ?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
are you trying to hide a column or what?

Author

Commented:
No, I am trying to Filter dataset rows based on filter condition.
what is the condition you want to test on the detail row?
 

Author

Commented:
pls close this question.
I developed another RDL to managed this issue and got solution.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial