### 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.

   If the table is in a web report or library component, you can use a parameter to specify the value dynamically and when the available parameters cannot meet your requirement, you can also create a local parameter to use in the filter. For more information about using parameters to dynamically filter data, see Dynamically filtering queries.

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 the Edit Filter dialog for page report or web report/library component for details about options in the dialog.

Note: The following SQL type of data cannot be filtered: Db.SQL_BINARY, Db.SQL_BLOB, Db.SQL_CLOB, Db.SQL_LONGVARCHAR, Db.SQL_LONGVARBINARY, Db.SQL_VARBINARY and Db.SQL_OTHER.