Applying filters to a report

On the Filters tab, you specify the fields, operators, and values that determine the results that are shown in a report. The selected filters run sequentially. Reports run faster if the filter that filters out the most records is specified first, followed by the one that filters out the next highest number of records

1. Select a business object.
2. In the Columns section, for each field that is used as a filter, select the check box in the User or System column.
3. In the User Filter Columns section and System Filter Columns section, select a field and change the sequence in which the filters are applied.
4. To change the label that is shown for a filter, edit the text in the Report Label text box. If the field is a time field, input the time in milliseconds or as a string in hh:mm:ss format.
5. From the Filter Operator drop-down box, select the comparison filter operator.
6. From the Conditional drop-down box, select the conditional option. If you select Yes, the system filter is ignored in the query results when the filter input is empty.
7. For system filters with a value for run time, specify the value that must be matched. To filter a Boolean field, use the values TRUE or FALSE.
8. Select the Join Operator to organize system filters in sets to further refine the order that the filters are applied.
9. Select Save.