Reports

Communicare has extensive reporting features.

To access reports, select Report > required report.

Communicare's reports are an invaluable management tool with varying levels of user configurability. These include:
  • Standard reports - designed and defined by Communicare with minimum user input
  • Patient Query reports - enable you to define specific criteria and values
  • Query Builder - a sophisticated query by example (QBE) module included with Communicare
  • SQL Reports - distributed with Communicare or developed by power users
An icon is displayed next to each report name to identify the type of report:
Table 1. Types of report
Icon Report type Colour Description
Hardcoded report icon Hard-coded report White Hard-coded queries are built into the Communicare code and cannot be imported, exported or modified. They have set permission rights.
Central SQL query Central SQL query Blue

Central SQL reports are maintained and distributed by Communicare.

These reports are overwritten with the latest version every time Communicare is upgraded.

They can be modified by updating the parameters, outputs and additional access rights. If you update a Central report, you must change the report name to ensure that it is not overwritten at the next Communicare upgrade. System Administrators may update a central report without changing its name, however it will be overwritten by the new central version of the report the next time Communicare is upgraded.

Local SQL query icon Local SQL query Yellow

If a new SQL query is created, or a central SQL query is modified at the SQL level, the report becomes ‘local’ and the icon changes to yellow.

Note: If a central SQL query’s SQL is modified and it was not cloned first, the report name should be altered or it will be overwritten during an upgrade.
Query Builder report icon Query Builder report White

All Communicare reports are consistent in their layout and appearance. The name of the report is displayed at the top of each page with any report options specified for the report. At the bottom of each page the date and time the report was produced shows at the centre; and the page number is on the right.

User Access to Hard-coded Reports

Access to hard-coded reports is restricted in the following ways:
  • All users have access to the hard-coded reports in Report > Reference Tables
  • Users who belong to the System Administrators user group have access only to Report > Headspace > Data export.
  • For other hard-coded reports, the system rights set for the user group to which you belong determine which reports you can access:
Table 2. System access right required for report access
Report > Group System System Access Right Required
Report > Appointments Appointments
Report > Clinical Attendance Management Reporting
Report > Encounter Analysis
Report > Population Analysis
Report > Procedures
Report > Referrals
Report > Patients > Births
Report > Patients > Deaths
Report > Patients > Patient Card Numbers
Report > Patients > Patient Query
Report > Conditions Clinical Reporting
Report > Immunisations
Report > Medications
Report > Recalls
Report > Patients > Patient Summary
Report > Patients > Patient Labels Biographics

User Access to SQL Reports

Access to SQL reports is restricted in the following ways:
  • To access central SQL and local SQL reports, your user group requires both Management Reporting and Clinical Reporting system rights at a minimum.
  • Some SQL reports have an additional system right specified by default. For example, the central SQL reports under Report > Appointments also require the Appointments system right.
  • Some SQL reports have defined viewing rights or system rights. For example, the Conditions SQL reports may be configured to have an additional requirement for the Clinical Records system right. This means your user group requires the following system rights to run any Conditions report:
    • Management Reporting
    • Clinical Reporting
    • Clinical Records
  • A small number of SQL reports, such as some in Report > Reference Tables > Clinical Item can only be run by users in the System Administrators user group. Administrator-only reports have the text “ONLY ADMINISTRATOR CAN RUN THIS REPORT” at the bottom of the report description.
  • Viewing Rights and Program Rights

When a report is run, the current user’s Viewing Rights and Program Rights are respected in the output. For example, you run a condition report which shows a list of presentations of selected conditions. If your user group doesn't have the Psychological viewing right set, the output won't display any conditions attached to the ‘Psychological’ viewing right, such as Depression.

Note: For scheduled reports, Viewing Rights and Program Rights are ignored and the full report is generated. The report scheduler has no understanding of the Viewing Rights or Program Rights associated with the email recipient list.

Modifying Reports

To create a new query, modify a query, export or import a query, the user group to which you belong requires the Report Administration system right.

If an SQL report is disabled or was created by a user who has made it 'not public', it cannot be seen by other users.

Running Communicare Reports

To run a report:
  1. Select Report > report required.
  2. Alternatively, if you don't know which report you need, select Report > Search Reports. See Report Search for more information.
  3. Read the detailed description and click one of the buttons:
    • Yes - run the report to produce a printable report suitably laid out with title and details
    • No - cancel the operation and don't run the report
    • Export - open and display the results in Microsoft Excel if this program is installed on your computer
    • Advanced - open the results in a grid with options at the bottom to edit the printable layout (and preview the results) or export the results with user-defined selections.
  4. Enter the required parameters and click OK.

Requesting a New Communicare Report

To request that Communicare creates a new SQL report for your system, in the Client Portal, complete and submit the report request form.