Home
Reports
Communicare has extensive reporting features.
SQL Reports
With prior SQL knowledge, reports can be prepared in SQL and imported for ongoing use in Communicare.
Firebird HQBird 4 Troubleshooting
With the update from Firebird 2.5.x to Firebird HQBird 4.x there are changes to the way SQL queries are handled.

Reports
Communicare has extensive reporting features.
- Reports Search
- Report Options
  Selection Options, or selection criteria, determine the content of the report.
- Exporting Queries
  If required, you can export a report to Microsoft Excel or other alternative formats.
- Charts
  Communicare Charts display numeric data in an easy to read graphical format.
- Special Project Reports
  Special Project reports are those written to address specific reporting requirements from various programs, projects and agencies.
- Admissions Reports
  Report on admissions made to your health service.
- Appointments Reports
  These reports relate specifically to the Appointments module and are only available to sites that have Appointments features enabled.
- Audit Logs Reports
  Report on access to personal records.
- Clinical Record Reports
  These reports use common selection and print options to report and analyse groups of patient clinical records.
- Conditions Reports
  Report on conditions recorded at your health service.
- COVID-19 Reports
- Database Consistency Reports
  These reports provide information about the state of your database.
- Documents Reports
  Report on documents created in, sent from, or added to Communicare.
- Drug and Alcohol Treatment Reports
  Report on client enrolments and exits to Drug and Alcohol Treatment programs and analyse the effectiveness of the service.
- Electronic Claims Reports
  Use the electronic claims reports to manage Medicare claims and payments.
- Encounter Analysis
  These reports analyse patient encounters that have been recorded using the Service Recording module.
- Health Care Providers Reports
  Report on health care providers at your service.
- Immunisations Reports
  Report on immunisations.
- Investigations Reports
  Report on investigations.
- Medications Reports
  Report on medications.
- MeHR Reports
  Check MeHR upload information.
- Patients Reports
  Patients reports provide information about individual patients.
- PIP Reports
  Use the PIP report to generate Practice Incentives Program Quality Improvement Measures.
- Population Analysis
  Report on the demographics of your patients.
- Pregnancy Reports
  Report on pregnancy numbers, outcomes, diabetes and mental health.
- Private Billing Reports
- Procedures Reports
  Report on procedures, clinical items and qualifiers.
- Qualifiers Reports
  Report on patients, or patient numbers with clinical items in their clinical records with particular qualifiers.
- Recalls Reports
  Report on recalls.
- Reference Tables Reports
  These reports enable you to print information from the Reference Tables.
- Referrals Reports
  The referrals reports list and analyse referrals.
- SMS Reports
  Report on SMS appointment cancellations and batches.
- Transport Reports
  Print a form for transport services.
- Transport Management Reports
  Report on information entered using the Transport Management module.
- User Groups reports
  Report on user groups.
- Workstations Reports
  Report on workstations.
- 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.
- SQL Reports
  With prior SQL knowledge, reports can be prepared in SQL and imported for ongoing use in Communicare.
  - Parameters for SQL Reports
    When an SQL report requires input parameters the Report Parameters window is displayed.
  - Edit SQL Reports
    Use the Edit SQL Reports window to edit SQL reports from within Communicare.
  - SQL Snippets
  - Dialect 3 Troubleshooting
    Possible Errors in Reports when switching to Firebird Dialect 3 in Communicare V18.3 and later.
  - Firebird HQBird 4 Troubleshooting
    With the update from Firebird 2.5.x to Firebird HQBird 4.x there are changes to the way SQL queries are handled.
- Report Naming
  Query Builder and SQL reports are added to the Report menu or submenus according to the name they are given.
- Loading and Saving 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.

Firebird HQBird 4 Troubleshooting

With the update from Firebird 2.5.x to Firebird HQBird 4.x there are changes to the way SQL queries are handled.

If you write SQL or reports that query the Communicare database, the following SQL features that work in Firebird 2.5 either don’t work in Firebird 4 or should not be used:

Use LOCALTIMESTAMP instead of CURRENT_TIMESTAMP.
The return type of ‘COUNT’ columns is now ‘long’, not ‘int’. If you have anything assuming ‘int’ you may see an error due to ‘long’ being larger.
Good practice:
- All tables should be assigned aliases.
- Field aliases should use the 'as' keyword, for example, 'select p.pat_id as patient_id' rather than 'select p.pat_id patient_id'.
Be consistent with the coding of table joins:
- As a general rule you should use inner joins before left outer joins.
- Rather than using 'inner join' it is better to use 'join'.
- Rather than using 'left outer join' it is preferable to use 'left join'.

Table 1. Replacement SQL for Firebird HQBird 4
Old SQL	Replacement SQL
`‘today’`	`Cast(‘today’ as timestamp)`
`‘now’`	`Cast(‘now’ as timestamp)`
`‘1996-01-01’`	`Timestamp ‘1996-01-01’`
`Cast(‘1900-01-01’ as timestamp`	`Timestamp ‘1900-01-01’`
`Union`	`Union All` (when distinct list is not required)
`1=1`	`True`
`SELECT *`	Use defined column list
`Strlen()`	`Char_Length()`
`rtrim(ltrim('xxx'))`	`coalesce(trim('xxx'), '')`
`'starts'`	`'starting with'`

7 July 2025