Re: Filtering Data

Tech-Archive recommends: Fix windows errors by optimizing your registry

This sounds more like something to be implemented in the front-end - for
example, cascading parameters in SSRS:

http://msdn2.microsoft.com/en-us/library/aa337169.aspx

SQL Server 2005 Books Online

How to: Add Cascading Parameters to a Report
New: 17 July 2006

Cascading parameters provide a way of managing large amounts of report
data. You can define a set of parameters where the list of values for
one parameter depends on the value chosen in another parameter. For
example, the first parameter could present a list of product categories.
When the user selects a category, the second parameter is updated with a
list of subcategories within the category. A third parameter could then
display a list of products within the selected subcategory. The value
for the product parameter could then be used to filter the report to a
particular product. This process of filtering a list of parameter values
based on a value from another parameter is known variously as cascading,
dependent, or hierarchical parameters.
...



- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***
.