Microsoft® SQL Server® Reporting Services Recipes: for Designing Expert Reports

Part VII. Filtering and Parameterization

• Multiple Criterion Report Filtering

• Using Multi-Value Parameters with a Stored Procedure

• Using Multi-Value Parameters with a Subscription Report

• Parameterized Top Values Report

• Cube Restricting Rows

• Creating Custom Sorting Reports

• Filtering User-Specific Report Data

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. By employing some advanced expression logic or a little bit of custom code, practically any filtering logic can be implemented in the query or using dataset filtering within the report.

Product Versions

• Reporting Services 2000

• Reporting Services 2005

• Reporting Services 2008

What You'll Need

• Any report with multiple parameters for filtering data

• Solid report design skills

• Intermediate SQL or MDX query skills

• Familiarity with Visual Basic.NET expressions and custom programming

Designing the Report

Before you get started, let's briefly lay out the roadmap for this topic. The techniques for filtering data in a report range from basic to advanced, and the approach you use to solve these problems may range ...