Version 3.3
Current Topic:
Reports and Charts
© 2021 TriLine GRC. All Rights Reserved.
Note: Screen shot labels and other items shown in (brackets) are configurable and may be different on your TriLine GRC system.
To access Reports, Charts and Adhoc Queries:
Note: Administrators have access to Reports, Charts and Adhoc Queries by default.
If you are an Administrator or Super User, by default, you are able to report and chart all records in the TriLine GRC system.
All other Users reports and charts are filtered to the records they have security access to.
To see more about Adhoc Queries, see Adhoc Queries.
Open Reports and Charts from the Main Menu:
Select one of the main menu options Compliance, Risk, KRI, (Events), Contracts, Obligations for an entity specific report or chart. Or select Reports from the main menu for a generalised report.
Choose a Report or Charts from within that menu Report or Chart section.
Or choose a generalised or saved report:
Note: The ‘Tasks Not Completed’ menu option will only appear if ‘Show Not Completed Button’ is configured to display.
The ‘Taxonomy’ menu option will only appear for administrators.
The selected Report or chart is displayed with its Settings Page.
Reports and Charts allows you additional ways of viewing and reporting the records contained within your TriLine GRC system.
Some Reports and Charts contain additional Reports and Charts that you can select within that Report’s or Chart’s Settings. These are shown in the table below (in the Settings ‘Select Report’ column).
Note:
In the table below, items shown (bracketed) are configurable and may be different on your TriLine GRC system.
Select from the Main Menu | Select Report | Settings Select Report |
---|---|---|
Compliance | ||
Compliance Process | ||
Process Controls | Compliance List Completed Tasks Current Tasks Current Tasks Summary Overdue Tasks |
|
Task Due Date Changes | ||
Risk | ||
Risk | Risk List Capital Allocation Risk Score Change Risk Score Exceeds Appetite Risk Hierarchy Risk Summary Reviews Competed Current Risk Reviews Current Risk Reviews Summary Overdue Risk Reviews |
|
Risk Review Due Date Changes | ||
Risk (Treatments) | Risk List Completed Tasks Current Tasks Current Tasks Summary Overdue Tasks |
|
(Treatments) Due Date Changes | ||
KRI | ||
KRI List and Tasks | KRI List Current Summary Completed Tasks Current Tasks Current Tasks Summary Overdue Tasks |
|
KRI History | Task History 6 Month Summary 12 Month Summary |
|
Task Due Date Changes | ||
(Events) | ||
(Event) | ||
Tasks | Completed Tasks Current Tasks Overdue Tasks |
|
Task Due Date Changes | ||
Registers | ||
Registers | ||
Tasks | Completed Tasks Current Tasks Overdue Tasks |
|
Task Due Date Changes | ||
Contracts | ||
Contracts | Contract List Contract Renewal History |
|
Tasks | Contract List Completed Tasks Current Tasks Current Tasks Summary Overdue Tasks |
|
Renewal Tasks | Completed Tasks Current Tasks Overdue Tasks |
|
Task Due Date Changes | ||
(Control Inventory) | ||
(Control Inventory) | ||
Effectiveness History | ||
Tasks | Completed Tasks Current Tasks Overdue Tasks |
|
Task Due Date Changes | ||
Document Library | ||
Document List | Document List Reviews Completed Current Document Reviews Overdue Document Reviews |
|
Obligations | ||
Obligations List | ||
Linked Obligations | ||
Tasks | Completed Tasks Current Tasks Current Tasks Summary Overdue Tasks |
|
Task Due Date Changes |
Note:
In the table below, items shown (bracketed) are configurable and may be different on your TriLine GRC system.
Select from the Main Menu | Select Chart | Settings Select Chart | |
---|---|---|---|
Compliance | |||
Outcomes | |||
Risk Rating | |||
Risk Rating Map | |||
Risk | |||
Aggregation by Category | |||
Outcomes | |||
Rating Assessment Gantt | |||
Rating Score Comparison | |||
(Risk Score) by Risk | |||
(Risk Score) History | |||
Risk Rating / (Risk Score) Summary | (Inherent Rating Score) (Risk Score) Residual Risk Rating Inherent Risk Rating |
||
Risk Rating Map | Inherent Risk Residual Risk |
||
KRI | |||
KRI | KRI By Category KRI By Rating KRI By Trend KRI By Owner KRI Rating By Category |
||
KRI History | |||
KRI By Trend/Rating | |||
(Event) | |||
(Event) | Category Cause Status Type |
||
Registers | |||
Registers by Manager | |||
Registers by Status | |||
Contract | |||
Contract | Entity Responsible Officer (Business Unit) Type |
||
(Control Inventory) | |||
(Control Inventory) | (Business Unit) Effectiveness Owner Type |
||
Effectiveness | |||
Document Library | |||
Document Library |
If you find yourself often creating and filtering a particular Report or Chart, you can save the Report or Chart settings and then access the customised Report or Chart from the Main Menu Reports | Saved Reports/Charts whenever you need to.
See Save Report/Chart Settings for more information.
Note: Screen shot labels and other items shown in (brackets) are configurable and may be different on your TriLine GRC system.
Note: Only members of the ‘View Reports’ Security Group (and Administrators) can create and view reports. If no Positions are added to the ‘View Reports’ Security Group then all Positions can create and view Reports. Records displayed in Reports is security filtered.
Select a Report (see Opening Reports and Charts), or if you already have a report open, click the Settings icon.
The ‘Settings’ popup window is displayed (‘Risks’ Report settings shown).
Where available, click the ‘Select Report’ drop-down list and select a Report (‘Risks’ Report drop-down list shown). Selecting different Reports will change the display Filters and Options.
Note: The options shown in the ‘Settings’ popup window will be different for each Report.
Select Report Filter criteria from the available drop-down lists. Using the ‘Risks’ Report as an example:
As you select the Filter criteria, they are displayed in the ‘Applied Filters’ List.
To remove a Report Filter:
Select the Filter entry in the ‘Applied Filters’ List (e.g. ‘Sub-Category >> Financial - Budget Management’), and
Click the icon to remove the Filter from the List.
To remove all Report Filters, click the icon.
Where available, you can group Report information by selecting criteria from the ‘Group By’ drop-down list (e.g. ‘(Business Unit)’).
You have the option of setting your own Report Title by typing text in the ‘Report Title’ field.
Click the Run Report icon to apply the Report Filters and display the Report Page(s).
Note: The contents of the Report will be limited by Security settings.
Run the Report (See Set Report Filters and Run Report).
The ‘Report’ Panel is displayed.
Navigate (1 & 10), search (6), print (3 & 4) and save (5) the Report Using the Report Preview Page Toolbar.
On the right hand side of each report is an expand icon <
1 which, when clicked, reveals more features. Clicking this icon >
, will hide the additional features.
>
to hide this panel.>
to hide this panel.>
to close this panel.>
to close this panel.See Customisation TriLine GRC.
Note: Only members of the ‘View Reports’ Security Group (and Administrators) can view Charts. If no Positions are added to the ‘View Reports’ Security Group then all Positions can view Charts. Records displayed in Charts is security filtered.
Select a Chart (see Opening Reports and Charts). Example from the main menu select Risk | Risk Rating / (Risk Score) Summary.
The selected Chart Page is displayed, example 'Compliance ‘Residual Risk Rating’ Chart.
Note: Only some charts have the ‘Select Chart’ option.
Note: Not all charts have click through.
Note: Only some charts have matching configuration colours.
Display a Chart. Example from the main menu select Compliance | Risk Rating.
Click the Chart Settings icon.
The Chart ‘Settings’ popup window is displayed.
Where available, click the Chart Type
drop-down list and select a Chart Type.
Note: The options shown in the ‘Settings’ popup window will be different for each Chart.
Select Chart Filter criteria from the available drop-down lists. For example:
(Business Unit)
drop-down list, select Finance
, andCategory
drop-down list, select Operational
.As you select the Filter criteria, they are displayed in the Applied Filters
List.
To remove a Chart Filter:
Select the Filter entry in the Applied Filters
List (e.g. Category >> Operational
), and
Click the icon to remove the Filter from the List.
To remove all Chart Filters, click the icon.
Optional set the Chart Title by typing text in the Chart Title
field.
Click the icon to apply the Chart Filters and return to the Chart Page.
Note: The contents of the Charts are Security filtered.
Display a Chart and click the Chart Settings icon. The Chart Settings window is displayed. Click the
icon to print the Chart.
Charts can be copied and pasted into documents, spreadsheets and presentation tools to enhance external reports.
Right click in the title area as highlighted in 1. Select Copy (relevant to your browser). This copies an image of the Chart to the clipboard.
Switch to your document editor, spreadsheet and presentation tool and choose paste the bitmap. For example to paste into Word:
Run a Report or Display a Chart with the desired Filter settings.
On the Report or Chart Page, click the icon. The respective Save settings window is displayed. In this example, the selected report is ‘Risk Lists’ and the chart is 'Compliance ‘Risk Rating’.
Click the icon 4 to save the Report/Chart Settings.
Note: The ‘Set Dates’ fields are only displayed if they are a Filter criteria for the Report or Chart.
Note: You can access your saved Reports/Charts from the Main Menu—see View saved Reports/Charts.
From the Main Menu, select Reports | Saved Reports/Charts.
The ‘Saved Reports/Charts’ Page is displayed.
Select a tab as follows:
Tab | Available Reports/Charts |
My Reports | Reports that you have saved for your own use (i.e. ‘Public’ option not selected). |
Public Reports | Reports that you have saved as ‘Public’. Reports that other Positions have created and saved as ‘Public’. |
My Charts | Charts that you have saved for your own use (i.e. ‘Public’ option not selected). |
Public Charts | Charts that you have saved as ‘Public’. Charts that other Positions have created and saved as ‘Public’. |
Click the icon alongside your chosen Report/Chart to view it.
Notes:
Only the creator of a public Report or Chart (and an Administrator) can make changes to that Report or Chart.
The changes that can be made include changing the Report/Chart Title and Description, and whether or not the Report/Chart is ‘Public’. To change the Filter criteria:
- delete the saved Report/Chart,
- recreate the Report or Chart, and
- save the new Report/Chart settings.
From the Main Menu, select Reports | Saved Reports/Charts. The ‘Saved Reports/Charts’ Page is displayed. Click the icon alongside your chosen Report/Chart to edit it.
The ‘Edit My Report’ (or ‘Edit My Chart’) popup window is displayed.
Edit the ‘Description’, ‘Public?’ and ‘Title’ fields as desired, then click the icon to save your changes.
From the Main Menu, select Reports | Saved Reports/Charts. The ‘Saved Reports/Charts’ Page is displayed. Click the icon alongside your chosen Report/Chart to delete it.
A ‘Confirm Delete’ dialog is displayed. Click OK
to delete the saved Report/Chart.