Reporting Tool
- amani imtiyas
- Paul Angelo (Unlicensed)
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.
This will only be visible if you have purchased the 'Report Uploader' module.
The following columns are displayed in this page.
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.
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 |
|---|---|---|
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 |
|---|---|---|
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.