Downloadable Custom Report Layouts

Patriot offers the below customised report layouts for download. See Customising Report Layouts for more information on creating, editing, and importing customised report layouts.

Australian Standard AS2201.2

Download: Australian Standards AS2201.2 Operator Response Extended Report.rdlc

Report Type: Operator Response Extended

This variation on the Operator Response Extended report generates the required compliance statistics for AS2201.2. It includes an exceptions section which lists the activations which fail to meet the standards.

The default category definitions are based on action plan priority:

Category Action Plan Priorities
High Priority 1
Asset Threatening 2
Subsistence 3
Low Priority 4+

These category definitions can be changed to suit your system set up by altering the table filters in the report definition file.

User Extended Report

Download: User Extended Report.rdlc

Report Type: User Report

This is a user report which gives more details than the standard User Report.

Additional information included in the Extended report:

False Alarm Summary Report

Download: False Alarm Summary Report.rdlc

Report Type: FalseAnalysis

This is a False Alarm Analysis Report which contains only the summary information.

Unlike the standard False Alarm Analysis Report, it does not show a list of Policed Alarms.

Reason Analysis Report With Completion Times

Download: Reason Analysis Report With Completion times.rdlc

Report Type: ReasonAnalysis

This is a Reason Analysis Report which contains extended summary information, including percentages of alarms responded to or completed within certain time limits.

This report will only work if your Patriot licence includes the UK module.

Reason Analysis Summary Report

Download: Reason Analysis Summary Report.rdlc

Report Type: ReasonAnalysis

This is a Reason Analysis Report used in previous version of Patriot 6 which includes the summary table only - no activation listing is present.

Offline Report

Download: Offline Report.rdlc

Report Type: GenericReport

This reports lists signals received from offline (Non-Monitored) clients. Because this report is of GenericReport type it must be used in combination with an advanced search query: 

SELECT s.RecDateTime, s.Notes, s.CallerIDNo, s.RawData
FROM PatriotEntities.Signal AS s
WHERE s.Type_No = 65508 AND s.Client_No = 'SYST000101'
AND s.RecDateTime >= <ds> AND s.RecDateTime <= <de>
AND s.Notes >= <cns> AND s.Notes <= <cne>

Incident X Report with Dealer Branding

Download: Incident X With Dealer Image Report.rdlc

Report Type: IncidentReportX, IncidentReportXByUser

This is an Incident Report which contains a dealer logo along the top of the report, allowing each dealer/installer to have a distinct reporting style.

Incident Report without Client Number

Download: Incident Report without Client Number.rdlc

Report Type: IncidentReport

This is an Incident Report used in previous versions of Patriot 6 which does not show any Client Numbers on the report.

Incident Report without Zone/User Number

Download: Incident Report without Zone User Number.rdlc

Report Type: IncidentReport

This is an Incident Report used in previous versions of Patriot 6 which does not show the Zone/User number column on the report.

Incident X Report without Zone/User Number

Download: Incident X Report without Zone User Number.rdlc

Report Type: IncidentXReport

This is an Incident X Report used in previous versions of Patriot 6 which does not show the Zone/User number column on the report.

Incident X Report ADSW Variation

Download: Incident X Report ADSW Variation.rdlc

Download: Incident X Sub Report ADSW Variation.rdlc

Report Type: IncidentXReport and IncidentXByUserReport

This is an Incident X by User Report comparable to that produced by the ADSW software package.

Incident X List Report ADSW Variation (no page breaks)

Download: Incident X Report ADSW Variation NBR.rdlc

Download: Incident X Sub Report ADSW Variation.rdlc

Report Type: IncidentXReport and IncidentXByUserReport

This is an Incident X by User Report comparable to that produced by the ADSW software package. List format without page breaks between clients.

Operator Response Report (UL)

Download: OperatorResponseReportUL.rdlc

Report Type: OperatorResponseExtendedX

This is a Response Report which gives a summary of operator and patrol responses for a given date range. It separates data according to Client Grouping 5, which is assigned on the Report tab of clients.

Log Analysis Reports

These are shortened versions of the standard Log Analysis Report. Useful for a quick summary of the volume of signals received per client over a period of time.

Log Analysis Report (Signal Totals Only):

Report that shows a list containing the following data:

Client Number Client Name Total signal count

Report Type: LogAnalysisReport

Download: Log Analysis Report (Totals Only)


Download: Log Analysis Report Excluding Testmode Signals (Totals Only)


Log Analysis Report (With Action Plans):

Report that shows a list containing the following data:

Client Number Client Name Total signal count per action plan

Report Type: LogAnalysisReport

Download: Log Analysis Report (With Action Plans)

Download: Log Analysis Report Excluding Testmode Signals (With Action Plans)

Walk Test Report

After a walk test through a site, this report will show:

Example of a walk test report

Report Type: WalkTestReport

Download: Walk Test Report.rdlc

Download: Walk Test Sub Report.rdlc

UL Client Statistics Report

For Patriot to be UL classified the Client Statistics Report must be imported into Patriot.

There are 2 reports that need to be setup. Both of these are based on the Generic Report Format.

  1. Client Statistics Totals Report

    Create a new query using the following:

    USING Microsoft.Samples.Entity;

FUNCTION ActiveCount() AS
(
    SELECT value COUNT(mem.client_no)
    FROM PatriotEntities.Memalarm AS mem
    WHERE mem.UNS_MON <> 0
)

FUNCTION InactiveCount() AS
(
    SELECT value COUNT(mem.client_no)
    FROM PatriotEntities.Memalarm AS mem
    WHERE mem.UNS_MON = 0
    AND mem.CurrentWorkgroup = 0
)

SELECT ActiveCount() AS ActiveClients,
       InactiveCount() AS InactiveClients
FROM PatriotEntities.MasterSysSettings

    Then create a new report type, of type Generic Report. Use the Client StatisticsTotal.rdlc format.

  2. Client Statistics By Receiver Report

    Create a new query using the following:

    USING Microsoft.Samples.Entity;

FUNCTION ActiveCount(portid string) AS
(
    SELECT value COUNT(mem.client_no)
    FROM PatriotEntities.Memalarm AS mem
    WHERE mem.UNS_MON <> 0
    AND mem.portid = portid
)

FUNCTION InactiveCount(portid string) AS
(
    SELECT value COUNT(mem.client_no)
    FROM PatriotEntities.Memalarm AS mem
    WHERE mem.UNS_MON = 0
    AND mem.CurrentWorkgroup = 0
    AND mem.portid = portid
)

SELECT mem.portid, ActiveCount(mem.portid) AS ActiveClients,
       InactiveCount(mem.portid) AS InactiveClients
FROM PatriotEntities.Memalarm AS mem
GROUP BY mem.portid

    Then create a new report type, of type Generic Report. Use the Client Statistics By Receiver.rdlc format.

Billing Invoice Report

Download: Billing Charge Report.rdlc

Report Type: BillingServices, BillingServicesByUser, BillingActivations, BillingActivationsByUser, BillingWorkOrders, BillingWorkOrdersByUser

This is an invoice summary report. It is meant to server an appendage to the formatted invoice produced by your integrated accounting software package. For example if you are billing a dealer for monitoring service charges, and that dealer has a large number of clients, you can send the dealer a one line invoice along with this report which shows the client breakdown of charges.

This report will only work if your Patriot licence includes a Billing integration module

Scan Code Exception Report

Download: Scan Code Report.rdlc

Report Type: GenericReport

This report can be used with the Patrol Response Module to list all the scan codes which have not been scanned the number of times specified in the scan codes frequency setting. This report must be configured as a preset report, scheduled daily. 

SELECT scanZone.Client_No, scanZone.Zone_no, scanZone.zone_area, scanZone.ScanFrequency, scanZone.ScanCount
FROM (
  SELECT z.Client_No, z.Zone_no, z.zone_area, z.ScanFrequency,
  ANYELEMENT(SELECT VALUE COUNT(s.IDAuto) from PatriotEntities.Signal AS s
    WHERE s.client_no = z.client_no
    AND s.Zone_User = z.Zone_No
    AND s.ModuleNo = z.ModuleNo
    AND s.RecDateTime BETWEEN <ds> AND <de>
    AND s.Type_No = 65550) AS ScanCount
  FROM PatriotEntities.MZone AS z
  WHERE (CASE WHEN z.ScanFrequency IS NULL THEN 0 ELSE z.ScanFrequency END) > 0 
  AND z.scancode IS NOT NULL 
  ) as scanZone
WHERE scanZone.ScanFrequency > scanZone.ScanCount

Advanced Search Generic Report

This report can be used to improve the formatting of the advanced search report. See Reporting on searches for more details.

Download: Advanced Search Report.rdlc

Then create a new report of type Generic Report. Select this rdlc file for the report format. Next select this new report from System Settings -> System Wide settings -> Search Settings -> Advanced Search Report.

Dispatch Report (GraphQL)

Download: Dispatch Report.zip

Download: Dispatch Report With Full Dispatch Notes.zip

Report Type: GraphQL Report

This report can be used with any of Patriot's Dispatch modules to report on jobs dispatched to patrols. Because this is a GraphQL type report both the report data and the report layout are fully customisable. Please note that the default report layout contains placeholder company name and address text and logo image which you must customise with your own company details before importing the report

This report can be run as a Single Dispatch Job Report (which gives quick access when viewing a dispatch job in Patriot). To do this simply check "Single Dispatch Job Report" after importing the report. It can also be run as a preset report.

No Signals Report (GraphQL)

Report Type: GraphQL Report

Download: No Signals Received.zip

Clients that have not reported within the specified timeframe configured in the tests tab will be shown in this report. This report includes the last reported signal, last test signal and when the client should have reported.

Dispatch Request Report (GraphQL)

Download: Dispatch Request Report.zip

Download: Dispatch Request Report with signals.zip

Download: Dispatch Request Report With Full Dispatch Notes.zip

Report Type: GraphQL Report

This report is used with Patriot's Dispatch module to report on incoming dispatch job requests. Because this is a GraphQL type report both the report data and the report layout are fully customisable. Please note that the default report layout contains placeholder company name and address text and logo image which you must customise with your own company details before importing the report

This report can be run as a Single Dispatch Request Report (which gives quick access when viewing a dispatch request in Patriot). To do this simply check "Single Dispatch Job Report" after importing the report. Please note that this report shares the same report shortcut context with the Dispatch Job report (above) but it is designed to report on Dispatch Requests only. It can also be run as a full preset report.

Patrol Job Report (GraphQL)

Download: Patrol Job Report.zip

Report Type: GraphQL Report

This report requires the Patrol Response Module, and allows for reporting on completed Patrol Jobs. Because this is a GraphQL type report both the report data and the report layout are fully customisable. Please note that the default report layout contains placeholder company name and address text and logo image which you must customise with your own company details before importing the report

This report can be run as a Single Patrol Job Report (which gives quick access when viewing a Patrol job in Patriot). To do this simply check "Single Patrol Job Report" after importing the report. It can also be run as a preset report.

Work Order Report With Visits Report (GraphQL)

Download: Work Order Report With Visits.zip

Report Type: GraphQL Report

This report contains the standard Work Order details plus it also contains the list of visit information logged against the work order. Because this is a GraphQL type report both the report data and the report layout are fully customisable.

This report can be run as a Single Work Order Report (which gives quick access when viewing a Work Order in Patriot). To do this simply check "Single Work Order Report" after importing the report. It can also be run as a preset report on multiple Work Orders.

European Standard EN 50518: 2019

Download: EN 50518 Standard Report

Report Type: Operator Response Extended

This report provides a summary of the average response time for different action plans' activations and the percentage of activations that has been responded to within 30, 60, 90 and 180 seconds.

Client Report

Download: Client Report

Download: Client Report with extra maintenance info.

Report Type: GraphQL Report

Client Reports detail all information held on file for a client or range of clients including type, zone, user information, open & close times and holiday hours.

Related Pages