Lesson 3: Filtering the Data in a Matrix (Report Builder 1.0)
Filters allow you to exclude data from the report. Apply filters when you want to view data that meets your specific criteria.
To filter the data in a matrix report
On the Report menu, click Filter.
The Filter Data dialog box opens.
Alternatively, you can open the Filter Data dialog box by clicking the Filter button on the Report toolbar.
In the Entities list, select Territory.
In the Fields list, drag Name to the filter area on the right.
Click the down arrow and select Northwest.
In the Entities list, select Sales Order.
From the Fields list, drag Ship Date to the filter area.
Click equals, and the select From…To.
In the From box, type 1/1/2001.
In the To box, type 12/31/2002.
You have successfully applied a simple filter to the data. Next, you will run the report so that you can see your report design with the actual data. See Lesson 4: Running a Matrix Report (Report Builder 1.0).