How to filter the results from WSS in your report
I received a question from a reader asking how you can set a filter on the items returned from a list. Suppose you want to show only the Defects with status Active or Issues with Impact > 3? We cannot set the where clause, as we don't have a SQL statement. The data extension presented in the article always returns all rows.
Luckily, the Report Designer offers features to sort and filter the data returned before inserting it into the report. This is how to do it:
1. In Report Designer (in VS.NET) open your report on the Data tab. Select the ... button next to the list of datasets:
2. This will open the DataSet dialog. On the Filter tab, you can build expressions to filter the data. You can enter fixed values, but the expression builder will also help you to use global settings and passed parameters from the user in your filter.
This dialog allows you to do many more things to your data, like adding calculated columns. Check here.