Column (Field) Display Options

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

Resize

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. Double clicking on the line will resize the column to fit the largest string of text within that column.

Change Column Order

To change the order that columns are displayed in from left to right, click and hold a column header and drag it to a new position. Two arrows are displayed to assist the user in positioning the column.

Sort a Grid

The user can sort the grid on any combination of fields by clicking on column (field) name. To sort by multiple fields hold the <Shift> key while making selections. The grid will be sorted in the order that each column is selected.

Pin Columns

When a column is pinned, it automatically becomes the first (left-hand most) column of the grid, and remains displayed at the left-hand 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.

To pin a column, click on its pin icon.

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

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 then displayed in headings of a grid if the summarise columns facility is turned on for it. If not, to activate the facility for the current grid, check the Column summaries checkbox in the Grid Options section of the View Tab.

To specify which summaries are to be displayed, click on the icon. The Select Summaries window is then displayed:

Check the checkboxes for the summaries which are to displayed, then click OK.

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