Features

Standard Features (all editions)

Features with the camera symbol:are illustrated with screen shots.

Just click the icon for a quick preview of the feature.

Totaling (conditionally filtered) by data source:

Multiple totals per data source (no limit on number of totals)

Totals related rows, such as all items in one order

Extremely flexible totaling types

Count of related rows

Sum of data table column of related rows

Minimum column value

Maximum column value

Average column value

Custom calculation - totally general, i.e.: sum of product of columns A and B when column C is greater than D, etc.

Primary File Ranging

	Page size (1 to 9999 rows) Now (version 8.5) with incremental locator
	File Relationship
	Minimum, maximum range of values
	Single Value
	Current Value

(Illustrated with Page Ranging Feature)

Multirooted trees from multiple unrelated data sources

Collapsible Tree Headers

Headers available at all tree levels, every data source

(Illustrated with Style Feature, but Style not required)

Multiple related data sources per tree level (each with optional header)

(Illustrated with Style Feature, but Style not required)

Views supported at all tree levels

	All ViewManager methods are available to use
	Embed into ViewManager methods
	Filter views separately by tree level
	Multiple prioritized, overridable filters by tree level
	Separate SQL Filters
	Custom JOINs
	Inner JOINs

Filters are supported at all levels of the tree

	Regular Filters
	SQL Filters (replace or extend)
	Named Filters (SetFilter method)

Dynamic Data Ordering (DDO)

	Source rows are added to the tree in arbitrary sorted order
	No need for ordering fields in relational linking keys
	Sorted data loads in same time as unsorted data
	Unlimited conditional keys per data source
	Up to 16 prioritized sort fields per sort key
	Sort key fields can be runtime computed values
	Column header mouse click sorting with alternated forward/reverse (primary data source only)

Column header mouse click sorting

	Sorts primary data source
	Alternates order on each mouse click
	Extension of DDO feature

Virtual Trees

	Data field break headers inserted into list
	Data rows indented beneath field value header
	Up to 16 levels of nested break headers
	Extension of DDO feature

Section Footers

	Rows inserted at the end of data block
	Optional extension to each data section
	Unlimited number of footers per data section
	Each footer formatted separately
	Use for totals or any other computed values

(Illustrated together with Totaling Feature)

18 default alerted keyboard functions with customizable keystrokes; can add custom functions and alerted keys

Automatic tree refresh on (multiple) parent listbox new selection events

Automatic tree refresh on accepted events of (multiple) linked arbitrary controls

Allows, for example, refresh on changes to various components of a multicomponent file relationship key, by using entry fields

Multicolumn Data Presentation

	Mixed formatting in any tree section (data source, header footer)
	Indented (tree) listbox column can be in any column position
	Intermix strings and numbers in the same column (format by column by data source)
	icon-only columns
	icons in data columns
	Cascading defaults simplify setup

(Illustrated with Totaling Feature)

Icons, colors, tooltips, data, all applied at cell level (normal and conditional)

Cell Tooltips (normal and conditional)

Automatic (optional) generation of folder icons in tree column (Expanded, Contracted, Leaf)