Reports
Communicare has extensive reporting features.
To access reports, select
.- 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
Icon | Report type | Colour | Description |
---|---|---|---|
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 | 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 | 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 | 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 SQL reports
- 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 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 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.
User access to hard-coded reports
- All users have access to the hard-coded reports in
- Users who belong to the System Administrators user group have access only to .
- For other hard-coded reports, the system rights set for the user group to which you belong determine which reports you can access.
Report > Group System | System Right Required |
---|---|
Appointments | |
Management Reporting | |
Clinical Reporting | |
Biographics |
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
- Select .
- Alternatively, if you don't know which report you need, select Report Search for more information. . See
- 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.
- Enter the required parameters and click OK.
Requesting a new Communicare report
To request that Communicare creates a new SQL report for your system, submit a Report Request.