Contents

Filtering Data on a Grid

To hide data of a column, do the following:

1. Right-click the required column, and then click Visible Columns on the shortcut menu.

2. In the Visible Columns dialog box that opens, clear the check box next to the column you want to hide on the grid.

   To arrange columns in an alphabetical order, select Sort alphabetically.

3. To apply the changes, click OK.

To filter data by column, do the following:

1. On a column header, click the Filter icon.

2. From the drop-dwon list, select the filter value. The box includes a set of values encountered in the column and the universal items such as All and Custom.

   -or-

Right-click a column and then click the required filtering condition on the Quick Filter shortcut menu.

When the data is filtered, the Filter icon displayed on the column header will be changed to in order to indicate that the filter condition was applied.

The filter condition toolbar appears at the bottom of the grid providing you a one-click quick access to the filter condition parameters.

To manage filter conditions, on the toolbar, do the following:

• To remove all filter conditions, click . To remove the filter condition of a column, right-click this column and click Clear Filter on the shortcut menu.
• To switch from the filtered data to the full data display, clear the check box.

To apply a custom filter condition to the column, do the following:

1. Right-click the required column, select Quick Filter, and then click Filter Condition on the shortcut menu.

2. In the Filter Editor that opens, choose a relation type and type values to build a filter.

   

   Filter conditions are displayed as a tree with condition and group nodes. A group consists of several conditions or subgroups, combined with a logical operator.

   • To change a group logical operator, click the operator on the Filter Editor window, and select a different logical operator on the shortcut menu.
   • To navigate between conditions and groups, use the UP ARROW and DOWN ARROW keys. To navigate between a condition column, a criteria operator, and an operand value, use the LEFT ARROW and RIGHT ARROW keys.
   • To remove a condition, click or navigate to the condition and press the DELETE or MINUS SIGN key. You can copy, cut, and paste conditions and groups with CTRL+C, CTRL+X, and CTRL+V keys.
   • To remove a group, click its logical operator and select Remove Group on the shortcut menu. You can copy, cut, and paste conditions and groups with the CTRL+C, CTRL+X, and CTRL+V keys.
3. To apply the changes, click Apply and then click OK.

Creating a New Filter Condition

1. Create a new group:
   • Click the upper-level group operator and select Add Group on the shortcut menu.
   • Press CTRL+PLUS SIGN.
2. Create a new filter condition by using one of the following options:
   • Click the upper-level group operator and select Add Condition on the shortcut menu.
   • Navigate to a group you want to enhance and press the INSERT or PLUS SIGN keys.
   • Click of the group you want to enhance.
3. Click the condition column, and then select the column you need on the shortcut menu.
4. Click the condition criteria operator and select the criteria operator you want to apply.
5. If the condition operator requires operand values, specify them.

Want to Find out More?

• Previous
• Next