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

SPGROUP

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

Parameter

Mandatory/Optional

Value (example)

Comment

FORMS

REPORT

SPGROUP

Mandatory in combination with another keyword/parameter

n/a

1

Defines which CVAL columns belongs to which SPVAL/SPKEY/SPLIM columns in the template.

SPGROUP is a parameter that must be defined in column A, when the parameters SPVAL and SPKEY are used in row SPGROUP states which of the CVAL columns belongs to which SPVAL/SPKEY/SPLIM columns. Since the template can contain several spread value (SPVAL) and spreadkey (SPKEY) columns, SPGROUP needs to be stated to group CVAL columns together. The parameter should be defined as a unique number that connects all columns belonging to the same spread group (allocation).

A SPGROUP value should be defined for the following columns (if defined in row 1):

  • SPVAL
  • SPKEY
  • SPLIM
  • CVAL

A SPGROUP value is defined for the SPVAL/SPKEY and CVAL columns in the template. The template below contains two spread groups (1 and 2). When the end-user enters a value in column R (a total for week 201101) and then selects a spread key in column S, the program will allocate the total value to CVAL columns T-X, since these columns belong to SPGROUP 1.

The SPGROUP row should be defined with ROWTYPE = DESIGN (the row will be hidden when document is generated).

SPGROUP

Published:

SPGROUP

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

Parameter

Mandatory/Optional

Value (example)

Comment

FORMS

REPORT

SPGROUP

Mandatory in combination with another keyword/parameter

n/a

1

Defines which CVAL columns belongs to which SPVAL/SPKEY/SPLIM columns in the template.

SPGROUP is a parameter that must be defined in column A, when the parameters SPVAL and SPKEY are used in row SPGROUP states which of the CVAL columns belongs to which SPVAL/SPKEY/SPLIM columns. Since the template can contain several spread value (SPVAL) and spreadkey (SPKEY) columns, SPGROUP needs to be stated to group CVAL columns together. The parameter should be defined as a unique number that connects all columns belonging to the same spread group (allocation).

A SPGROUP value should be defined for the following columns (if defined in row 1):

  • SPVAL
  • SPKEY
  • SPLIM
  • CVAL

A SPGROUP value is defined for the SPVAL/SPKEY and CVAL columns in the template. The template below contains two spread groups (1 and 2). When the end-user enters a value in column R (a total for week 201101) and then selects a spread key in column S, the program will allocate the total value to CVAL columns T-X, since these columns belong to SPGROUP 1.

The SPGROUP row should be defined with ROWTYPE = DESIGN (the row will be hidden when document is generated).

SPGROUP

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