Deprecated: Please Please See(2024.1) Custom Reports
| Table of Contents | ||||
|---|---|---|---|---|
|
License
The Crystal Reports module requires a separate license to be installed before key parts of the functionality are available. This license is disabled by default. Please contact PCR to obtain a license.
Manage Reports
...
Crystal Reports can be managed and associated by Users of PCR-360. These reports can be associated with individual Users and on Forms throughout the application.
Uploading Reports
To upload a new report:
Go to Admin > Crystal Reports > Upload Reports
Click Upload File(s)
Choose the report from your PC and click Open. Remember that only valid .rpt files will be allowed to upload to the PCR-360 server.
Click Done
Edit Selected
The 'Edit Selected' button will let a User modify a report.
...
The 'Scheduled Batches' tab includes the same functionality as the 'Create Batch ' button on the Manage Reports grid.
...
The 'Filters' tab allows the User to determine which User the report will be assigned to. An Admin can select to use a 'Prebuilt Filter' The Batch Filter grid is where the 'Prebuilt Filters' are created and stored, and a complete guide to creating these filters is available there. If the User doesn't want to use the Prebuilt Filters, then new filters can be created from scratch.
...
The 'Save to History' button will create a report that can be accessed by the User. It is assigned to the Historical Reports where it can be accessed by the User(s) it is assigned to.
...
To assign a report to a PCR-360 form
Navigate to the desired form. For example, Main > Service Desk > Orders
Click the Options menu
, then Manage Reports
Click the Add button.
Choose the report you want from the Upload list.
Click the Save New button.
You will need to close the Manage Report Links screen and the Add New Service Order screen.
Open an existing Service Order. On the title bar of the screen next to Options, you should now have a Reports menu option.
Click Report and then select your report to View the report. You can have multiple reports per form.
Batch Filter
| Anchor | ||||
|---|---|---|---|---|
|
...
This will add a User defined Filter to the 'Prebuilt Filters' drop down on the 'Filters' tab in the Create Batch form. There are only two required fields for this operation. The 'Name' of the Batch Filter that is desired serves as a descriptor that can be easily searched for and the actual SQL of the filter.
Batch Filter SQL must contain 2 specific columns in the select: KEY*and*ASSIGN.
KEY - this column is the parameter that is passed to each Crystal Report when they are executed.
ASSIGN - this parameter is assumed to contain a USERS table RECID. It is used when assigning the Saved Data report to specific User in the Historical Report table.
After writing the SQL the User can click the button.
...
The 'Delete Selected' button will remove any Batch Filters that the User has created.
| Child pages (Children Display) | ||||
|---|---|---|---|---|
|