SPKEY
= mandatory in combination with another parameter
Parameter | Mandatory/Optional | Value (example) | Occurrence in row 1 | Comment | |
|---|---|---|---|---|---|
FORMS | REPORT | ||||
SPKEY |
| n/a | EVEN | x number of times | Column in which the spread key should be entered. Can occur several times in row 1. Mandatory in combination with SPVAL and need to be linked to a SPGROUP. |
SPKEY is a FORM specific parameter, which is mandatory in combination with SPGROUP and SPVAL (SPLIM is optional). In the SPKEY column(s), the end-user should enter a spread key which defines how the spread value (SPVAL) should be allocated in the CVAL columns. In the SPKEY column, the end-user can enter a predefined (case-sensitive) spreadkey in the cell or click on the icon to view existing spreadkeys and select one from the list.
There can be several SPKEY parameters in row 1, however, each SPKEY needs to be connected to different spread groups (SPGROUP). The spread group defines in which columns the spread value (SPVAL) should be allocated and the spread key (SPKEY) defines how the spread value should be allocated in these columns.
Mandatory parameters for SPKEY:
In the SPKEY column, an icon will automatically appear in all DATA rows. The end-user can click on the icon to view and select from existing spreadkeys.
The first section (the gray chart) shows the current spreadkey for the selected data row. The sections below show the predefined spread key that can be selected:
