<< Click to Display Table of Contents >>

Navigation:  Program use > Administration and reports >

General information

All source data are presented as a table in the program. You can find out how to work with these tables below.

 

table

Fig. 2 Table with data

 

Each table has navigation buttons at the bottom (fig. 3).

 

table-buttons

Fig. 3 Navigation bar

 

Navigation buttons

 

Buttons (left to right):

 

1.First - move to the first record in the table.

2.Page Up - move to the record one page up.

3.Previous - move to the previous record.

4.Next - move to the next record.

5.Page Down - move to the record one page down.

6.Last - move to the last record in the table.

7.Insert - insert a new record into the table next to the current one.

8.Add - add a new record to the end of the table. After you save the record, it will be sorted according to the sorting rules.

9.Delete - delete the selected records. You can also delete records by pressing the “Delete” key on the keyboard.

10.Edit - edit the current record. You can edit a record by clicking the current cell in the table.

11.Save - save the changes in the current row.

12.Cancel - cancel changes in the current row in the table.

13.Refresh - refresh the current row.

14.Filter - open the dialog box where you can configure filtering the data (fig. 4)

 

Some navigation buttons can be unavailable. It depends on the data shown in the table.

 

New filter

 

filter-builder

Fig. 4 Filter

 

This dialog box allows you to configure the filter you can use to filter data in the table by the condition you specify. You can select the condition each column will be checked by. You can specify complex rules by adding several conditions.

 

You can save the filter to a file and load it later using the corresponding button.

 

Click "OK" after you finish editing the filter.

 

Quick filter

 

You can access the quick filter if you move the mouse pointer to the column header's right edge (fig. 5). If you click the button, you can open a drop-down list to select the value for the filter. This filter is limited in the "Events" table not to slow down the program.

 

quick-filter

Fig. 5 Quick filter

 

Column customization

 

The program allows flexible customizing columns. You can:

 

Change the order of columns. Just click the column header and move the column to the necessary position holding down the mouse button.

 

Quickly sort data in the table. Click the column header. If you need to sort data by two or more columns, hold down the “Shift” key when you click the column header.

 

Hide columns in the table. Open the "Columns editor" dialog box (fig. 7) using either the toolbar (fig. 6) or the popup menu.

 

toolbar1

Fig. 6 Toolbar

 

columns-view-mode

Fig. 7 "Column editor" dialog box

 

You can customize the order and the set of columns in the table in this dialog box. The program allows you to create several Column views, which will allow you to filter data by the necessary condition and quickly switch between column views.
 
Select the checkbox of the column name for the column to be shown in the table. You can change a column's position by dragging it to the necessary position (hold down the mouse button on the column number). After you change the settings, you should save them with a click on the toolbar.
 
You can create new data types and delete existing ones with clicks on the "+" and "-" buttons.
 
When you exit the program, the current view will be saved and restored when you start the program next time.

 

After you exit this dialog box, all new column views will be displayed in the toolbar's drop-down list.

 

You can use the following items on the popup menu of the table to customize the column size.

 

Adjust columns. The program will calculate the column width depending on the value in it. The column width will correspond to the width of the cell with the longest value.

 

Proportional column width. The column width will be automatically calculated depending on the table width.