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 iconCentral Report icon.

To import SQL reports:
  1. Click Import from one of the following locations:
    • File > Queries > Import Query from file
    • Report > Search Report
    • Tools > SQL Report Editor
  2. 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.
  3. If you want other users to be able to use this report then make it Public when prompted.
  4. 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:
  1. Select File > Queries > Export Query to file.
  2. Click Export.
  3. In the Save a query to disk file window, click Export.
  4. 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.
  5. Click OK.

See Also Parameters for SQL Reports