COM Standard Reports

The following changes have been made for COM SQL reports in v19. Items with a * were introduced (partly or in whole) in a maintenance release build of v18.

  • Support for COM 64-bit standard Crystal reports has been added.
  • COM standard and custom Crystal reports can now be run without registration.
  • The Report Launcher can now display multiple reports. With a report open, a new tab is now displayed when users open a report for another feedback record.
  • An option, Excel (Data Only) has been added to the Export parameter of the COM Customer Service standard report. If selected, the report data is exported into a Microsoft Excel spreadsheet, which users can modify according to their report requirements.
  • A parameter, Group By has been added to the COM Roll Up standard report. If the No Group option is selected, the data is added in the A to Z Feedback subtype list. If the Report Group option is selected, the data is sorted by Report Group, and then added to the list.
  • A new parameter, Roll Up Divisions, has been added to the COM Top 10 standard report. If selected, the data of the selected divisions are aggregated depending on the other selected parameters, for example, by Reporting Group.*
  • The following changes have been made for COM SQL reports security:
    • New security key: Reports/SQL Reports/Customize Grid - If granted, users are allowed to customize the grid of a SQL report.
    • The following security keys have been moved:
      • Edit SQL Report Query is now under Reports/SQL Reports/Edit SQL Report Query. Previously, it was under Trapeze4/General Tools.

      • Change Report Setting is now under Reports/Change Report Setting. Previously, it was under Trapeze4/General Tools.

      The following query: UpdateSecurityKeys_SQL.sql for SQL or UpdateSecurityKeys_Oracle.sql for Oracle must be run to update the security keys in the database. The files can be found in the Modules\Extra\Data\Common folder in your build directory. They must be run if you are upgrading your Trapeze6 build from previous versions to this and later releases.*