Defines from which data source the information should be fetched. Must be defined as * (common for all data sources in the template), BV, or another valid data source ID for all keywords in row 1.

Mandatory for all keyword columns in row 1 in which the SOURCE is NOT defined as * or BV. Should be a column name or view name in the defined SOURCE.

Tag each column with a different COLTYPE so that the program knows how to handle the columns when generating the document. The value "DESIGN" is mandatory, however, the VIEWTAGs are optional.

A valid time unit ID for each CVAL column.

A valid time value for each CVAL column.

Default function is SUM. To override the default function used in the SQL query for each column, define another function such as MAX, MIN, or AVG.

State a having condition. Default "having > 0" will be added to the SQL queries.

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.

Parameter that can be used if the designer wants another value to be shown in the different worksheet tabs created from the ADDSHEET parameter. By default, it is always the value ID that is shown as the tab name. However, with the parameter, the designer can define that the tab name should only be the description or a combination of the ID and description.

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

Defines which CVAL columns belongs to an attribute that is defined in row 1.

Defines the currency for each CVAL column. Can be defined in column A, row 1, OR in PARAM.

Defines the value type for each CVAL column. Can be defined in column A, row 1, OR in PARAM.

VERSION can be stated in column A in the template, however, values for this parameter cannot be stated in entry columns (BV-columns) in forms. For BV-columns in a FORM, VERSION always must be defined in PARAM.

Values will be recalculated with the defined SCALE. Define a scale factor for each CVAL column. Can be defined in column A, row 1, OR in PARAM. By default, if no SCALE is defined in column A, row 1, or in PARAM then it is 1. Value must be a valid number.

Mandatory in combination with the ADDINFOn parameter in PARAM. In the ADDINFOn row in the template, the requested information will be automatically inserted when the document is generated.

To override the default order-by that is added to each SQL query (same as the order of the group by "*" columns), then this parameter can be defined in column A and a number for each "*" column should be added.

If the default headings in the spreadsheet are hidden, it can be difficult for an end-user to navigate in a report or form and easily know which row is the active row. This parameter can be used to specify which column should be highlighted when the row is active.

When drilling down from one template to another it can sometimes be useful to tag the different columns that the user can drill from. The tag can then be used in the procedure populating the drill template.

Defines which row(s) are data rows in the form. In other words, which rows are entry rows for registration. Needs to occur at least once in column A in a FORM template.

Defines if the row should be expandable. In other words, if the row should be repeated for each search value defined in SEARCHVAL (in row 1).

Defines the start of a group in a template and a descriptive text for the group (<TAG>). Will be used when adding rows to a form. In addition, if no rows are generated in the group, then all rows within START-STOP will be hidden.

Parameter to define if the column should be dynamically expanded when the document is generated.

Parameter to define which search column should be dynamically expanded in the columns.

Parameter to govern both how the subtotal should be executed and the layout of the subtotal row (this parameter governs the layout of the row if only one SUBTOTAL level, if several then SUBTOTAL_GROUPn rows defines the layout).