Skip to main content
insightsoftware Documentation insightsoftware Documentation
{%article.title%}
Published:
Was this article helpful?
0 out of 0 found this helpful

ADDSHEET (Col A)

        Mandatory in combination with another keyword/parameter = mandatory in combination with another parameter                                                                                                                                                

Parameter

Mandatory/Optional

Value (example)

Comment

FORMS

REPORT

ADDSHEET

Mandatory in combination with another keyword/parameter

Mandatory in combination with another keyword/parameter

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.

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.

ADDSHEET_ColA_2

Below is an example of a generated document with sheets for three customer groups (10, 11, and 12):

ADDSHEET_ColA

Published:

ADDSHEET (Col A)

        Mandatory in combination with another keyword/parameter = mandatory in combination with another parameter                                                                                                                                                

Parameter

Mandatory/Optional

Value (example)

Comment

FORMS

REPORT

ADDSHEET

Mandatory in combination with another keyword/parameter

Mandatory in combination with another keyword/parameter

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.

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.

ADDSHEET_ColA_2

Below is an example of a generated document with sheets for three customer groups (10, 11, and 12):

ADDSHEET_ColA

For an optimal Community experience, Please view on Desktop
Powered by Zendesk