After a query has been executed the “Report editor: result” window will open.

Buttons

Some buttons have special functionalities. Click on it to have more information.

	Click this button to go back to MedITEX homepage.
	If the value related to one or more of the query’s field has been changed, the query’s result can be updated by clicking this button without executing the query once again.
	With this button a query can be set as working list in the list section or as standard letter in one of the section of MedITEX.
	With this button may be print the result table or a letter depending on which tab (Query result, Word module or Rich text module) is active.
	By clicking this button a result table may be exported in different file formats (Excel, CSV, HTML, TXT, PDF and XML).
	By clicking on this button the window “Configuration” will pop up.
	This button can be used to produce a chart.
	The sum of the values of a column is shown by clicking this button.
	The average value of the values of a column is shown by clicking this button.
	The minimum value of the values of a column is shown by clicking this button.
	The maximum value of the values of a column is shown by clicking this button.

Query results

If the query results tab is selected, all the selected data fields are shown in individual columns. Each raw of the table represents a record.

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.).

 

Statistical analysis

The results of the query can be used to carry out a statistical analisys.

There are essentially two way to produce such analisys:

You can apply basal mathematical functions such as sum, average, minimum and maximum to a column or generate a chart.

If   is clicked the sum of the values present in the column where the selected cell is, will be displayed at the bottom of the column. If is clicked the average value of the values present in the column where the selected cell is, will be displayed at the bottom of the column. If or is clicked the minimum value (in our example 0) or the maximum value (in our example 9) will be displayed at the bottom of the column.

 

Generating a chart

If the   button is clicked the following window will pop up:

For the x-axis of your statistics you can use all columns of the list of results.

For the y-axis you can only use column whose associated field from the data base contains numerical values only (integers, floating-point numbers).

These are only descriptive statistics: histograms, plots and their individual parts.

The interpretation of the y-values exclusively depends on the scale measurement of the data used (the data is, however, displayed in such a way as if the values were all interval-scaled).

Explaination of the fields/icons:
Curve, Bars... Pareto	These are different layouts that can be chosen for the chart.
	By clickng on these icon the chart will have a 2D/3D layout.
	By clickng on these icon can be set the decimal places.
	Switch between summary and average representation.
	Here can be chosen the background colours of the graph and of the form. A third option allow to swap the colours between the graph and the form.
	Click on this button to show/hide the legend.
	Click on this button to show/hide the toolbar.
	Click on this icon to see the distribution of values on X-axis.
	Click on this icon to see the distribution of values on Y-axis.
	Click on this icon to see the distribution of values of the Y-axis as a function of X-axis categories.
	Click on this icon to edit chat's titles.
	Click on this icon to edit font and colour of titles and legend.
	Click on this icon to hide/show pattern bar, palette bar and legend. By clicking on this icon it is also possible to access to the data editor.
	Click on this icon to modify the view options.
	By clicking this button the user can: choose to print the chart, to send the data or the chart to the clipboard, to export the chart as .chf, .xls or .csv file, to import the chart from .chf files to exchange chart type.

Word module

By selecting the word module tab a simple list will be shown.

 

Meaning of the columns

Placeholder	In this column of the list are shown the placeholders present in the query. Each placeholder has been generated by the selection of one field during the query building. A placeholder can be duplicated just double clicking on it. Hint: if the same field is needed more than once in the letter, just duplicate the placeholder. The new placeholder will be filled with the same value of the parent placeholder.
Utilize	Here the user can choose if the value related to a placeholder will be shown in the letter. To change the status from Yes to No and vice versa just double click on the corresponding cell.
Bookmark	In this column are shown the names of the bookmarks present in the word file related to the query. To edit the name of the bookmark just double click on it.
Value	In this column are shown the results related to a given placeholder for the selected record.
	With these buttons it is possible to swap back and forward from a record to another changing accordingly the values of the results.

 

Creating a letter

When the query is saved for the first time, a word record is created in the folder WOMOD. This folder is in File_Storage\Templates. The complete path can be seen in the settings.

	When this button is clicked the standard WOMOD template opens. The template will contains all the bookmarks listed in the Bookmarks column with the related placeholder.
If a model of the letter is available as MS word document, it is possible to save such model as template before building the query. The template must be saved in the WOMOD folder and shall have the same name that the query will have.

To create a letter:

1. Write down the standard text.

 

2. Cut and paste the bookmarks in the appropriate place. Once a bookmark is placed, the related placeholder can be deleted.

 

3. When all the bookmarks are placed and placeholder are deleted the letter can be saved.

 

	This saved letter may be edited by clicking this button.
	To visualize and print the letter related to the selected record just press : the letter with all the filled bookmarks will open: