To view the table data as a tree grid, click the "View as Tree Grid" tab to switch modes. In the View as Tree Grid mode, powerful manipulation and data viewing support is enabled:
•Dynamic grouping (tree support) by dragging columns to the top panel
•Column data filtering (basic and advanced) to quickly limit the displayed results
•Column rearranging and sorting
Custom Filter
The Custom Filter is available to customize the tree grid column filter's criteria.
To display the Custom Filter, select the "Custom..." menu option with the column's filter.
Once the Custom Filter is added, a panel will appear across the bottom of the grid window displaying the current list of defined filters. To apply complex filters, use the "Customize..." button to open the Filter Builder.
Filter Builder
The Filter Builder is available to create complex filters for the tree grid. The dialog allows end-users to:
•Build complex filter criteria with an unlimited number of filter conditions combined by logical operators.
•Save filter criteria to files, and restore previously saved criteria at a later point.