Filters reduce the results displayed in a report based on the values selected for the filter by the user. There are three methods for filtering values that include manual entry, list selection and prompt selection.
1. Manual Entry
This allows the user to manually type the required value(s).Filters that require users to define values through manual entry can include single values, ranges, and lists.
2. List Selection
The user can select from a list of values that are provided.
3. Prompt Selection
This allows the user to prompt the database for values and select from a list returned.
a. Click on the prompt filter icon to the right of the filter
b. Select the required values from the displayed list
c. You will now see your list populated with your selected values