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

ADDINFOn

Optional parameter in PARAM= 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

Optional parameter in PARAM

Optional parameter in PARAM

<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.

ADDINFO_Col!

Published:

ADDINFOn

Optional parameter in PARAM= 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

Optional parameter in PARAM

Optional parameter in PARAM

<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.

ADDINFO_Col!

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