Please enable JavaScript to view this site.

R:BASE 11 Help

Navigation: How To (Forms, Reports, and more) > Data Browsing/Editing > Browse/Edit a Table or View > View Modes

Viewing Data as a Tree Grid

Scroll Prev Top Next More

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

 

ViewAsTreeGrid

 

 

Find Panel

When the Tree Grid mode is displayed, a Find Panel may be enabled to provide fast record filtering, to locate values that match the entered criteria and limit the displayed results. The data filtering is not performed on a specific column, but is carried out on all columns. The most recently used searches are retained in the Find Panel drop-down. The Find Panel may also be toggled with the [Ctrl+Shift+F] keys.

 

TreeGrid_FindPanel

 

 

Custom Filter

The Custom Filter is available to customize the tree grid column filter's criteria.

 

CustomFilter_Browser

 

 

To display the Custom Filter, select the "Custom..." menu option with the column's filter.

 

DisplayCustomFilter

 

 

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.

 

TreeGrid_Customized

 

 

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.

 

 

FilterBuilder_Browser