Revision as of 16:43, 3 January 2020

There are numerous reports on the system that cater for all different sets of data entry. Finding the right report can be somewhat challenging for a new user not familiar with reporting requirments. The guide below will highlight the most common reports within the system and questions users have.

KPI Report Designer

The KPI report designer is our most used reporting tool. There are a wide variety of reports within KPI report designer that will meet reporting needs for many different areas within the system. Firstly deciding the dates and the projects are key to what data will be extracted. Following the criteria screen you are presented with many tabs each containing multiple reports. Some of the more generic and widely used reports are below:

Number of Person/Orgs Accessing Service In The Time Period

This report will count unique people/orgs that have had a Referral, Update, Extra information or a Club clinic attendance recorded on the history page within the time period and project set on the initial screen. This is a common report for finding how many people your organisation has worked with during the time period.

Number of Contacts

This report will give all contacts in the time frame that would usually be displayed in the history of the client. This includes the first referral contact and any subsequent contacts for that referral in the requested date range. This report is very helpful for identifying all work being undertaken during a time period along with the time spent if this data is input.

Number of Referrals

Selecting to run the number of referrals report will extract the number of newly opened referrals within the timeframe and projects set on the first screen. User extract this report to identify what new work has been opened within the timeframe and can then diverge more information about these referrals from within this report.

Data Extraction

A data extraction is a report mainly used for demographic data and producing client lists. The report does not cater for contacts and work done for clients but is set on criteria based on information within the clients records in tabs such as "general details or personal details". An example of a report you could do using the data extraction would be to identify how many active client records are male.

Frequently Asked Question with Reporting

How to add more information to list of records in the report

When you have selected the right report and obtain the records you need, you may want to add more information about the records in the report, for example, their gender, ethnicity etc. In order to do this you need to select a field set to add onto the report.

How to add more data that is not selectable in field sets

The system has the extension database feature that allows users to create their own fields. In order to add this data to your report you can select to add this in the blue folder.

Which report do you select?

This is entirely dependant upon what you are trying to report on.

The report doesn't give you the specific break down you require?

As with the majority of information input onto the system, you are able to extract this into a report. Although you can customise data into a report, it may not always be in the layout or breakdown you specifically require. In these circumstances we recommend you adjust the data in an excel file, often using filtering, pivot tables or a formula.

Is there a report to monitor what my users are doing on the system?

Audit reports allow you to see what the user has input onto the system.

What the best way of viewing a breakdown of my clinics

The clinic monitoring report is a very powerful report for giving a breakdown of the people accessing and summary of the attendances during the time period the user is setting.

What's the best report for observing change on outcomes?

target comparison report will give a breakdown of first and most recent score in the time period

Why is my report with a spreadsheet template not displaying any data?

excel files exporting as csv's do not work with uploaded spreadsheet templates.