Column (Field) Display Options

Note: For grids not provided with the grid management facility (see Grid Manager), if columns are resized or re-ordered, these changes are saved between sessions.

To resize a column

• click and hold on the line between columns and drag the line left or right to make it wider or narrower. Or,

• Double-click on the line to resize the column to fit the longest string of characters within that column.

To change column order

You can adjust the order that columns are displayed in from left to right.

1. Click and hold a column header and drag it to a new position.

   Two arrows are displayed to assist you in positioning the column.

   

To sort a grid

You can sort the Data Grid on any combination of fields.

2. Click on a column (field) name.

3. To sort by multiple fields, hold the <Shift> key while making selections.

   The grid will be sorted in the order that the columns are selected.

To pin columns

You can pin a column to ensure it automatically becomes the first (left-most) column of the grid, and remains displayed at the left side of the grid even when the grid is scrolled to the right, so that it is always in view.

Pin icons are displayed in headings of a grid if the facility for pinning columns is turned on for it. If not, to activate the facility for pinning columns for the current grid, check the Pinned Column checkbox in the Grid Options section of the View Tab in AVEVA Instrumentation.

4. Click the pin icon for the desired column.

   

   When a column is pinned, its pin icon changes orientation, so that its point is downwards.

5. To unpin a column, click its pin icon again.

Column Summaries

The average, count (for example, number of values), minimum, maximum and total values of a column containing numbers only can be calculated and displayed beneath the column.

Sum icons are displayed in the headings of a grid if the summarize columns facility is turned on for it.

To turn on column summaries

6. Select the Column summaries checkbox in the Grid Options section of the View Tab in AVEVA Instrumentation.

7. To specify which summaries are to be displayed, click on the icon.

   The Select Summaries window is then displayed:

   

8. Select the checkboxes for the summaries which are to be displayed, then click OK.

   The selected summaries are then displayed beneath the column. For example: