Reports

ActiveReports1 is a reporting tool embedded in Respond 5.1 and newer. See Working with Reports in the ActiveReports online help to get started using ActiveReports. See Active Reports FAQ for a list of frequently asked questions about ActiveReports. For a list of already configured reports you can download, see Sample ActiveReports on MyCityworks for more information.

PREREQUISITES:

  • A user must be assigned to the WORKMGR > Report Designer employee relate in order to access and create reports on the Reports page. See Assign Permissions to Employees in the Admin 3.6 Guide for more information

  • The first time you install Respond, you need to add any apps or pages you need or want to access. For example, use the Route menu option to add a menu item that navigates to the Asset Details, License Management tool, and other pages. See Add Menu Items and Edit Item Fields for more information. The Route is Report Designer for the new menu item.

When an active report is saved, it's automatically registered as an available print template for the corresponding activity type. Reports can be selected in Admin on the Work Activity Templates, the Preferences, and the Case Templates pages. Reports saved within ActiveReports can be found in the website directory under ...\<site_name>\cw-site-data\_tenant-data\_default-volume\tenant-1\reports. See Configure Printing for Service Requests, Configure Printing for Inspections, Configure Printing for Work Orders, and Configure Printing for Case Templates in the Admin 3.6 Guide for more information.

ActiveReports templates can be uploaded in Admin using the Systems Reports page. A PLL license is required to use this page. See Add a Report in the Admin 3.6 Guide for more information.

For Cityworks Online clients, there are no adjustments that need to be made, as the ActiveReports connection string automatically points to the replica database. Any new reports created that utilize the DefaultDataSource reference the replica database.

IMPORTANT: Crystal Reports can be migrated using the ActiveReports Migration Tool. See the ActiveReports Migration Tool Guide on MyCityworks for more information.