The Expression Builder allows you to create, edit, and test
expressions. There are three components to the Expression
Builder:
Edit Expression Tab
Expression Builder Edit Expression Tab
Properties
|
Property
|
Description
|
Values
|
|
Expression entry field
|
A text box where your expression will be
displayed as you build it.
|
N/A
|
|
Data Source button
|
Adds the data source specified in the Data
Source drop-down list.
|
N/A
|
|
Data Source list
|
Contains a list of data sources configured
on the Data Sources tab. `No Data Source' will appear if you have
not made any entries on the Data Sources tab.
|
Configured data sources
|
|
Function
|
Adds the function specified in the Function
drop-down list.
|
N/A
|
|
Function list
|
Contains a list of functions to use when
building an expression.
|
SIN
COS
TAN
ASIN
ACOS
ATAN
LOG
LOG10
INT
ABS
SQRT
EXP
|
|
Numerical Entry pad
|
Adds numbers and decimals to the
expression.
|
Numbers 1 through 10
Decimal
|
|
Conditional Operators
|
Adds conditional operators to the
expression.
|
+
-
*
/
=
<>
<
>
<=
>=
(
)
|
|
Clear button
|
Clears the expression.
|
N/A
|
Data Sources Tab
Expression Builder Data Sources Tab
Properties
|
Property
|
Description
|
Value
|
|
Id
|
The ID for the data source. This ID will
appear in the Data Source drop-down list on the Edit Expression
tab.
|
Any unique string value.
|
|
Data Source
|
Displays the selected data source.
|
N/A
|
|
Data Source button
|
Opens the Data Source Browser. See Data Source Browser
Properties.
|
N/A
|
|
Advanced Settings button
|
Opens the Advanced Settings dialog box. See
Advanced Settings
Properties.
|
N/A
|
|
More button
|
Adds 5 more rows to the Data Sources
table.
|
N/A
|
Test Results Tab
The results of your expression will appear in the Test Results
tab after you click the Test button.
Expression Builder Test Results Tab
Properties
|
Property
|
Description
|
Value
|
|
Value of
Expression
|
Displays the result of the expression. If
the expression generates an error, the error appears at the bottom
of the Edit Expression tab (it will not appear on the Test Results
tab).
|
N/A
|
All of the tabs in the Expression Builder share the following
buttons:
Save – saves the expression and
closes the dialog box. The expression is saved for use with the
current object; you cannot use the same expression in multiple
objects.
Test – tests the expression. The
results will appear on the Test Results tab.
See Also
