Late Job Report Templates

CygNet Measurement > Using CygNet Measurement > Reports > Report Template Files > Late Job

Late Job Report Templates

Note: This report is provided for use with CygNet Dispatch. For more information about the CygNet Dispatch product, contact your Account Manager or CygNet Sales.

Late Job report templates contain a ReportDefinition page and a ReportSheet page, that together describe the reports you can produce. CygNet provides a sample report template file LateJobTemplate.xlsx for reference. It is stored in the CygNet\Services\FMS\ReportTemplates\Samples folder on your host server.

The ReportDefinition sheet includes the following parameters to describe the type of report to build.

ReportParameters
Worksheet

The ReportSheet sheet includes the sections and fields describing the specific format of the report to build. Valid tokens will be replaced by the values they represent. You may also include additional information you wish to see in the report.

See Reports: Late Job for information about the report command.

See Late Job Report Definition Files for information about the report definition.

Displaying Additional (Non-Token) Values

You can enter additional (non-token) elements such as logos, labels, or text into reports. Elements that are not valid token values will be displayed as entered.

Note: This means that tokens with typographical errors, therefore not "valid" tokens, will also be displayed as entered.

Example

[NullToken] is a valid token. If you use [Null] (not a valid token) instead of [NullToken], the value will be displayed as "[Null]" instead of displaying the null value desired, since [Null] is not a valid token.

[Null]

Configuring the ReportDefinition

The ReportDefinition uses parameters to describe the type of report for the service to build and the values that appear in the cells. The following parameters determine the described characteristics of your report.

Late Job Report: ReportParameters

Report parameters, which appear between #ReportParameters# and #End#, can be defined by the following values.

Parameter	Description	Value
ReportName	The value defined in this cell will be used for the report name, as it will appear in drop-down menus in FMS Explorer and CygNet Explorer. See Using the Reports Control and Scheduling FMS Command Tasks in the MSS for more information.	Enter a value to be used for the report name. Example Late Job Report
CommandName	The value defined in this cell will be used by the service to determine which specific report command type to execute. See FMSClient Methods in the Scripting section for more information.	Enter a value to specify the report command name. Example LATEJOB Note: Maximum of 7 characters; letters or numbers only, no spaces.

Parameter

Description

Value

ReportName

The value defined in this cell will be used for the report name, as it will appear in drop-down menus in FMS Explorer and CygNet Explorer.

See Using the Reports Control and Scheduling FMS Command Tasks in the MSS for more information.

Enter a value to be used for the report name.

Example

Late Job Report

CommandName

The value defined in this cell will be used by the service to determine which specific report command type to execute.

See FMSClient Methods in the Scripting section for more information.

Enter a value to specify the report command name.

Example

LATEJOB

Note: Maximum of 7 characters; letters or numbers only, no spaces.

Late Job Report: Worksheet Parameters

Worksheet parameters, which appear between #Worksheet# and #End#, can be defined by the following values.

Parameter	Description	Value
ReportType	The value defined in this cell will be used to represent the standard FMS report type you are configuring.	Enter a value to be used to indicate the type of the report. Example Late Job
NullToken	The value defined in this cell will be used to represent null values in your report.	Enter a value to be used to indicate a "null value" cell in the report. Example -
PageBreaks	The value defined in this cell will be used to specify whether or not to use page breaks in your report. If used, will force a page break after each station.	Enter a value to indicate whether or not to insert page breaks. Options are Yes or No. Default value is Yes.
AllowedJobTypes	The value defined in this cell will be used to specify the job type results to display in the report.	Enter one of the following options. Auto-calibration Calibration [values as entered in the job .csv file] Default value is Calibration.
NodeSortOrder	The value defined in this cell will be used to specify the order in which to display Node results in the report.	Enter one of the following options. Name ascending Description ascending Name descending Description descending Default value is Name ascending. This parameter is optional.
RptStDate	Note: If you use this parameter in your report template, the RptStDate parameter will no longer appear for configuration in FMS Explorer or CygNet Explorer. See Late Job Report Definitions (FMS Explorer) or Reports: Late Job (CygNet Explorer) for more information.	If used, enter a valid start date value for the report. RptStDate and RptEndDate must be the same configuration parameter type. Notes: The report will only include records that exist entirely within the specified date range. The command request is made in Local time (L), and the report displays data in Local time (L). See Selecting Date and Time for more information. This parameter is optional.
RptEndDate	Note: If you use this parameter in your report template, the RptEndDate parameter will no longer appear for configuration in FMS Explorer or CygNet Explorer. See Late Job Report Definitions (FMS Explorer) or Reports: Late Job (CygNet Explorer) for more information.	If used, enter a valid end date value for the report. RptStDate and RptEndDate must be the same configuration parameter type. Note: The report will only include records that exist entirely within the specified date range. The command request is made in Local time (L), and the report displays data in Local time (L). See Selecting Date and Time for more information. This parameter is optional.

Configuring the ReportSheet

The ReportSheet uses tokens to describe the format of the report you want to run. The following tokens determine the report content, and will retrieve the corresponding values for display in your report.

Note: Enter report tokens carefully, as the tokens are case sensitive. Typographical errors (therefore not "valid" tokens) will be handled as "additional values" and displayed as entered; the non-token value will appear in your report instead of the actual value(s) the correctly entered token would have retrieved. See Displaying Additional (Non-Token) Values above for more information.

Late Job Report: Header Tokens

Late Job report headers, which appear above #EndReportHdr#, can be described by the following tokens.

Token	Description
[BeginDateTime]	The start date, in Contract day (C), of the requested time range for the report
[EndDateTime]	The end date, in Contract day (C), of the requested time range for the report
[GeneratedDateTime]	The time the report was generated, in Local time (L)
[TotalDeviceCount]	The total number of devices in the report

Late Job Report: SubReport Header Tokens

Late Job report subreport headers, which appear between #SubSection# SubReportHeader and #End#, can be described by the following tokens.

Token	Description
[=]	When used as the first three characters, turns the cell into a formula
[CurrentDeviceCount]	The index of the device being displayed
[NodeContractHour]	The contract hour of the Node
[NodeDaysOfData]	The number of days for which the data source of the Node will retain data
[NodeDesc]	The Node description
[NodeId]	The Node ID
[NodeInstallDateTime]	The install date/time for the Node, in Device time (D)
[NodeName]	The Node name
[NodePollingFacilityId]	The polling facility ID of the Node
[NodePollingFacilityTag]	The polling facility tag of the Node
[NodePollingSiteService]	The polling Site.Service of the Node
[NodeReportingFacilityId]	The reporting facility ID of the Node
[NodeReportingSiteService]	The reporting Site.Service of the Node
[NodeSecurityApp]	The security application of the Node
[NodeSortPriority]	The sort priority of the Node
[NodeTimezone]	The time zone configured for the Node
[NodeTimezoneUsingDst]	The daylight saving time status of the Node
[NodeType]	The Node type
[PollingFac_Attr0] - [PollingFac_Attr29]	The polling facility indexed text attributes 0 through 29 (each a separate token)
[PollingFac_Category]	The polling facility category
[PollingFac_Desc]	The polling facility description
[PollingFac_Info0]	The polling facility info attribute 0 Default attribute name is Facility Location
[PollingFac_Info1]	The polling facility info attribute 1 Default attribute name is Facility Contact
[PollingFac_IsActive]	The polling facility active flag
[PollingFac_Table0] - [PollingFac_Table29]	The polling facility indexed table attributes 0 through 29 (each a separate token)
[PollingFac_Type]	The polling facility type
[PollingFac_YesNo0] - [PollingFac_YesNo19]	The polling facility indexed Yes/No attributes 0 through 19 (each a separate token)
[RecordSpan]	The number of minutes in the record span
[RowNumber]	The current row number
[TotalDeviceCount]	The total number of devices in the report

Late Job Report: Data Table Header Tokens

Late Job report data table headers, which appear between #SubSection# DataTableHeader and #End#, can be described by the text you enter. Type the desired text into the cell, and format it as desired. Data Table Headers can also be described by the following tokens.

Note: In PDF format, reports containing tables that span multiple pages will repeat the data table header on each contiguous page.

Token	Description
[=]	When used as the first three characters, turns the cell into a formula
[NodeContractHour]	The contract hour of the Node
[NodeDaysOfData]	The number of days for which the data source of the Node will retain data
[NodeDesc]	The Node description
[NodeId]	The Node ID
[NodeInstallDateTime]	The install date/time for the Node, in Device time (D)
[NodeName]	The Node name
[NodePollingFacilityId]	The polling facility ID of the Node
[NodePollingFacilityTag]	The polling facility tag of the Node
[NodePollingSiteService]	The polling Site.Service of the Node
[NodeReportingFacilityId]	The reporting facility ID of the Node
[NodeReportingSiteService]	The reporting Site.Service of the Node
[NodeSecurityApp]	The security application of the Node
[NodeSortPriority]	The sort priority of the Node
[NodeTimezone]	The time zone configured for the Node
[NodeTimezoneUsingDst]	The daylight saving time status of the Node
[NodeType]	The Node type
[PollingFac_Attr0] - [PollingFac_Attr29]	The polling facility indexed text attributes 0 through 29 (each a separate token)
[PollingFac_Category]	The polling facility category
[PollingFac_Desc]	The polling facility description
[PollingFac_Info0]	The polling facility info attribute 0 Default attribute name is Facility Location
[PollingFac_Info1]	The polling facility info attribute 1 Default attribute name is Facility Contact
[PollingFac_IsActive]	The polling facility active flag
[PollingFac_Table0] - [PollingFac_Table29]	The polling facility indexed table attributes 0 through 29 (each a separate token)
[PollingFac_Type]	The polling facility type
[PollingFac_YesNo0] - [PollingFac_YesNo19]	The polling facility indexed Yes/No attributes 0 through 19 (each a separate token)
[RecordSpan]	The number of minutes in the record span
[RowNumber]	The current row number

Late Job Report: Data Table Tokens

Late Job report data table parameters, which appear between #SubSection# DataTable (1 or 2) and #End#, can be described by the following tokens.

Token	Description
Job Tokens
[JobName]	The job name
[JobType]	The job type
[BeginDueDate]	The date the job is available to be completed
[EndDueDate]	The date the job is required to be complete
[NumDaysLate]	The number of days the job is late
[Assignees]	The user(s) assigned to the job
General Tokens
[=]	When used as the first three characters, turns the cell into a formula
[CurrentDeviceCount]	The index of the device being displayed
[NodeContractHour]	The contract hour of the Node
[NodeDaysOfData]	The number of days for which the data source of the Node will retain data
[NodeDesc]	The Node description
[NodeId]	The Node ID
[NodeInstallDateTime]	The install date/time for the Node, in Device time (D)
[NodeName]	The Node name
[NodePollingFacilityId]	The polling facility ID of the Node
[NodePollingFacilityTag]	The polling facility tag of the Node
[NodePollingSiteService]	The polling Site.Service of the Node
[NodeReportingFacilityId]	The reporting facility ID of the Node
[NodeReportingSiteService]	The reporting Site.Service of the Node
[NodeSecurityApp]	The security application of the Node
[NodeSortPriority]	The sort priority of the Node
[NodeTimezone]	The time zone configured for the Node
[NodeTimezoneUsingDst]	The daylight saving time status of the Node
[NodeType]	The Node type
[PollingFac_Attr0] - [PollingFac_Attr29]	The polling facility indexed text attributes 0 through 29 (each a separate token)
[PollingFac_Category]	The polling facility category
[PollingFac_Desc]	The polling facility description
[PollingFac_Info0]	The polling facility info attribute 0 Default attribute name is Facility Location
[PollingFac_Info1]	The polling facility info attribute 1 Default attribute name is Facility Contact
[PollingFac_IsActive]	The polling facility active flag
[PollingFac_Table0] - [PollingFac_Table29]	The polling facility indexed table attributes 0 through 29 (each a separate token)
[PollingFac_Type]	The polling facility type
[PollingFac_YesNo0] - [PollingFac_YesNo19]	The polling facility indexed Yes/No attributes 0 through 19 (each a separate token)
[RecordSpan]	The number of minutes in the record span
[RowNumber]	The current row number
[TotalDeviceCount]	The total number of devices in the report

Late Job Report: SubReport Footer Tokens

Late Job report subreport footers, which appear between #SubSection# SubReportFooter and #End#, can be described by the following tokens.

Token	Description
[=]	When used as the first three characters, turns the cell into a formula
[CurrentDeviceCount]	The index of the device being displayed
[NodeContractHour]	The contract hour of the Node
[NodeDaysOfData]	The number of days for which the data source of the Node will retain data
[NodeDesc]	The Node description
[NodeId]	The Node ID
[NodeInstallDateTime]	The install date/time for the Node, in Device time (D)
[NodeName]	The Node name
[NodePollingFacilityId]	The polling facility ID of the Node
[NodePollingFacilityTag]	The polling facility tag of the Node
[NodePollingSiteService]	The polling Site.Service of the Node
[NodeReportingFacilityId]	The reporting facility ID of the Node
[NodeReportingSiteService]	The reporting Site.Service of the Node
[NodeSecurityApp]	The security application of the Node
[NodeSortPriority]	The sort priority of the Node
[NodeTimezone]	The time zone configured for the Node
[NodeTimezoneUsingDst]	The daylight saving time status of the Node
[NodeType]	The Node type
[PollingFac_Attr0] - [PollingFac_Attr29]	The polling facility indexed text attributes 0 through 29 (each a separate token)
[PollingFac_Category]	The polling facility category
[PollingFac_Desc]	The polling facility description
[PollingFac_Info0]	The polling facility info attribute 0 Default attribute name is Facility Location
[PollingFac_Info1]	The polling facility info attribute 1 Default attribute name is Facility Contact
[PollingFac_IsActive]	The polling facility active flag
[PollingFac_Table0] - [PollingFac_Table29]	The polling facility indexed table attributes 0 through 29 (each a separate token)
[PollingFac_Type]	The polling facility type
[PollingFac_YesNo0] - [PollingFac_YesNo19]	The polling facility indexed Yes/No attributes 0 through 19 (each a separate token)
[RecordSpan]	The number of minutes in the record span
[RowNumber]	The current row number
[TotalDeviceCount]	The total number of devices in the report

Late Job Report: Report Footer

Late Job report footers, which appear between #SubSection# ReportFooter and #End#, can be described by the text you enter. Type the desired text into the cell, and format it as desired.