## Creating custom reports and templates

Use the Crosstab or the Frequency tab – see area B in the Reports form (see Figure 13 on page 88).

As with the provided templates, custom reports are viewed in the tabular results area C in the Reports form, and optionally printed or exported as a CSV file. Once you have defined your custom report, you can either save it as a named template, or simply discard it. If you save the template, its name will appear as an option for future use in the Template drop-down list in area B in the Reports form.

The two tabs represent two different ways of viewing the selected data.

Crosstab | Create a table with two different variables on the each axis (and shown in the row and column headers). You then have the option of specifying whether the cells contain numbers or percentages; and if the latter, what the percentages are how they are displayed.
Frequency | Create a table with the values that can be taken by a single variable (for example, HasHAI has possible values of Yes (Y) and No (N)) on one axis and the frequency of occurrence on the other.

To create a custom report:

1. Click Reports in the main menu.

2. Select one or more hospitals and the protocol.

3. In the Template field, select Custom.

4. In the Source field select your source for your data.

The number of options depends on the protocol you have selected.

5. Select the Crosstab tab, and specify the variables you want to see in a table, and the format of the data within the cells in that table.

Option | Description
Criterion 1 | Defines the vertical axis, i.e. row headings
Criteria 2 | Defines the horizontal axis, i.e. column headings
Count | The cells contain raw* data; and the column and row totals are unscaled numerical values.
% by table | Each cell contains a percentage of the raw* total for the whole table.
% by row | Each cell in a row contains a percentage of the sum of the raw* values for that row.
% by column | Each cell in a column contains a percentage of the sum of the raw* values for that column.

*the raw value is the numerical value in the table before any calculations are made.

6. Alternatively, select the Frequency tab and select the variable (criterion) whose data you want to display, in this case HasHAI (from the field Patient has active HAI). The frequencies, in terms of the count and percentage, are shown for each value of the selected variable.

7. Optionally, as for the default templates, click Print to print the table, or Export to export the data as a CSV file.

8. Click Save a template, to save these table settings as a named templete.

The template is automatically added to the Template drop-down list, so that you can reuse these settings again later.

Note: You cannot save a template that is identical in function to an existing template; if you try this, you simply get an error message.

More:

Changing the display precision settings

HelicsWin.Net v2.2 Online User Guide v20160330
© European Centre for Disease Prevention and Control, 2016
Reproduction is authorised, provided the source is acknowledged