Latest revision as of 15:35, 18 July 2013

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

Report editor will open.

Selecting the needed fields

To select the fields in order to build a query you need to browse the content of the subgroups.

If you double-click on a group you will see all available sub-groups.

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

Alternatively you can search the field you need with a keyword search.

For this example, we are going to create a Follicle Aspiration letter.

Assume you need to search a field related to the person name:

Just type the keyword name in the Search field and press Enter. You will be provided with a list of fields that contain that keyword along with their groups and sub-groups. Choose the field you need and click on it.

The group containing that field will open.

Once you have found the sub-group containing the field(s) you need, drag the sub-group from the Group list into the Area for queries.

To select a field (i.e.: the First name field) for the query, check the empty box. In order to build our Follicle aspiration discharge letter you may need to select other fields of this sub-group such as: Surname, Partner: surname and Partner: name.

Let’s go on building our discharge letter.

Since in the sub-group Person, you will not find fields related to the therapy, you will need to link to the sub-group Persons, the subgroup Cycle of women by dragging it from the Group list into the Area for queries as previously described.

Now the desired fields from the sub-group Cycle of women can be selected as seen above for the other fields. When all the needed fields from the sub-group Cycle of women have been selected, another sub-group, if necessary, shall be dragged and dropped. This process is repeated until the query is done.

Defining fields conditions

In some cases it could be useful to restrict values of the selected fields to some conditions.

For example, you may want to select only cycles where the number of collected oocytes is greater than 8.

Simply double-click on the desired field name and the following window will open:

• You can add and combine different conditions for any field. Two or more conditions may be linked logically with AND or OR when pre-filtering.
• If you uncheck the box "and should appear in the results list", your query will be filtered but the field itself will not be displayed in the list. This can help you to create arranged lists and statistics more clearly. Example: you wish to analyze only the male patients and limit the list to men.
• You can also decide if the list of results should be automatically grouped by certain fields. To do so, simply check the box "and the result should be grouped by this field" when adding a condition. The order of your definition is decisive for the graphical representation of the resulting table.
• If you select Query the field value before execution, you will be asked what value to use before running the query. This window is displayed below and you can change de value by clicking on the corresponding field.

Next possible steps

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