Report Solution Patterns and Recipes - Professional SQL Server 2005 Reporting Services - page 277

Figure 7-7 shows the end result. The utility cell causes a small gap between the row header and the
remaining columns; alternate row colors are applied to the aggregate data cells.

Figure 7-7

Multiple Criterion Report Filtering
Report design requirements may call for complex combinations of parameter values used to filter report
data. Using Transact-SQL, you should be able to handle practically any advanced filtering criteria and
filter the data before it reaches the report server. However, if you need to use report filtering to provide
the same kinds of filtering support against data already cached by the data set query, the report designer
has some significant limitations in this area. For example, let's say that my report has two parameters for
filtering product records: ProductCategory and PriceRange . In this simplified example, the parame-
ter values for both of my parameter lists are the same as the parameter label values.

The ProductCategory parameter list values are shown in the following table.

Parameter Value Product Category Field Match

Bikes Bikes

Components Components

Clothing Clothing

Accessories Accessories

All Bike Related Bikes and Components

All All Categories

The PriceRange parameter list values are shown in the next table.

Parameter Value Price Range Field Match

Less than 50 < 50

50 to 99 >= 50 AND < 100

Table continued on following page