Reporting Tool

1. Introduction

This tool provides access to the Report Uploader area which allows you to create customised Crystal and SSRS reports and upload them to the system as well as modify any standard reports currently available.

The Reporting Tool consists of 2 areas: Report Uploader Setup and Report Uploader.

Please contact Camms Support if you are interested to activate this solution, as it does not come standard with the suite.

IMPORTANT NOTES

  • The Report Uploader feature must be activated by Camms before it can be used. 

  • Report uploader does not allow to ‘Edit’ (does not allow to add new Parameters) or ‘Remove’ Camms Standard Reports OR any client specific reports developed and deployed by Camms for the client. This will only allow the client to Add/Edit/Remove custom reports designed and uploaded by the clients themselves.

2. Report Uploader Setup

The report uploader setup screen allows the user to view and edit the current report parameters available within the system. 

Figure 2.1

This will only be visible if you have purchased the 'Report Uploader' module.

The following columns are displayed in this page.

Field

Description

Field

Description

Name

Displays the parameter ‘Name’ from the existing list of parameters within the system.

Parameters

Displays the relevant ‘Parameters’ value for those existing list of parameters within the system.

Visible in Report Uploader

A tick box to display the parameter within the report uploader parameter ‘Name’ dropdown list, when ticked.

You can click on the Edit button to edit the report parameters, and save the updates made by clicking on the Update button.

Figure 2.2

You can use the 'Visible in Report Uploader' tick box in order to configure the visibility of the parameter in the Report Uploader. 

You can discard the updates you made by clicking on the Cancel button.

Note: The users will only be allowed to edit the visibility of the parameter using this screen by ticking/unticking the Visible in Report Uploader tick box. 

Only the ticked ones will be loaded into report uploader screen. (These parameters will be loaded within the selection dropdown of ‘Name’ parameter of the ‘Add New Parameter’ grid.)

3. Report Uploader

The Report Uploader page will allow you to create customised Crystal and SSRS reports and upload them to the system as well as modify any standard reports currently available.

3.1 Uploading a New Crystal Report

This can only be done by a user with Administrator privileges.

STEP 1: To navigate to the Report Uploader page, click on the Main Menu and click on the Report Uploader menu option.

STEP 2: Select the area of reporting that you wish to upload to ' i.e., the Report Category group'. Any reports you have already uploaded are displayed along the left.

Note: Camms.Project will only have one category group titled as 'IPM'.

STEP 3: To upload a new report, click on the Add button to the right on the Reports title.

Once you click on the Add button, the right side of the screen will display a set of fields which you can fill out.

If the report you wish to upload is a Crystal report, select the 'Crystal Report' option from the Report Type field.

Once you select the Crystal Report option, the following fields will be displayed on the right side of the screen.

Field

Selection

Mandatory/Optional

Field

Selection

Mandatory/Optional

Report Type

Select type as ‘Crystal Report’.

Mandatory

Title

Define a name for the report (This will be displayed in the Report Explorer area).

Mandatory

Sequence

Input a number to define the order of the new report among the existing report list in Report Explorer area.

Mandatory

Visible

Tick the box to make the new report visible in Report Explorer area.

Optional

Report Version

Define a report version for the report.

For example, if it is a second version to an existing report, the user can enter either 1.1 or 2 as the version number.

Optional

Report File

Browse and select the new report file to be uploaded

Mandatory

Location

This will display the server location where the report is saved.

Optional

STEP 5: Once you enter the required data in all mandatory fields, you can click Save to upload the report.

3.2 Uploading a Microsoft SRS Report

This can only be done by a user with Administrator privileges.

STEP 1: To navigate to the Report Uploader page, click on the Main Menu and click on the Report Uploader menu option.

STEP 2: Select the area of reporting that you wish to upload to ' i.e., the Report Category group'. Any reports you have already uploaded are displayed along the left.

STEP 3: To upload a new report, click on the Add button to the right on the Reports title.

Once you click on the Add button, the right side of the screen will display a set of fields which you can fill out.

STEP 4: If the report you wish to upload is a Microsoft SRS report, select the Microsoft SRS option from the Report Type field.

Once you select the Microsoft SRS option, the following fields will be displayed on the right side of the screen.

Field

Selection

Mandatory/Optional

Field

Selection

Mandatory/Optional

Report Type

Select type as ‘Microsoft SRS’.

Mandatory

Title

Define a name for the report (This will be displayed in the Report Explorer area).

Mandatory

Sequence

Input a number to define the order of the new report among the existing report list in Report Explorer area.

Mandatory

Visible

Tick the box to make the new report visible in Report Explorer area.

Optional

Report Version

Define a report version for the report.

For example, if it is a second version to an existing report, the user can enter either 1.1 or 2 as the version number.

Optional

Report File

Browse and select the new report file to be uploaded

Mandatory

Location

This will display the server location where the report is saved.

Optional

User must select the specific .rdl file which should be used as the Master report for the new report. If the SSRS report only contains one report file, this prompt will not appear.  

3.3 Adding Parameters to the Uploaded Report

Once you have uploaded your new report, the Add New Parameter button will appear below the details of the report.

Preconditions:

  • A report file (Crystal/SSRS) should already be uploaded.

  • The report file must NOT be a standard report in Camms.Project.

You can follow the steps below to add parameters to the report which you uploaded.

STEP 1: Click the Add New Parameter button and add new parameters to the report.  These new parameters are the filters which would be displayed within the report filter section.

Once you click on Add New Parameter button, a new record will be added to the footer of the grid, as shown below.

The following fields will be available for the user to enter data.

Field

Selection

Mandatory/ Optional

Field

Selection

Mandatory/ Optional

Name

Select the parameter name from the existing list of parameters within the system (made visible from the Report Uploader Setup page).

For example, if your reports need a ‘Business Unit’ filter you can select the name Business Unit from the dropdown.

Mandatory

Parameters

Enter the same parameter name used within the ‘Parameter Fields’ of your Crystal/SSRS report, for the selected parameter.

Mandatory

Parameter Name

Enter the parameter name which needs to be displayed within the report filter page (report preview area of the application).

The report parameter field names should be entered into the parameters field with no spaces. A space is added automatically when the parameter is added, however ensure you remove this.

Optional

Default Values

Select a default value to be loaded for the parameter, when being displayed within the report filter page.

Optional

Hide

If ticked, the parameter will be hidden within the report filter page.

If unticked, the parameter will be displayed within the report filter page.

Optional

Sort Order

Enter the order of the display of parameters within the report filter page.

Mandatory

Show All

Tick the box, if the parameter is a dropdown and if you require the ‘Show All’ option to be available.

Optional

STEP 2:  Enter the required data in all mandatory fields within the parameter table.

For SSRS report only, make sure you 'Save' once you are done updating. If you are uploading SSRS report, do not click Save.

STEP 3: Add the Sort order number and check the 'Show all' tick box if you need the 'show all' option to be available for the parameter.

STEP 4: Once you have entered all information click Add.

3.4 Editing Existing Parameters 

You can edit existing parameters by clicking on the Pencil icon next to the relevant parameter.

Once you make the changes, you can save them by clicking on the Update button. You can discard any changes made by clicking on the Cancel button.

3.5 Deleting Existing Parameters

You can delete existing parameters by clicking on the Delete icon next to the relevant parameter.

3.6 Editing an Existing Standard/Custom Report

You can edit the properties such as the Report Name by clicking on the edit icon next to the relevant report.

For Standard Report or a Custom report developed and deployed by Camms, the user will only be allowed to edit the following fields within the Parameter table.

  • Default Values

  • Hide

  • Sort Order

  • Show All

For a custom Report (developed & uploaded by the client through the report uploader), the user will be allowed to edit all fields within the Parameter table.

You can make the changes that you wish and save them by clicking on the save icon on the top toolbar.

3.7 Deleting a Custom Report from the Report Uploader

You can delete a report by clicking on the delete icon available on the top toolbar.

3.8 Previewing the Report

STEP 1: Navigate to the Report Explorer in Camms.Project.

STEP 2: Check whether the new report is appearing within the page and then click on it.

STEP 3: Select the respective parameter values to filter the report content (from the respective list of parameters) and click on Preview to generate the report.