ADDSHEET (Col A)
= mandatory in combination with another parameter
Parameter | Mandatory/Optional | Value (example) | Comment | |
|---|---|---|---|---|
FORMS | REPORT | |||
ADDSHEET |
|
| n/a | Mandatory in combination with the ADDSHEET parameter in PARAM. In the ADDSHEET row in the template, the object value will be automatically inserted when the document is generated. |
ADDSHEET in column A must be used in combination with the ADDSHEET parameter in the PARAM sheet. These parameters are used if the end-user should be able to create a new worksheet for each selected object value. If these parameters are not used, then the end-user will only create ONE worksheet for all selected object values together.
Important: 
Invisible: New for v23.4 There are new validation rules that apply when designing a template in template version one. With this new validation process, you are unable to save templates when the value for ADSHEET (Col A) is empty or duplicated.
When the ADDSHEET parameter in PARAM is specified with a value (an object), then ADDSHEET needs to be added in column A. The program will automatically insert the object value and object value description in the ADDSHEET row in the template when the document is generated.
If the documents contains several sections, like different reports in the same template, then the ADDSHEET parameter in column A can only be specified in one section.
Template Worksheet
In the Template Worksheet:
Column A = ADDSHEET
Column C = The object value will automatically be inserted when the document is generated.
Column D = The object value description will automatically be inserted when the document is generated.
The ADDSHEET row should be defined with ROWTYPE = DESIGN (the row will be hidden when document is generated). The inserted values in column C and D can then be linked to the document header.
Below is an example of a generated document with sheets for three customer groups (10, 11, and 12):
