Report Builder - Professional SQL Server 2005 Reporting Services - page 390

Figure 9-23
The majority of the filtering functionality will be handled in the filter list on the right side of the Filter
Data dialog. The first item that should be pointed out is the title over the filter list. In this scenario, it dis-
plays the text “Dim Products with.” If you click on the text, you will be presented with a drop-down list
like that shown in Figure 9-24.
The drop-down in Figure 9-24 presents four options: All of, Any of, None of, and Not all of. “All of” rep-
resents a logical AND condition. All of the expressions in the filter list must be true to return a result set.
“Any of” represents a logical OR condition. If any one of the conditions in the filter list is true, the data
row is returned. “None of” represents a logical Exclusive AND condition. If all of the conditions are false,
the data row is returned. The final item, “Not all of,” represents a logical Exclusive OR condition. If any
one of the conditions is true, but not all of them, then the data is returned. Let's put these into some real
terms.
For this scenario, you will use the “All of” option. You will create conditions to test if Sales Amount is
not empty and Order Quantity is not empty. If both of those statements are true, you want to return the
data row. You will add this filter after examining the other filter types.
An “Any of” report might be something like “Show me all of the sales for people in the United States
and Canada.” You could add filters to specify Country equal to Canada or Country equal to United
States. “Any of” these two values would be acceptable.
“None of” could be used in a reverse scenario from the previous example. You might want to see sales
for people not in the United States or Canada. In that example, you would set filters for Country equals
Canada or Country equals United States. If either of those conditions is true, you would want to remove
them from the report.