Difference between revisions of "Report Viewer"

From Keyfax Wiki
Jump to: navigation, search
(Created page with "To open the Report Viewer, select 'Viewer’. This is under ‘Reports’ on the Main Menu. Standard Reports The following is a list all standard reports along with a...")
 
 
(45 intermediate revisions by the same user not shown)
Line 1: Line 1:
To open the Report Viewer, select 'Viewer’. This is under ‘Reports’ on the Main Menu.
+
==Dashboard==
  
 +
Shows a summary of the system on a user specified day together with a summary of the system for the previous six months from the day the report is run.
  
 +
[[File:reports2.png]]
  
  
 +
==Filtering Options==
  
 +
There are various options available in the reports that will allow you to refine your searches. Which fields are available will depend on the report you have chosen but the filtering options are as follows:
  
Standard Reports
 
  
The following is a list all standard reports along with a brief description. Click on the report you are interested in to jump to the relevant section on this page.
+
'''Code:'''
 +
Enter the code you are looking for to limit the results to only show this code. You can also use %value% to find codes that are 'like' the value you have entered. For example %003%.
  
 +
[[File:filters1.png]]
  
  
 +
'''Description:'''
  
 +
Enter a description you wish to search for. You can also use %value% to find descriptions that are 'like' the value you have entered. For example %excavate%
  
Dashboard
+
[[File:filters3.png]]
  
  
 +
'''Script Set:'''
  
 +
Enter the script set you wish to search for. You can search for 'System' and 'Master' as well as the user created script sets. The %value% functionality will also work.
  
Shows a summary of the system on a user specified day together with a summary of the system for the previous six months from the day the report is run.
+
[[File:filters2.png]]
 
  
  
List of Markers
+
'''From''' and '''To'''
  
 +
Allows you to specify a date range to limit your search to.
  
  
 +
==Standard Reports==
  
Lists all or user specified markers in a script type. The user can change whether to show markers that are referenced in scripts or not.
+
[[File:reports1.png]]
  
  
 +
The following is a list all standard reports along with a brief description. Click on the report you are interested in to jump to the relevant section on this page.
  
  List of Messages
+
[[File:reports23.png]]
 +
   
 +
===List of Markers===
  
 +
Lists all or user specified markers in a script type. The user can change whether to show markers that are referenced in scripts or not.
  
 +
[[File:reports3.png]]
  
+
===List of Messages===
Lists all or user specified messages in a script type. The user can change whether to show messages that are referenced in scripts or not.
 
 
 
 
  
List of Priorities
+
Lists all or user specified messages in a script type. The user can change whether to show messages that are referenced in scripts or not.
  
 +
[[File:reports4.png]]
  
 +
===List of Priorities===
  
Lists all or user specified priorities in a script type. The user can change whether to show priorities that are referenced in scripts or not.
+
Lists all or user specified priorities in a script type. The user can change whether to show priorities that are referenced in scripts or not.
  
 +
[[File:reports5.png]]
  
 +
===List of Services===
  
List of Services
+
Lists all or user specified services in a script type. The user can change whether to show services that are referenced in scripts or not.
  
 +
[[File:reports6.png]]
  
 +
===List of Tasks===
  
Lists all or user specified services in a script type. The user can change whether to show services that are referenced in scripts or not.
+
Lists all or user specified tasks in a script type. The user can change whether to show tasks that are referenced in scripts or not.
  
 +
[[File:reports7.png]]
  
 +
===Feedback===
  
List of Tasks
+
Lists all the feedback received within a user specified date range.
  
 +
[[File:reports8.png]]
  
 +
===Order History===
  
Lists all or user specified tasks in a script type. The user can change whether to show tasks that are referenced in scripts or not.
+
Shows the order history for a user specified date range, including the number of users per month.
  
 +
[[File:reports9.png]]
  
 +
===Summary by Category and Topic===
  
Feedback
+
Lists a summary of the usage by category and topic for a user specified date range alongside the top categories for that date range.
  
 +
[[File:reports10.png]]
  
 +
===Summary by User and Category===
  
Lists all the feedback received within a user specified date range.
+
Lists a summary of the usage by user and category for a user specified date range alongside the top users and top categories for that date range. The user shown can be changed.
 
  
 +
[[File:reports11.png]]
  
Order History
+
===Summary of Markers Logged===
  
 +
Lists a summary of all or user specified markers logged within a user specified date range alongside the top markers logged for that date range.
  
 +
[[File:reports12.png]]
  
Shows the order history for a user specified date range, including the number of users per month.
+
===Summary of Priorities Logged===
  
 +
Lists a summary of all or user specified priorities logged within a user specified date range alongside the top priorities logged for that date range.
  
 +
[[File:reports13.png]]
  
Summary by Category and Topic
+
===Summary of Services Logged===
  
 +
Lists a summary of all or user specified services logged within a user specified date range alongside the top services logged for that date range.
  
 +
[[File:reports14.png]]
  
Lists a summary of the usage by category and topic for a user specified date range alongside the top categories for that date range.
+
===Summary of Tasks Logged===
  
 +
Lists a summary of all or user specified tasks logged within a user specified date range alongside the top tasks logged for that date range.
  
 +
[[File:reports15.png]]
  
Summary by User and Category
+
===User Information===
  
 +
Shows all or user specified users of the Keyfax system alongside the number of active/inactive users and last five active users.
  
 +
[[File:reports16.png]]
  
Lists a summary of the usage by user and category for a user specified date range alongside the top users and top categories for that date range. The user shown can be changed.
+
===Scripts===
  
 +
Lists the script, as seen by an operator, for a user specified topic and highlights the rows where there is a change of script.
  
 +
[[File:reports22.png]]
  
Summary of Markers Logged
+
===Audit History===
 
 
  
 +
Report on how often results have been overridden by the operators. This report allows you to see instances where the priority has been overridden and the reason given. Also any time a tenant responsible repair has been logged as re-chargeable.
  
Lists a summary of all or user specified markers logged within a user specified date range alongside the top markers logged for that date range.
+
[[File:auditreport1.png]]
  
 +
[[File:auditreport2.png]]
  
 +
==By Scriptpath Reports==
  
Summary of Priorities Logged
+
These reports are designed to report System and Master script references with a Script Set name of ‘System’ and ‘Master’ respectively. Rows will appear in the following sequence:
 +
*System scripts,
 +
*Master scripts then
 +
*Set level Scripts alphabetically
  
 +
===Markers in Scripts by Scriptpath===
  
 +
Lists all or user specified markers and where they can be found within a script.
  
Lists a summary of all or user specified priorities logged within a user specified date range alongside the top priorities logged for that date range.
+
[[File:reports17.png]]
  
 +
===Messages in Scripts by Scriptpath===
  
 +
Lists all or user specified messages and where they can be found within a script.
  
Summary of Services Logged
+
[[File:reports18.png]]
  
 +
===Priorities in Scripts by Scriptpath===
  
 +
Lists all or user specified priorities and where they can be found within a script.
  
  Lists a summary of all or user specified services logged within a user specified date range alongside the top services logged for that date range.
+
  The Priorities report only displays and filters by priority description and does not allow filtering by code.
 
  
 +
[[File:reports19.png]]
  
Summary of Tasks Logged
+
===Services in Scripts by Scriptpath===
  
 +
Lists all or user specified services and where they can be found within a script.
  
 +
[[File:reports20.png]]
  
Lists a summary of all or user specified tasks logged within a user specified date range alongside the top tasks logged for that date range.
+
===Tasks in Scripts by Scriptpath===
  
 +
Lists all or user specified tasks and where they can be found within a script.
  
 +
[[File:reports21.png]]
  
User Information
+
==View Report==
 +
After entering all required parameters click '''View Report''' to view the report with the new parameters.
  
 +
===The Menu Pane===
  
 +
*'''Refresh Report''' – click on the [[File:reports26.png]] icon to re-load data into the Report
  
  Shows all or user specified users of the Keyfax system alongside the number of active/inactive users and last five active users.
+
*'''Zoom Control''' – click on the zoom drop down list and select a viewing level.
 
   
 
   
 +
The viewing size of the Report can be enlarged or reduced by selecting from the drop down list in the zoom control. This does not affect the size when printing or saving the Reports to file.
  
 +
*'''Export''' – select the [[File:reports25.png]] icon to save the Report in a required format
  
Markers in Scripts by Scriptpath
+
===Parameters===
 
 
 
 
 
 
Lists all or user specified markers and where they can be found within a script.
 
 
 
 
 
 
 
Messages in Scripts by Scriptpath
 
 
 
 
 
 
 
Lists all or user specified messages and where they can be found within a script.
 
 
 
 
 
 
 
Priorities in Scripts by Scriptpath
 
 
 
 
 
 
 
Lists all or user specified priorities and where they can be found within a script.
 
 
 
 
 
 
 
Services in Scripts by Scriptpath
 
 
 
 
 
 
 
Lists all or user specified services and where they can be found within a script.
 
 
 
 
 
 
 
Tasks in Scripts by Scriptpath
 
 
 
 
 
 
 
Lists all or user specified tasks and where they can be found within a script.
 
 
 
 
 
 
 
Scripts
 
 
 
 
 
 
 
Lists the script, as seen by an operator, for a user specified topic and highlights the rows where there is a change of script.
 
 
 
Audit History
 
 
 
 
 
 
 
 
 
 
 
Report on how often results have been overridden by the operators. This report allows you to see instances where the priority has been overridden and the reason given. Also any time a tenant responsible repair has been logged as re-chargeable.
 
 
 
Parameters  
 
  
 
Where a Report requires parameters to be set, they will be displayed in the Report Menu.
 
Where a Report requires parameters to be set, they will be displayed in the Report Menu.
  
Example:  
+
'''Example''': [[File:158.png]]
  
In this example you can select the ‘from’ date and the ‘to’ date; these will be defaulted to the previous calendar month. There are also other parameters that can be user defined and these include (but are not limited to) Script Set, User ID and Descriptions
+
In this example you can select the ‘from’ date and the ‘to’ date; these will be defaulted to the previous calendar month. There are also other parameters that can be user defined and these include (but are not limited to) Script Set, User ID and Descriptions.
 
View Report - after entering all required parameters click  to view the Report with the new parameters.
 
  
The Menu Pane -
+
[[File:159.png]]
  
 +
===Changing Sorting order===
  
+
Some Reports are designed so that data can be sorted by different elements.
  
Refresh Report – click on the  icon to re-load data into the Report
+
Where this is available an [[File:resort.png]] icon will appear in the column header. By clicking on the heading, the Report will re-sort itself by that column, alternating between alphabetical and reverse-alphabetical each time the header is clicked. The column header used for sorting will then contain up or down arrows. The example below shows the heading ‘Category’ being placed in a Sorting Order. You can sort by multiple columns by using the 'SHIFT' key and clicking additional icons.
 
 
Zoom Control – click on the Zoom drop down list  and select a viewing level.
 
 
 
 
 
 
 
 
 
 
NOTE
 
 
 
The viewing size of the Report can be enlarged or reduced by selecting from the drop down list in the zoom control. This does not affect the size when printing or saving the Reports to file.
 
 
 
Export – select the icon to save the Report in a required format
 
 
 
 
 
 
 
Viewing Reports
 
 
 
The Report results are displayed in the Viewing Pane.
 
 
 
 
 
Changing Sorting order
 
 
 
Some Reports are designed so that data can be sorted by different elements.
 
  
Where this is available an icon  will appear in the column header. By clicking on the heading, the Report will re-sort itself by that column, alternating between alphabetical and reverse-alphabetical each time the header is clicked. The column header used for sorting will then contain  or  The example below shows the heading ‘Category’ being placed in a Sorting Order. You can sort by multiple columns by using the 'SHIFT' key and clicking additional icons.
+
[[File:165.png]]

Latest revision as of 11:27, 19 March 2020

Dashboard

Shows a summary of the system on a user specified day together with a summary of the system for the previous six months from the day the report is run.

Reports2.png


Filtering Options

There are various options available in the reports that will allow you to refine your searches. Which fields are available will depend on the report you have chosen but the filtering options are as follows:


Code: Enter the code you are looking for to limit the results to only show this code. You can also use %value% to find codes that are 'like' the value you have entered. For example %003%.

Filters1.png


Description:

Enter a description you wish to search for. You can also use %value% to find descriptions that are 'like' the value you have entered. For example %excavate%

Filters3.png


Script Set:

Enter the script set you wish to search for. You can search for 'System' and 'Master' as well as the user created script sets. The %value% functionality will also work.

Filters2.png


From and To

Allows you to specify a date range to limit your search to.


Standard Reports

Reports1.png


The following is a list all standard reports along with a brief description. Click on the report you are interested in to jump to the relevant section on this page.

Reports23.png

List of Markers

Lists all or user specified markers in a script type. The user can change whether to show markers that are referenced in scripts or not.

Reports3.png

List of Messages

Lists all or user specified messages in a script type. The user can change whether to show messages that are referenced in scripts or not.

Reports4.png

List of Priorities

Lists all or user specified priorities in a script type. The user can change whether to show priorities that are referenced in scripts or not.

Reports5.png

List of Services

Lists all or user specified services in a script type. The user can change whether to show services that are referenced in scripts or not.

Reports6.png

List of Tasks

Lists all or user specified tasks in a script type. The user can change whether to show tasks that are referenced in scripts or not.

Reports7.png

Feedback

Lists all the feedback received within a user specified date range.

Reports8.png

Order History

Shows the order history for a user specified date range, including the number of users per month.

Reports9.png

Summary by Category and Topic

Lists a summary of the usage by category and topic for a user specified date range alongside the top categories for that date range.

Reports10.png

Summary by User and Category

Lists a summary of the usage by user and category for a user specified date range alongside the top users and top categories for that date range. The user shown can be changed.

Reports11.png

Summary of Markers Logged

Lists a summary of all or user specified markers logged within a user specified date range alongside the top markers logged for that date range.

Reports12.png

Summary of Priorities Logged

Lists a summary of all or user specified priorities logged within a user specified date range alongside the top priorities logged for that date range.

Reports13.png

Summary of Services Logged

Lists a summary of all or user specified services logged within a user specified date range alongside the top services logged for that date range.

Reports14.png

Summary of Tasks Logged

Lists a summary of all or user specified tasks logged within a user specified date range alongside the top tasks logged for that date range.

Reports15.png

User Information

Shows all or user specified users of the Keyfax system alongside the number of active/inactive users and last five active users.

Reports16.png

Scripts

Lists the script, as seen by an operator, for a user specified topic and highlights the rows where there is a change of script.

Reports22.png

Audit History

Report on how often results have been overridden by the operators. This report allows you to see instances where the priority has been overridden and the reason given. Also any time a tenant responsible repair has been logged as re-chargeable.

Auditreport1.png

Auditreport2.png

By Scriptpath Reports

These reports are designed to report System and Master script references with a Script Set name of ‘System’ and ‘Master’ respectively. Rows will appear in the following sequence:

  • System scripts,
  • Master scripts then
  • Set level Scripts alphabetically

Markers in Scripts by Scriptpath

Lists all or user specified markers and where they can be found within a script.

Reports17.png

Messages in Scripts by Scriptpath

Lists all or user specified messages and where they can be found within a script.

Reports18.png

Priorities in Scripts by Scriptpath

Lists all or user specified priorities and where they can be found within a script.

The Priorities report only displays and filters by priority description and does not allow filtering by code.

Reports19.png

Services in Scripts by Scriptpath

Lists all or user specified services and where they can be found within a script.

Reports20.png

Tasks in Scripts by Scriptpath

Lists all or user specified tasks and where they can be found within a script.

Reports21.png

View Report

After entering all required parameters click View Report to view the report with the new parameters.

The Menu Pane

  • Refresh Report – click on the Reports26.png icon to re-load data into the Report
  • Zoom Control – click on the zoom drop down list and select a viewing level.
The viewing size of the Report can be enlarged or reduced by selecting from the drop down list in the zoom control. This does not affect the size when printing or saving the Reports to file.
  • Export – select the Reports25.png icon to save the Report in a required format

Parameters

Where a Report requires parameters to be set, they will be displayed in the Report Menu.

Example: 158.png

In this example you can select the ‘from’ date and the ‘to’ date; these will be defaulted to the previous calendar month. There are also other parameters that can be user defined and these include (but are not limited to) Script Set, User ID and Descriptions.

159.png

Changing Sorting order

Some Reports are designed so that data can be sorted by different elements.

Where this is available an Resort.png icon will appear in the column header. By clicking on the heading, the Report will re-sort itself by that column, alternating between alphabetical and reverse-alphabetical each time the header is clicked. The column header used for sorting will then contain up or down arrows. The example below shows the heading ‘Category’ being placed in a Sorting Order. You can sort by multiple columns by using the 'SHIFT' key and clicking additional icons.

165.png