Use custom columns to merge and display data from various sources and
to create columns on which you want to perform operations and calculations on
data in ways not possible on the original forms.
Use the
Custom Columnsdialog box to create custom columns
for a DataView:
-
While DataView results are displayed, select
.
-
Verify that the
Collection field shows the
IDO collection from which the data is being retrieved.
-
In the
Name field, specify the
name to assign to the custom column.
Note: This name is the label that will be used for the custom column
header. Take care when specifying this name, because you cannot change it
later. If you decide to change the name/label later, you must delete the
existing column and create it again with the new name.
-
In the
Data Type field, specify
the type of data to use for the custom column display.
-
Click
Add.
-
Use the
Advanced Editor to define the formula or
expression that is to specify what is displayed in the column.
-
After you finish in the
Advanced Editor, click
OK.
The DataView grid immediately shows the new column with the results of
the formula or expression.