ADDINFOn
= optional in PARAM sheet
Parameter (col A in PARAM) | Mandatory/Optional | Value in col C (example) | Value in col D (example) | Value in col E (example) | Occurrence in PARAM sheet | Comment | |
|---|---|---|---|---|---|---|---|
FORMS | REPORT | ||||||
ADDINFOn | <DATASOURCE> | <SQL query> | N/A | x number of times | Used in order to retrieve additional information into the template (ADDINFO1, ADDINFO,2 and so on). | ||
ADDINFOn is a common parameter that can be used for both FORMS and REPORTS. This parameter can be used to retrieve additional information into the template. Any information that might be useful to show in the document can be inserted. For example, an address, phone number for each customer group, or a description of an object, and so on.
This parameter can be stated several times in the PARAM sheet as ADDINFO1, ADDINFO2, and so on.
Note: In column A in the template, the ADDINFO<n> parameter must be defined in order for Bizview to know where the additional information should be inserted. For more information about how to use the additional information, see ADDINFOn in Column A.
$ variables to be used in the SQL query:
Any control tag from the PANE worksheet, like $UNIT (if UNIT selections are made in the Selection Pane and these should affect the ADDINFO query)
$CLIENT
$USER
$BREAK
Template Design - in PARAM sheet:
Column A: The parameter ADDINFO<n> must be stated, like ADDINFO1. You can add as many ADDINFOs as you like, as long as they have a unique number.
Column C: Data source ID (IDs defined in Bizview) towards which the SQL query should be executed. If the query should execute towards Bizview database, leave column C blank.
Column D: The SQL query or Data view ID to retrieve the additional information.
The object specified in ADDSHEET can be specified as $<BREAK> ($UNIT in this example) in the SQL query, in order to insert the correct values in each worksheet that is created.
Note: This parameter does not contain input fields in the right panel in HTML5 Template Design. If you want to use this parameter instead of a GETTABLE (data sheet) query, then you need to add the parameter directly in the PARAM sheet.
Depending on how many values the ADDINFO query returns, they will be inserted in the template worksheet in the defined ADDINFO<n> row (from column C and forth). For more information, see ADDINFOn in Col A.