Filter problem -- sql server reporting services

sql server reporting services : Filter problem

Robert Bruckner [MSFT]
12/27/2004 2:29:34 PM

The OR is only available if you use multiple filter expressions and they are
identical.

Also, you can write filter expressions like this:
Expression: =(Fields!A.Value = "A") OR (Fields!B.Value = "B")
Operator: =
Value: =True

--
This posting is provided "AS IS" with no warranties, and confers no rights.

[quoted text, click to view]

Jeff A. Stucker
12/27/2004 3:17:07 PM

I noticed the same thing. Perhaps the user interface is not mature enough
for this. I would suggest opening up the RDL file and checking out the
filter definition section. You might be able to tweak it manually.

--
Cheers,

'(' Jeff A. Stucker
\

Business Intelligence
www.criadvantage.com
--------------------------------------
[quoted text, click to view]

Matt Smith
12/27/2004 3:22:06 PM

Under the Filters tab of the properties of several objects within the
Reporting Services report designer their are 3 columns that correspond to
the child tags of the filter tag. There is also a fourth column labelled
'And/Or'. This column seems to always be greyed out, and automatically
places and 'AND' between compound conditions. I would like to be able to
put in an OR but cannot seem to find any way to do it. The documentation
that I have found does not even mention this column, and there does not seem
to be a tag associated with it. I have tried using logical operators within
the 'Expression' column, however the length of this column is pretty
limited. is there any way to use the 'OR' between multiple filter
conditions?

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server reporting services

home · blog · groups

Questions? Comments? Contact the dn