Working with Reporting Services Filters–Part 5: OR Logic

February 4, 2011
Tags: ,

When you combine multiple filters, Reporting Services uses AND logic. Once upon a time, there was actually a drop-down list for selecting AND or OR between filters which was very confusing to people because often it was grayed out. Now that selection is gone, but no matter. It wouldn’t help us solve the problem that […]


Working with Reporting Services Filters – Part 4: Creating a NOT IN Filter

January 20, 2011
Tags: ,

A question came in from a reader asking about how to create a NOT IN filter. You can see in the first of this series of blog posts about Reporting Services filters, NOT IN is not available in our list of operators for filters. However, it’s still possible to produce a filter that excludes items […]


Working with Reporting Services Filters – Part 3: The TOP and BOTTOM Operators

January 7, 2011
Tags: ,

Thus far in this series, I have described using the IN operator and the LIKE operator. Today, I’ll continue the series by reviewing the TOP and BOTTOM operators. Today, I happened to be working on an example of using the TOP N operator and was not successful on my first try because the behavior is […]


Working with Reporting Services Filters – Part 2: The LIKE Operator

December 30, 2010
Tags: ,

In the first post of this series, I introduced the use of filters within the report rather than in the query. I included a list of filter operators, and then focused on the use of the IN operator. As I mentioned in the previous post, the use of some of these operators is not obvious, […]


Working with Reporting Services Filters–Part 1

December 21, 2010
Tags: ,

There are two ways that you can filter data in Reporting Services. The first way, which usually provides a faster performance, is to use query parameters to apply a filter using the WHERE clause in a SQL statement. In that case, the structure of the filter depends upon the syntax recognized by the source database. […]