Adding columns to a view

You can add any of the physical data fields or computed fields defined in a table layout as columns in a view. You can also add columns to a view based on ad hoc expressions created using the Expression Builder.

To add columns to a view:

  1. Do one of the following:
    • Right-click a column header in the view to insert one or more columns to the left of the selected column

    • Right-click in the display area without a column selected to add one or more columns after the last column

  2. Select Add Columns.
  3. In the Add Columns dialog box, complete any of the following steps:
    • Click Add All to add all of the columns to the view.

    • Click an individual column in the Available Fields list and then click the right-arrow button to add it to the view.

    • Ctrl+click multiple columns in the Available Fields list and then click the right-arrow button to add them to the view.

    • Click Expr to open the Expression Builder and create an expression to add to the view.

    • If you want to use an expression to modify a column after you add it to the Selected Fields list, select the column and click Edit to open the Expression Builder.

  4. If the table has one or more related tables associated with it, you can add fields from any of the related tables to the view by selecting a related table in the From Table drop-down list, and adding the fields you want to include to the Selected Fields list.
  5. Click OK.


(C) 2013 ACL Services Ltd. All Rights Reserved. | Send feedback