Show TOC

Displaying Results as a TableLocate this document in the navigation structure

Use

You use the Display as Table function to display interactive basic lists, statistics, and ranked lists in a special tabular form with the help of the Table View Controls. This type of display does not include totals lines, sub-totals line and lines with control level texts.

Note

The function always manipulates the statistic, which is either indicated by the cursor or appears first on the screen.

The advantage of this display over the list is that it gives you access to a range of interactive functions. These include functions that are provided automatically by the table view-control (for example, column switching, storing settings, and so on). They also include functions that enable you to manipulate the displayed dataset by selecting rows and columns.

Features
  • Convert

    This function allows you to convert currency amounts or quantity specifications to a reference currency or reference unit by marking the column containing the amounts to be converted. The currencies or units must also be in the table.

  • Sort

    Two important functions are sort ascending and sort descending. The sort proceeds from left to right and depends on the column(s) you select; i.e. the marked column on the extreme left of the display becomes the highest sort criterion. The sorted columns are highlighted in the display. By switching and selecting columns, you can thus sort the data any way you like.

  • Sum

    The Sum function allows you to calculate totals. It calculates an overall total for each numeric column and sub-totals for all selected and sorted columns. So, to obtain sub-totals for a particular sort criterion, you must first sort by selecting the relevant column (and, if necessary, other columns) and calling one of the sort functions. You then select the column again and call the Sum function.

    All totals lines are highlighted. By using the Display totals only function, you can restrict the display to sub-totals and the overall total. To remove all totals lines, select Switch off totals.

  • Search

    The Find and Continue search functions allow to scan selected columns. It is not possible to search in numeric columns. Neither is a search carried out in the totals columns.

    The Find function first requires you to enter a search criterion and then begins the search in the first visible line or in the first line in the table. If a match is found, the cursor is placed on the found term. The table is then scrolled so that the found term is displayed in the first visible line.

    The Continue search function always searches for a previously entered search criterion. If the cursor is somewhere in the table, the search always starts from the cursor position. Otherwise, it starts from the first visible line of the table. By using the Find function and then repeatedly pressing Continue search, you can scan a table for each occurrence of a particular term.

    If the term is not found or no more occurrences are found, you get an appropriate message.

  • Show/Hide Rows and Columns

    The Hide lines/columns function allows you to hide lines and columns. You can thus restrict a display to relevant sections and make it easier to read. The sort, sum, search and print functions always refer to the visible dataset; i.e. hidden lines and columns are ignored.

    Note

    You can store settings with hidden lines as a variant of the table view control.

    The Show lines/columns function allows you to redisplay hidden lines and columns.

  • Fix Columns

    Two additional functions allow you to fix and unfix the positions of certain columns. Although not all columns of wide lists are visible in the table view control, you can use the horizontal scroll bar to display those columns, which cannot be seen. Initially, all fields are moved when you scroll horizontally. If you then select the Fix column function, the selected column and all those columns to the left of it are fixed; i.e. horizontal scrolling has no effect on them. Before you use this function, all columns to be fixed must be in their original positions. To release columns from their fixed positions, select Cancel fixing.

  • Print

    The Print function prints the table as it appears on the screen. This means that when you print out a screen list, only the visible lines and columns, as well as the sorting, totals lines, column switches and changes in column width are taken into account.

  • Display the List in its Original Form

    The Initial Display function returns the table to its initial form, meaning it is displayed with the exact layout that it had when it was first called. Any subsequent steps (such as sorting, summing, hiding of lines and columns, etc.) are reversed or discarded.