Creating Custom Columns for DataViews

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 Display > Custom Columns.
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.