Risk Reports
1. Overview |
The system provides a range of standard reports which allows you to filter and generate reports on risks and risk actions in your system.
Reports can be accessed from the Navigation Menu under Reports > Risk Reports.
Note: Risk Reports can be accessed from the left-hand navigation panel too.
Once the report has loaded in the SSRS viewer, it is up to you on whether you want to export the report to Microsoft Word (editable) or PDF (View) or Excel (Editable).
When clicking on any of the report icons, you will select the filters available (if applicable) and then click on the preview icon to load the report. |
Select the export icon to choose your selection:
Note: some reports are developed specifically for an excel export (mainly the risk register reports), and some reports are better viewed with PDF (generally all other standard reports).
When exporting to MS Word, there may be some formatting limitations that will occur. CAMMS can look at these if required. There is no guarantee that all formatting issues can be resolved at CAMMS end. However, we can highlight these to Microsoft.
Risk Reports – CAMMS Standard
Full Risk Register – CAMMS Standard
Simple Risk Register Report – CAMMS Standard/Other Risk Reports
Individual Risk Report – CAMMS Standard
Operational Risk Report – CAMMS Standard
Project Risk Report – CAMMS Standard
Strategic Risk Report – CAMMS Standard
Risk Action Summary Report – CAMMS Standard
Risk Executive Report – CAMMS Standard
Risk Professional System Administration Report – CAMMS Standard
Risk Status Report – CAMMS Standard
Risk Action Status Report – CAMMS Standard
Risk Action Report – CAMMS Standard
Administration Reports (Stand Alone Only) click here to view Admin Reports
Organisation View – CAMMS Standard
Organisational List – CAMMS Standard
Staff List – CAMMS Standard
User Overview – CAMMS Standard
2. Full Risk Register Report (Standard) |
This report contains a full export of the risks, mitigations and descriptions of the risk criteria used.
Please note – whilst this report can be downloaded in a variety of formats, because of the unique formatting this report has, MS Excel is the most appropriate medium for report presentation. The report format and columns can then be manipulated to suit. If generated in PDF for example, screen views may be restrictive due to the size and format of the report.
FILTERS | |
---|---|
Filter | Description |
Risk Type | Dropdown allows users to choose the type of risk (Default to 'Show All'). |
Directorate | Dropdown allows users to choose the Directorate (Default to 'Show All'). |
Business Unit | Dropdown allows the users to choose the Business Unit (Default to 'Show All'). |
Risk Category | Dropdown allows the users to choose a Risk Category (Default to 'Show All'). |
Responsible Officer | Dropdown allows the users to choose the Responsible Officer (Default to 'Show All'). |
Risk Treatment | Dropdown allows the users to choose the Risk Treatment (Default to 'Show All'). |
Sort Risk First Priority | Dropdown allows the users to sort the Priorities accordingly. This allows the user to define the First sorting priority (Default is set to 'Current Risk Rating'). |
Sort Risk Second Priority | Dropdown allows the users to sort the Priorities accordingly. This allows the user to define the Second sorting priority (Default is set to 'Initial Risk Rating'). |
Sort Risk Third Priority | Dropdown allows the users to sort the Priorities accordingly. This allows the user to define the Third sorting priority (Default is set to 'Risk Code'). |
Risk Status | Dropdown allows the users to choose the status of the Risk (Default is set to 'Active'). |
Business Process | Dropdown allows the users to choose the Business Process which is applied to the Risk (Default is set to 'Show All'). Only Applicable if you utilise these fields. |
Legislation | Dropdown allows the users to choose the legislation which is applied to the Risk (Default is set to 'Show All'). Only Applicable if you utilise these fields. |
Action | Allows you to filter the Project Risks by the specific Action (Default to 'Show All'). |
REPORT DETAILS | |
---|---|
Report Element | Description |
Reference Number | Displays the Risk Code. |
Risk Title | Displays the Risk Title. |
Primary Category/Subcategory | Displays the Primary Category followed by the Subcategory. |
Secondary Categories | Displays the Secondary Categories. |
Risk Type | Displays the Risk Type. |
Risk Identification | |
Risk Title | Displays the Risk Title. |
Causes | Displays the Causes for the three assessments - Initial, Current and Future. |
Consequences | Displays the Consequences for the three assessments - Initial, Current and Future. |
Existing controls | Displays the Existing Controls for the three assessments - Initial, Current and Future. |
Evaluation | |
Effectiveness of Controls | Displays the effectiveness for the three assessments. |
Risk Treatment | Displays the Risk Treatment for the three assessments. |
Initial Risk Assessment Rating | |
Consequences | Displays the rating for the consequences. |
Likelihood | Displays the rating for the Likelihood. |
Risk Rating Score | Displays the Initial Risk Rating Score. |
Risk Rating | Displays the overall Risk Rating image. |
Excel Export:
3. Simple Risk Register (Standard) |
This Report contains an export of the risks and a highlight of its related details.
Please note – whilst this report can be downloaded in a variety of formats, because of the unique formatting this report has, MS Excel is the most appropriate medium for report presentation. The report format and columns can then be manipulated to suit. If generated in PDF for example, screen views may be restrictive due to the size and format of the report.
FILTERS | |
---|---|
Filter | Description |
Risk Type | Dropdown allows the users to choose the type of risk (Default to 'Show All'). |
Directorate | Dropdown allows the users to choose the Directorate (Default to 'Show All'). |
Business Unit | Dropdown allows the users to choose the Business Unit (Default to 'Show All'). Note: If 'Strategic Risk' is selected for Risk type, selecting 'Directorate’ or 'Business Unit’ will display a blank report. This is due to strategic risks not having these links. |
Risk Category | Dropdown allows users to choose the Risk Category (Default to 'Show All'). |
Responsible Officer | Dropdown allows the users to choose the Responsible Officer (Default to 'Show All'). |
Risk Treatment | Dropdown allows the users to choose the Risk Treatment (Default to 'Show All'). |
Sort Risk First Priority | Dropdown allows the users to sort the Priorities accordingly. This allows the user to define the First sorting priority (Default is set to 'Current Risk Rating'). |
Sort Risk Second Priority | Dropdown allows the users to sort the Priorities accordingly. This allows the user to define the Second sorting priority (Default is set to 'Initial Risk Rating'). |
Sort Risk Third Priority | Dropdown allows the users to sort the Priorities accordingly. This allows the user to define the Third sorting priority (Default is set to 'Risk Code'). |
Risk Status | Dropdown allows the users to choose the status of the Risk (Default is set to 'Active'). |
Business Process | Dropdown allows the users to choose the Business Process which is applied to the Risk (Default is set to 'Show All'). Only Applicable if you have these fields enabled. |
Legislation | Dropdown allows the users to choose the legislation which is applied to the Risk (Default is set to 'Show All'). Only Applicable if you have these fields enabled. |
Project | Allows you to filter the Project Risks by the specific Project (Default to 'Show All'). |
REPORT DETAILS | |
---|---|
Report Element | Description |
Risk Code | Displays the Risk Code. |
Risk Description | Displays the Risk Description. |
Causes - Initial | Displays the Causes through the Initial state. |
Risk Action | Displays the Risk Actions against the Risk. |
Primary Category/Subcategory | Displays the Primary and Subcategories. |
Secondary Categories | Displays the Secondary Categories. |
Responsible Person | Displays the Responsible Person name. |
Secondary Responsible Persons | Displays the Secondary Responsible Person name. |
Business Unit | Displays the Business Unit that the risk is linked to (Operational risks only). |
Initial | |
Consequence | Displays the Consequence description for the initial assessment. |
Likelihood | Displays the Likelihood description for the initial assessment. |
Risk Rating | Displays the Risk Rating in the Initial assessment. The cell will be coloured based on the risk rating. |
Current | |
Consequence | Displays the Consequence description for the current assessment. |
Effectiveness of Controls | Displays the Effectiveness of controls description. |
Likelihood | Displays the Likelihood description for the current assessment. |
Risk Rating | Displays the Risk Rating in the Current assessment. The cell will be coloured based on the risk rating. |
Future | |
Consequence | Displays the Consequence description for the Future assessment. |
Likelihood | Displays the Likelihood description for the Future assessment. |
Risk Rating | Displays the Risk Rating in the Future assessment. The cell will be coloured based on the risk rating. |
Report output example:
4. Individual Risk Report (Standard) |
This Report contains the details of each risks including the relevant risk actions and linked controls.
FILTERS | |
---|---|
Filter | Description |
Risk Type | Dropdown allows users to choose the type of risk (Default to 'Show All'). |
Directorate | Dropdown allows users to choose the Directorate (Default to 'Show All'). |
Business Unit | Dropdown allows users to choose the Business Unit (Default to 'Show All'). |
Risk Rating Initial | This will allow users to choose the Initial rating for the Risk (Default to 'Show All'). |
Risk Rating Current | This will allow users to choose the Current rating for the Risk (Default to 'Show All'). |
Risk Rating Future | This will allow users to choose the Future rating for the Risk (Default to 'Show All'). |
Risk Category | Dropdown allows users to choose the Risk Category (Default to 'Show All'). |
Responsible Officer | Dropdown allows users to choose the Responsible Officer (Default to 'Show All'). |
Risk Treatment | Dropdown allows users to choose the Risk Treatment (Default to 'Show All'). |
Sort Risk First Priority | Dropdown allows users to sort the Priorities accordingly. This allows the user to define the First sorting priority (Default is set to 'Current Risk Rating'). |
Sort Risk Second Priority | Dropdown allows users to sort the Priorities accordingly. This allows the user to define the Second sorting priority (Default is set to 'Initial Risk Rating'). |
Sort Risk Third Priority |