Home
Reports
Communicare has extensive reporting features.
Query Builder
The Communicare Query Builder module is a sophisticated query by example (QBE) application that you can use to produce a large variety of specific user-defined reports.
Where Definition

Reports
Communicare has extensive reporting features.
- Reports Search
- Report Options
- Charts
  Communicare Charts display numeric data in an easy to read graphical format.
- Appointments reports
  These reports relate specifically to the Appointments module and are only available to sites that have Appointments features enabled.
- Clinical Record reports
  These reports use common selection and print options to report and analyse groups of patient clinical records.
- Database Consistency reports
  These reports provide information about the state of your database.
- Encounter Analysis
- Patient reports
  These reports provide information about individual patients.
- Reference Tables reports
  These reports enable you to print information from the Reference Tables.
- Referral reports
- Special Project reports
  Special Project reports are those written to address specific reporting requirements from various programs, projects and agencies.
- Quick Print Services
  This function in Service Recording produces quick and convenient reports that list services.
- Reporting group activity
  Your service can set up clinical items to record group attendance broken down into demographics of your own choosing. You can then report on these demographics using a standard Communicare supplied report.
- Query Builder
  The Communicare Query Builder module is a sophisticated query by example (QBE) application that you can use to produce a large variety of specific user-defined reports.
  - Parameters for Query Builder report
    When a Query Builder report requires input parameters, the Report Parameters window is displayed.
  - Where Definition
  - Data Models
    Models are a set of related Tables which form a group.
  - Tables View
    Use the top section of the Query Builder window to view the tables when you open a model or run a sample or saved query.
  - Saving Queries
  - Query Grid
    Use the bottom section of the Query Builder window to design the query.
- SQL Reports
  With prior SQL knowledge, reports can be prepared in SQL and imported for ongoing use in Communicare.
- Report Naming
- Loading and Saving Queries
- Exporting Queries
- Report Wizard
- Report Scheduler
  Use the Report Scheduler to run a report nightly and email the report to interested users.
- Clinical Terms Group Browser
- Printer Assignments
  Set printer assignments for different report categories so that a specific printer is used.

Where Definition

When you double-click on one of the cells on the Condition row of the Query_Grid, the Enter the where definition dialog box is displayed. The current Table and Field names are displayed in the top left corner.

A Logical Operator is then selected from the drop down box, for example =, <, >, <=; >=, <>, and so on, and a value is then entered in the text box. For example, to set the condition of all patients over the age of 15 the operator is > and the value is 15.

If you need to create a more complex formula, simply add a logical operator after this condition such as OR or AND, then type a second condition. Alternatively, to enter a range of values use > 15 in the Condition line, then < 65 in the OR line. The result will be all patients aged between 16 and 64.

Note: You cannot add an OR condition if the first condition line is empty.

Note: When using Dates in Query Builder, the format must be DD-MMM-YYYY, for example, 09-JAN-2000

Conditions can be very complex. If you are unfamiliar with the concept of operators and conditions practice with some simple examples and gradually expand the criteria.

Use the Expert Mode tab to enter calculated field definitions more quickly once you are used to their syntax and how the program operates. The right side of the window lists the data fields and the calculated fields already defined, while the left side lists the operators. No special assistants are provided, and variables are created manually.

Note: When using Dates in Expert Mode the format must be 'DD-MMM-YYYY' with the date surrounded by single quotes ' '. For example, '09-JAN-2000'.

15 November 2023