Filtering the data

You can apply some filters to a table so as to reduce the records displayed in the table.

To add filter conditions to a table:

1. Right-click the table and select Format Filter to display the Edit Filter dialog. See the dialog.



2. If you are working with a web report or a library component, the Filter drop-down is available, listing all the predefined filters of the business view on which the table is created. You can select one from the drop-down list to apply, or select User Defined in the list to define a new filter as required.
3. Click the Add Condition button to add a condition line.
4. In the field text field, specify the field on which the filter will be based.
5. From the operator drop-down list, set the operator with which to compose the filter expression.
6. In the value text field, specify the value of how to filter the field.
7. To add another line of filter expression, click the Add Condition button and define the expression as required. Then from the logic drop-down list, specify the relationship between the two filter expressions.
8. Repeat the above steps to add more filter expressions if necessary.

   To make some conditions grouped, select them and click the Group button, then the selected conditions will be added in one group and work as one line of filter expression. Conditions and groups together can be further grouped. To take any condition or group in a group out, select it and click Ungroup.

   To adjust the priority of the conditions, select it and click the Up or Down button.

   To delete a condition line, select it and click the Delete button.

9. When done, click OK to create the filter.

   Then when you preview the table, only data satisfying the specified filter conditions are shown.

See also Edit Filter dialog for page report and Edit Filter dialog for web report/library component for details about options in the dialogs.