Excel Template File

Overview

Each Excel Template report is defined by a definition file that specifies how the report should be created. Each template file must contain a select sheet, a "Main Sheet" and one or more "Definition sheets".

• Select Sheet

This sheet contains local select definitions available only to the current report request.

• Main Sheet

This sheet contains a list of definition sheets to execute. The main sheet allows you to specify a selection that applies to the definition sheet and also a banding value. Specifying a banding field will cause "Sheet Level" banding to be applied.

• Definition Sheets

By default, the spreadsheet contains three sheets that define the standard reporting frequencies: Daily, Weekly and Monthly.

The name of the sheet must match the report frequency that is passed via vsreload:

/VSJOBS/JVSRELOAD task Load=N Print=Daily

Additional custom frequency sheets can be added, for example BoardReports, Finance, Tuesday etc.

Custom frequencies are executed via a call to JVSRELOAD

/VSJOBS/JVSRELOAD task Load=N Print=BoardReports

Document Distribution Overview

Note: Whenever a new frequency sheet is added, a corresponding change must be made to the vReportFrequencies variable in the main Vital Signs configuration file.

Select Sheet

This sheet contains the names and definitions of all global selections that have been defined. Selections defined in the select sheet of the DocumentDistribution file are global and are accessible to all report requests. A selection consists of one or more steps that share the same selection name.