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.

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.
- 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.
- 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.

SQL Reports

With prior SQL knowledge, reports can be prepared in SQL and imported for ongoing use in Communicare.

SQL Reports are identified in the main Report menu, prefixed with either a yellow SQL report icon SQL icon, or blue Central Report icon.

To import SQL reports:

Click Import from one of the following locations:
- File > Queries > Import Query from file
- Report > Search Report
- Tools > SQL Report Editor
In the Load query from a disk file window:
1. Set the file to the type being imported (*.QRY, *.SQL or *.XML).
2. Navigate to the location of the SQL Report that is required, and click OK.
If you want other users to be able to use this report then make it Public when prompted.
If you import a report with the same name as a current report you will be prompted to confirm you wish to overwrite the report with the imported version. Only users belonging to the System Administrator group may overwrite a central report this way.

Imported reports are listed in the Report menu, prefixed with the yellow SQL report icon SQL icon.

See Edit SQL Reports for more detail.

If required, you can export SQL reports.

To export SQL exports:

Select File > Queries > Export Query to file.
Click Export.
In the Save a query to disk file window, click Export.
Navigate to the folder where you want to save the report. Two files are created, *.sql is the code and *.mkr is the layout. Both files are required.
Click OK.

See Also Parameters for SQL Reports

14 November 2023