Please enable JavaScript to view this site.

R:BASE 11 Help

Navigation: How To (Forms, Reports, and more) > Forms > Form Designer > Form Controls > Database Controls

DB Tree Grid

Scroll Prev Top Next More

 

DBTreeGrid

The DB Tree Grid control displays an expandable tree structure within a grid.


 

The DB Tree Grid is an advanced grid, tree list, and data editor control which provides a visually stunning interface with powerful and flexible features for R:BASE applications. Customizations can include designs with standard two-dimensional tables to runtime grouping and column reorganizing. Appearance options include elegant theme and style controls to alter the display of the visual elements, which make up the grid (headers, group panel, odd/even/detail rows, footers, etc.).

 

Features include:

 

Master/Detail grid with integrated data grouping in tabular form

Incremental search for each column, allowing users to instantly locate any information

Fast data loading, with speedy responses upon groups and sorts

Automatic data grouping, enabling an extremely powerful data viewing and manipulation metaphor inside applications

Instant summaries for grouped nodes, eliminating the need to write complex banded reports

Instant footer summaries, generating grid displays that provide compelling data-analysis results

Drag-and-drop column selection, allowing end-users to easily customize the columns visible on the screen

Multiple view types for grid columns:

oBLOB Edit - displays BLOB data, such as an images and text

oCalc Edit - displays a calculator

oCheck Box - displays a check box

oCurrency Edit - edits currency value

oDate Edit - displays a calendar

oHyperlink - display text as a hyperlink

oImage - displays an image

oLabel - displays a custom label with painting options and effects

oFormat Mask - restricts the characters entered

oMemo - edits memo text

oRich Edit - displays rich text format data

oSpin Edit - displays a spin edit object

oText Edit - edit text value

oTime Edit - edits time values

oTrack Bar - displays a track bar editor that edits values using a slider

Column data filtering to quickly limit the displayed results

Customizable style for all visual elements which make up the tree grid (headers, group panel, odd/even/detail rows, footers, etc.)

Banded columns to maximize the number of columns visible, when screen real estate is at a premium

Custom row height for displaying larger row data

Fixed bands and columns to lock columns and bands to the left or right side of the grid

 

The following is an example of a DB Tree Grid control.

 

DBTreeGrid_Sample

 

 

Levels

Grid data is presented via levels. If data is not grouped by any grouping item, it is displayed at level 0. If you group data, nesting levels are created. To display data at a specific level, you must click the [+] tree node button. Thus a level can be defined as a number of [+] buttons you need to click to reach the desired record.

 

If you group data by two grouping items, three levels are created.

 

Levels

 

 

Filtering Data

At runtime, data filtering options are available to quickly limit the displayed results.

 

From the Group By Header, a Custom option is available to apply a Custom Filter. In the below image, the DB Tree Grid is grouped by "State" with the State column listed in the Group By Header.

 

DBTreeGrid_CustomOption

 

 

From Navigator panel a Filter Builder is available to customize a filter's criteria. The Filter Builder 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.

 

DBTreeGrid_FilterBuilder