Queries di Report editor

Overview

La finestra principale di Report editor è essenzialmente divisa in tre sezioni:

Lista gruppi
Sezione per query
Sezione campi query

Lista gruppi

Da questa sezione è possibile selezionare dei sotto-gruppi contenenti i campi necesari per la costruzione della query.

Facendo doppio-click su un gruppo i sotto-gruppi disponibili saranno visualizzati.

Facendo doppio-click su un sotto-gruppo i campi disponibili di quel sotto-gruppo saranno visualizzati.

Sulla sinistra, sono presenti tutte le tabelle e campi utilizzabili nella vostra query:

Pazienti
Terapie
Esami/anamnesi
Crio
Amministrazione
Personale
Medici di riferimento/Centri PMA

Trascinare sottogruppi dalla sezione di sinistra alla sezione centrale per costruire la query.

Il simbolo che precede il nome del campo definisce il tipo di dato.

I diversi simboli sono:

	Campo numerico.		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 and dropped from group list or be deleted in order to build the query tree. The sub-groups are hierarchically ordered as a Logical cascade.

Buttons with a blue dotted frame have special functionalities. Click on it to have more information.

	Execute: As soon as you have selected all needed fields, you can launch the query by clicking on this button. The result window will be opened.
	New: Clears the contents of the selection window. A new selection can be made.
	Loading a query: A saved query can be loaded by clicking on the Open button. A new window, Saved queries, will pop up. Read more about it here.
	Saving a query: A query can be saved for future use by clicking on the Save button. If the query was created from an existing query, it can be saved choosing Save as. This way, the user can assign a different name to the new query a.
	Result data records: Here you can select the number of displayed results.

Area for query fields

This area groups all 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 results will open. All the selected data fields are all represented in individual columns.

You can generally do many things with the query result:

Filter, group or sort the list of results;
Statistically analyze, print or export;
Generate letters, work lists or reports.

Filter, group or sort the list of results

The list of results may be filtered, grouped and sorted by clicking the column headers as explained here. The filtering corresponds to a logical restriction of the data sets displayed in the list of results (e.g. only the pregnant patients of all, etc.).

Statistically analyze, print or export

The results can be easily analyzed and used to build charts. Moreover, the results can be printed or exported as Excel, CSV, HTML, TXT, PDF and XML file.

Generate letters, work lists or reports

The results can be used to build standard templates of letters, reports or working lists. Such reports may be made available for users in other sections of the software such as Administration, Medical History, etc.