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

Figure 9-22
Filtering and Sorting Reports
Another key set of features for any reporting tool is the ability to filter and sort the data. In this section,
you look at removing empty rows from your report, giving users the option to filter the report based on
a given time period and sorting the report alphabetically based on Product Name.
Filtering
First thing to do is simply remove all of the empty data rows. In the Report Builder toolbar, you will see
a button labeled “Filter.” Clicking on this button will bring up the Filter Data dialog. Figure 9-23 shows
this window.
There are three main windows within the Filter data window: Entities, Fields, and the filter list. The
Entities and Fields windows should be familiar from previous sections in this chapter. They contain the
data Elements and related Attributes in our Report Model. You should notice that your Entities window
is already limited to items related to Dim Product, since this is the information contained within your
report.