Reports are executed as background tasks, in the order they were submitted. Many ADAMS users may be submitting reports at the
- Reporting Overview
- Configure Your Report
- Selecting Data
- Defining Selection Criteria (Filters)
- Defining Report Output Controls
- Report Title and Sub-Title
- Submitting a Report
- Reusing Report Templates
- List of all reports
Reporting Overview
ADAMS features a reporting function, which allows data to extracted from most of its modules. For example:
- The "Whereabouts Monthly Submission Report" can showcase which athletes have submitted their whereabouts – or not – for a particular quarter;
- The "Athlete Report" can be used to extract the athlete profile information (e.g. the address details) for a specific group of athletes;
- The "TUE Report" can be used to extract all TUEs corresponding to specific criteria: status (approved, in process, etc.), date range, substances, etc.
To create a report :
- Click the Reports link on the My Zone page
- Select the relevant report
(The list of report options displayed depends on the user's security access rights.)
Configure the Report
Creating a report involves a few steps:
- Select the data elements that will appear on the report
- Define the selection criteria (or filters) for the specific information you are looking for
- Additionally the output control parameters such as; report title and sub-title, can also be defined
- Submit the report.
- The reports can be saved as templates that can be reused for future reports
These steps are described in detail in the following sections.
Selecting Data
Once you selected a report, you should select which data elements, or data columns, will appear on it.
- Click the select button next to Desired columns. This will show the Report Columns pop-up; the available data elements will appear on the left, under Available Items:
- Select any data element from the Available Items box on the left, and use the add button to move it to the Selected Items box on the right. The remove button can be used to remove any selected data element. The add all and remove all buttons can also be used to quickly move all data elements from one side to the other.
- To change the order in which the data will appear in the report click Selected data element, and then click the up or down arrows on the right to change its order in the list.
- When the list is complete, click the Save button.
Defining Selection Criteria (Filters)
Selection criteria can be defined to filter which data will appear on the report. For example, an athlete report could be created, which would include only International RTP athletes, or a lab results report containing data only for a specific Mission Order, etc.
The selection criteria are located right underneath the Desired columns box and occupy most of the report page:
To specify a filter, simply enter a value according to the type of filter: select a value from a drop-down box or radio button group, type in a value in a textbox, or click the select button and select one or more values from the selection pop-up window.
Defining Report Output Controls
The following report controls could be used to define the way data will be presented in the report:
- Group by
- Sort order
- Report format
Group By
This control can be used to group data on the report by the most common criteria: for example by sport, discipline, custodial organization, status, etc.
Each group of records is shown under a section break with a header. The end of each section shows a total number of records for the group.
Sort Order
This control can be used to sort data on the report by the most common criteria: for example by athlete name, ADAMS ID number, date, etc.
It is possible to change the sort order of the data after the report is produced in grid format: clicking the column header in the report will toggle between the ascending and descending order for that particular column.
Report Format
This control can be used to select the format in which the report will be rendered. Most reports can be produced in one of the following formats:
Grid (default): the information in this report format is presented in a tabulated HTML layout. Some fields in the report may appear as a blue hyperlink: clicking it allows you to quickly access the athlete or document it refers to, in the main window of ADAMS.
CSV: this option allows the data to be saved in a comma-separated value file that can be accessed by a common editing application, like OpenOffice Calc or Microsoft Excel.
PDF: this option allows the report to be saved as a Portable Document Format, which can be viewed on any software platform and can be easily printed. If all selected columns cannot be shown on a regular page, in portrait or landscape page orientation, then only the first ones will be shown. It is therefore important to carefully select the columns – and their order – to appear on this report format.
XML: this option allows the report to be saved as Extensible Markup Language format. This format includes the tags of each data element; it can be used to interface with other software systems.
Report Title and Sub-Title
An optional report title and sub-title can be created for each report. For example, the contents of the report could be the title (e.g. "My Organization Whereabouts Submission") and the sub-title for the group included in the data (e.g. "IRTP Athletes"), etc.
Simply enter the report captions in the corresponding textboxes at the top of the report page:
The report title and sub-title will appear at the top of the grid format report, and on each page of the PDF format report:
The title will also appear in the My Reports page and in the saved report name – see sections on "My Reports Page" and "Saving Report Templates" for more details.
Submitting a Report
Once the report parameters have been defined – columns, report control, selection criteria and title – then the report can be submitted.
Important :
To submit a report, click the view report button at the top of the page:
This will open the Report has been launched pop-up: click the Go to My Reports button:
My Reports Page
The queue of reports you submitted will be displayed in the My Reports page.
To access the My Reports page in ADAMS, you may click the green My Reports link which appears on the ADAMS taskbar:
The green link will appear as long as you have some unread reports. Once all reports are read, the link will disappear. To access the My Reports page, you can also click the Reports link in the My Zone page, then click the My Reports link on the right-hand side of the page banner:
All submitted reports are shown on the queue in the My Reports page. The progression of the report production appears under the Status column.
You may click the refresh button until the status is shown as Completed. Any unread report will be shown in bold font.
Viewing a Report
Once the report is ready, click the Completed status link to view it:
When clicking the Completed link:
If the report was created in comma-separated values, and depending on your browser's settings, a dialog box may prompt you to save the CSV file or open it with a spreadsheet application of your choice.
For other formats (grid, PDF or XML), your report will be displayed in the report pop-up window.
Renaming a Report
In the My Reports page, you may change the report name as it appears on the queue. This is useful to help differentiate between multiple reports with the same title.
To rename a report, click the report title link, under the Report title column, enter the new report name, and press Enter on your keyboard.
Changing the report name on the queue will not affect the contents of the report.
Viewing a Grid Report
Grid reports pre
To update a report template, open an existing template, make modifications to its parameters, then click the update button.
Once the report is saved, a confirmation message will be displayed:
sent the data in a tabulated HTML layout. Some fields in the report may appear as a blue hyperlink: clicking it allows you to quickly access the athlete or document it refers to, in the main window of ADAMS:
In the grid report, you can also click any column header to sort the data, and toggle between ascending and descending order:
Deleting a Report
Reports are automatically deleted after a few days. The number of days left is displayed in the Days until auto-deletion column. This auto-deletion period (which is currently 7 days) is set by the ADAMS Administrator.
You can also delete one or more reports in the My Reports page: just select the reports by checking the corresponding checkbox and then click the Delete the selected reports button.
Reusing Report Templates
Once you have defined parameters for a specific report, you may want to save the report template in order to re-submit the report in the future, without having to enter the parameters again.
The report template contains all the parameters used in the report: columns and filters, sort and grouping criteria, report type and title, etc. You can also save and share report templates with other ADAMS users.
Report groups
To manage saved report, you must first create report groups. A report group is similar to a file folder on your computer. Each report type may contain its own set of report groups.
Selecting a Report Group
To select an existing report group, click the report group drop-down and select one of the listed values:
Creating a Report Group
To create a new report group:
click the + button next to the report group drop-down box:
in the Report Group pop-up, click the button:add
In the dialog, enter a report group name and click :Add Report Group Save
Renaming a Report Group
To rename a report group, click the button next to the report group drop-down box, select one of the report groups in the list, then click the Edit button;
make the desired modification and
click Save
Deleting (Retiring) a Report Group
You cannot delete a report group, however you can retire it – or rename it. The report group must be empty in order to be retired. Therefore you must delete all reports inside the group before retiring a report group.
To retire a report group:
click the button next to the report group drop-down box+
select one of the report groups in the list, then click the Edit button
click the isRetired checkbox and click Save
Saving Report templates
To save a report template, you must first select a report group where the report template will be saved, then click the Save as button.
The report template will be saved in that report group, under the name entered in the Report title field. Once the report is saved, a confirmation message will be displayed:
Opening a Saved Report
To open a saved report template, click the Open button. In the Open report pop-up, select an organization, report group and report name in each of the corresponding drop-down boxes, then click the Open button.
The report template will be displayed in the report screen.
Updating a Saved Report
To update a report template, open an existing template, make modifications to its parameters, then click the update button.
Once the report is saved, a confirmation message will be displayed: