On a stock Window Vista, Windows 7 or Windows 8 computer, attempts to access the built-in help system in SOS modules will result in an error message, stating that your current version of Windows does not support the program’s help system. The needed help system software is available on the Microsoft Downloads site, from which you can download and install the missing component.
The following page on the web contains links to the correct WinHlp32 installer for all of the current versions of Windows, including Vista, Windows 7, and Windows 8:
To sort records by a column’s values and replace existing sort conditions that are applied to the current or other column(s), click the target column’s header, until an UP or Down Arrow icon is displayed within the header. The Up and Down Arrows indicate ascending and descending sort orders, respectively.
To sort rows by a column’s values preserving existing sort conditions, do one of the following:
Click a column’s header holding the SHIFT key down, until an UP or Down Arrow icon is displayed within the header.
Right-click a column’s header and select Sort Ascending or Sort Descending from the context menu.
To remove sorting by a column, click a column header while holding the CTRL key down.
To group by a column, do one of the following:
Drag a column header from the column header panel to the Group Panel.
Right-click a column header and select Group By This Column from the context menu:
To ungroup data by a grouping column, do one of the following:
Drag a column header from the group panel to the column header panel.
Right-click a grouping column’s header and select UnGroup from the context menu.
To remove grouping by all columns, right click the group panel and select Clear Grouping from the context menu:
Change Group Order
To change the group order, move a grouping column header to another position within the group panel:
Select the required filter value in the filter dropdown list:
The filter dropdown list will be closed immediately, and the control will display the records which contain the specified value in the specified column/card field.
If the filter dropdown list provides check boxes to the left of the filter values, multiple values can be selected (checked) simultaneously. In this mode, click Ok to close the filter dropdown list and apply the filter.
You can sequentially filter data against multiple columns.
Clear the Filter
To clear the filter applied to a column, do one of the following:
Invoke the filter dropdown list and click (All).
Right-click a column’s header and select Clear Filter.
To clear the grid’s filter, click the Close Filter button within the Filter Panel:
Disable/Enable the Filter
Toggle the checked state of the Enable Filter box displayed within the Filter Panel:
Using the Automatic Filter Row
The automatic filter row (if shown) allows end-users to filter data on the fly. To filter data, type text directly into the row. When you input text within the row, a filter condition is automatically created based upon the values entered, and applied to the column.
Showing and Hiding Columns
To hide a column, drag its header and drop it onto the Column Chooser if it’s open:
Open the Column Chooser, drag the required column’s header from the Column Chooser and drop it onto the column header panel.
Navigating Through Rows and Cells
To move focus between cells and rows, use the ARROW, TAB, HOME, END, PAGE UP and PAGE DOWN keys. Note that the ARROW, HOME and END keys are used for navigation between rows/cards only when the focused cell is not being edited. Otherwise, these keys affect focus movement within the currently edited cell.
To focus the next cell, do one of the following:
In Table Views, press RIGHT ARROW. In Card Views, press DOWN ARROW. If a cell editor is active, pressing RIGHT ARROW moves focus to the next cell if the caret is positioned at the end of the current cell’s text or if the cell’s text is selected in its entirety.
To focus the previous cell, do one of the following:
In Table Views, press LEFT ARROW. In Card Views, press UP ARROW. If a cell editor is active, pressing LEFT ARROW moves focus to the previous cell if the caret is positioned at the beginning of the current cell’s text or if the cell’s text is selected in its entirety.
To focus the first cell within the focused row, press HOME (in Table Views).
To focus the last cell within the focused row, press END (in Table Views).
To focus the first row/card:
Press CTRL+HOME in Table Views.
Press HOME or CTRL+Home in Card Views.
To focus the last row/card:
Press CTRL+END in Table Views.
Press END or CTRL+END in Card Views.
To move focus to the Automatic Filter Row displayed at the top of a Table View, do one of the following:
Click this row.
If the top data row is focused, press CTRL+UP ARROW.
Select Individual Rows
To select a row and clear the existing selection, click its data cell or select the row using the ARROW keys.
To select a row and preserve the current selection, click its data cell holding the CTRL key down.
To toggle the focused row’s selected state, do one of the following:
Click the row while holding the CTRL key down.
Select a Range Rows
To select all rows, press CTRL+A. Before pressing this shortcut, ensure that the focused cell is not being edited.
To select a continuous range of rows, you can do the following:
Use ARROW, PAGE UP, PAGE DOWN keys while holding the SHIFT key down.
To selects all rows between the currently focused row and another one, click the target row while holding the SHIFT key down.
To change a column’s width, drag the right edge of its header: