Add a filter to the reports and extracts you build

When you use the Report Wizard or Extract Wizard, you can set up a filter to limit the number of records displayed in the report or extract. You can:

Understand how to set up a filter


1 Click the Add button to add a filter. You can add more than one filter.

2 Click Select and choose the field that you want to filter.

You can choose a field that will display in your report or you can choose a different field. For example, for a report that includes source name and thumbnail you could add a filter for source type equals picture.

3 Select a filter type from the list—for example, Equal to, Contains, or Is empty. The available options depend on the field type—for example, if you are filtering on a date, you can select Last month.


4 Enter the criteria or click Select to choose a specific item. If you are creating a filter on a user-entered value, select [prompt for parameter].

For some combinations of fields and filters, the Select button is not available—for example, if you choose Contains then you need to enter a text string.

ic_top_of_page.gifTop of Page