Instructions for Creating a Report

In order to create a report, i.e. to structure the report table and choose what information should appear in the rows and columns of the table, the user should add report components, which are:

• Text entries – title, subtitle, header, and footer. For these fields, the expected input is a free text.
• Report grouping - allows grouping data according to a specific category. Grouped data appear in different tables. Each table contains data that fall under one group of the category specified.
• Rows - group data within the report table.
• Columns - show details specific to each table row.
• Sub-columns - divide the row details displayed under each column.

In order to add report components, the user should follow the steps described below. They provide instructions on how to compose and submit queries.

Steps:

• Type the text that should appear as the report title in the ‘Title’ text box.
• Enter a ‘Subtitle’, ‘Header’, and ‘Footer’ if needed. 
• In the ‘Group Report by’ section, specify the category, which will be used to group data into different tables. To add a report grouping, click on the Add Grouping link in the ‘Group Report by’ section and select the appropriate category from the menu that appears.

Note: The report will be divided into as many tables as there are table groupings selected.

• Select table rows by clicking on the Add Row link and selecting the appropriate item from the menu that appears. Please note that it is possible to select one row at a time from the list of available rows.
• Select table columns by clicking on the Add Column link and selecting the appropriate item from the menu that appears. Please note that it is possible to select one column at a time from the list of available columns.

Note: Once the user selects a report column, an Add Sub-column link becomes available under the selected column. It allows indicating how the row details displayed under each column will be divided.

Note: At any point it is possible to remove all components selected for the report and design a new report from scratch by clicking on the  (Reset) button.