Revision as of 16:51, 8 January 2013

To open the report editor window go to Reports -> Report editor.

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 the values of the selected fields to some condition.

For example you may want to select only cycles where the # of collected oocytes is > 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 untick 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 to create clearly arranged lists and statistics. 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 automatically grouped by certain fields. To do so, simply tick 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 result table.

Next possible steps