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.

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

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

The following columns are displayed in this page.

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

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.

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.)

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.

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.

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.

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.

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.