To open the Report editor, go to Report -> Report editor in the menu bar.

With the "Report editor" you can generate specific queries for various input areas of the software. It is possible to select almost any field in the database, which can then be displayed in a list. This data can then be integrated in individual or serial letters, work lists and other reports, which can be generated individually with the report editor.

All lists that are generated in the report editor can of course be exported and used in other programs such as Excel.

Every query or analysis can be saved and easily accessed in the system with a simple mouse click.

Overview

Report editor main window is essentially divided in three parts:

1. Group list
2. Area for queries
3. Area for query fields.

Group list

From this area can be selected the sub-groups containing the fields necessary to build a query.

If you double-click on a group  you will see all available sub-groups . Double-click on a sub-group and you will see all fields that are available in this sub-group.

On the left, all the tables and fields are placed which you can use for your query: Patients Cycles Examinations / Medical histories Cryo Administration Personell Referrers Pull subgroups from the left in the middle pane to build a query.

The symbols before the field name are defined by the corresponding type of data.

Different symbols are:

	Number fields.		Date fields.
	Text fields.		Telephone fields.
	Note fields (text fields of different sizes).		QM staff fields.
	Yes / No fields.		QM material fields.
	Key fields.		QM free fields.

Area for queries

In this area the sub-groups can be drag&dropped from group list or be deleted in order to build the query tree. The sub-groups are hierarchically ordered as a “Logical cascade”.

	Execute: Executing a query. As soon as you have selected all needed fields you can launch the query by clicking this button. The Report editor: result window will be open.
	New: Clears the contents of the selection window. A new selection can be made.
	Loading a query: A saved query can be simply by clicking on the "Open"-button. A new window, "Saved queries", will pop up.
	Saving a query: A query can be saved for future use by clicking on "Save"-button. If the query was created from an existing query it can be saved choosing “Save as”. In this way the user can assign to the new query a name different from the parent query.
	Result data records: A selection of shown Results can be chosen here.

Area for query fields

In this area are grouped all the fields belonging to each sub-group that constitutes the query tree. From this area each field can be chosen in order to build the desired query.

 

Report editor: results

When the query is executed the window showing the list of query’s results will open. All the selected data fields are all represented in individual columns.

You can generally do four things with the query result: Filter, group or sort the list of results. Statistically analyze, print or export Generate letters, work lists or reports

 

 

 

To define conditions on a certain field, double click it's label.