The arrangement and size of all windows or panels can be adjusted by the user according to his own ideas. To do this, a panel is held at the title bar and moved. Then drag the mouse pointer with the mouse button held down to the corresponding docking symbol in the target area. The panels can be arranged on top of each other, side by side or overlapping.
The panel arrangement is saved when the program is closed. When the program is restarted, the panels are automatically arranged as last configured.
The arrangement of the panels can be reset to a standard layout using the "Reset Layout" button in the main toolbar:
In most tables, only some of the available columns are displayed. Additional columns can be shown or hidden user-specifically.
By right-clicking on the table header line and selecting the Show Column Chooser entry, a dialog opens in which the columns to be displayed can be selected.
This allows the active columns to be set by checkboxes and their order by drag & drop. This mechanism is basically valid for all tables available in the program
By left-clicking on the header of a column, the table is sorted in ascending or descending order by the selected column. A triangle symbol indicates the sorting direction.
For large tables or data sets, individual rows can be filtered user-specifically. This function is especially useful for preselecting and defining groups
The tables can be filtered in three different ways:
by values (single column)
by rules (single column)
filter editor (several columns)
Filter by values (single column)
If you move the mouse over a column header, the filter symbol appears. Left-clicking on it opens a menu with an active tab Filter Values, which lists all possible values of this column. The user can now select the desired values by clicking into the checkbox. The search function in the upper part of the window can be used to narrow down the selection. The functionality is similar to that in Microsoft Excel.
Filter by rules (single column)
If you move the mouse over a column header, the filter symbol appears. Clicking on it opens a menu in which you have to switch to the left tab Filter Rules. In this tab you can set a rule for filtering the column.
Filter Editor (multiple columns)
The Filter Editor can be used to create extensive filter expressions. It is opened by right-clicking on the table header line and selecting the Filter Editor.
With the help of the filter editor several filter operations can be created and linked by boolean operations.
Note: If a filter is active, the filter expression is displayed in the footer of the table. By clicking on the pencil symbol, it can be edited. The filter is removed by clicking on the X.
Similar to the conditional formatting in Excel, cells of a table can be specially displayed according to certain rules. For example, cells can be colored or bars or symbols can be displayed. The dialog for configuring conditional formatting can be accessed by right-clicking on the header of a column and selecting the Conditional Formatting option.
Note: The adjustments described in this chapter which are made to display the tables are saved when the program is closed. When the Report Analyzer is restarted, these settings are applied automatically. Under certain circumstances it can happen that records are not displayed because of the filter settings, because a filter is active.
