Databases Reference
In-Depth Information
The Expressions tab
The
Expressions
tab lets us add calculations and mini charts into listboxes, for
example, adding the number of departures to the
Carrier Name
listbox by using the
expression
Sum([# Departures Performed])
. The following screenshot shows the
Carrier Name
listbox with an expression in place:
The Sort tab
The
Sort
tab is commonly found across many objects. It offers the option to order the
data using any of the following sort orders, outlined in descending order of priority:
•
State
: This option sorts values based on the selection state of the items.
Ascending
will put all selected or associated items at the top, followed
by all non-selected items.
Descending
performs the opposite sorting.
Auto Ascending
puts all selected items at the top, but only if the listbox is
not big enough to show all of the values at the same time. If all of the values
are visible, no sorting has been performed.
•
Expression
: This option sorts the values based on the result of an expression.
For example, we could sort carrier names based on the number of departures
they have performed.