Bizview Reference Overview
Bizview Reference Overview
This section contains the following topics:
Parameters
Custom Functions
Syntax for SQL Smart
Template Commands
Template Variables
Parameters
Parameters
The Bizview application contains a number of different parameters that should be used when designing templates.
Parameters in Bizview:
Parameters in PARAM
Parameters in Column A
Parameters in Row 1
Parameters defined in the PARAM sheet are global parameters that apply to all data sources in the document.
Parameters that are specified in either column A or row 1 are specific pa...
Parameters in PARAM
Parameters in PARAM
Icon Description
= mandatory in PARAM
= mandatory in PARAM or in template worksheet
= mandatory in combination with another parameter, otherwise optional
= optional in PARAM
Parameters defined in the PARAM sheet are global parameters that apply to all data sources in the document.
This topic contains the following sections:
General Parameters
Common Parameters in...
SHEETNAME
SHEETNAME
=mandatory in PARAM sheet
Parameter (col A in PARAM)
Mandatory/Optional
Value (example)
Occurrence in PARAM sheet
Comment
FORMS
REPORT
SHEETNAME
TEMPLATE
1
The parameter value needs to correspond to the actual template worksheet name.
SHEETNAM...
CLIENT
CLIENT
=mandatory in PARAM sheet
Parameter (col A in PARAM)
Mandatory/Optional
Value in col C (example)
Value in col D (example)
Occurrence in PARAM
Comment
FORMS
REPORT
CLIENT
$CLIENT
Client IDs for retrieving values
e.g. NCG#NCGDEV
1
If $CLIENT, then value will be exchanged with logged in client. If a specific client is stated, then only that client can use the template...
USER
USER
=mandatory in PARAM sheet
Parameter (col A in PARAM)
Mandatory/Optional
Value in col C (example)
Occurrence in PARAM sheet
Comment
FORMS
REPORT
USER
$USER
1
If $USER, then value will be exchanged with logged in user. If a specific user is stated, then only th...
TEMPLATE_TYPE
TEMPLATE_TYPE
=mandatory in PARAM sheet
Parameter (col A in PARAM)
Mandatory/Optional
Value in col C (example)
Occurrence in PARAM sheet
Comment
FORMS
REPORT
TEMPLATE_TYPE
FORM/ REPORT/WEBLINK
1
Defines the type of template (Form, Report, or Weblink).
TEMPLATE_TY...
SEARCHCOL
SEARCHCOL
Related Information
SEARCHCOL in row 1
SEARCHVAL
= optional in PARAM or in template worksheet (FORM)
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
SEARCHC...
FORM_TAG
FORM_TAG
Related InformationFORM_TAG
Bizview VersionFeature available from Bizview version - Bizview 7.0
= optional in PARAM
Parameter (col A in PARAM)
Mandatory/Optional
Value in col C (example)
Value in col D (example)
Occurrence in PARAM sheet
Comment
FORMS
REPORT
FORM_TAG
<tag value>
optional, <tag value(s)> if other tag(s) should be fetched than in column C
1
Used to tag...
ADDSHEET
ADDSHEET
Related Information
ADDSHEET in Column A
ADDSHEET_TOTAL
TOTALSHEET_FIRST
<GLOBAL FILTERS>
ADDSHEET_PROC
ADDSHEET_NAME
= optional in PARAM sheet
Parameter (col A in PARAM)
Mandatory/Optional
Value in col C
Value in col D
Value in col E (example)
Occurrence in PARAM sheet
Comment
FORM
REPORT
ADSHEET_PROC
<OBJECT>
N/A
N/A
1
This parameter can be used if a new ...
ADDSHEET_PROC
ADDSHEET_PROC
Related Information
ADDSHEET
ADDSHEET in Column A
ADDSHEET_TOTAL
<OBJECT>
Bizview VersionFeature available from Bizview version - Bizview 2011 (1.0630.1705)
= optional PARAM sheet
Parameter (col A in PARAM)
Mandatory/Optional
Value in col C
Value in col D
Value in col E (example)
Occurrence in PARAM sheet
Comment
FORM
REPORT
ADSHEET_PROC
<procedure na...
VIEW_EMPTY_ADDSHEETS
VIEW_EMPTY_ADDSHEETS
Related Information
ADDSHEET in Column A
ADDSHEET_TOTAL
<OBJECT>
ADDSHEET_PROC
Bizview VersionFeature available from Bizview version -Bizview 2011 (1.0928.2019))
Parameter (col A in PARAM)
Mandatory/Optional
Value in col C (example)
Occurrance in PARAM sheet
Comment
FORMS
REPORT
VIEW_EMPTY_ADDSHEETS
N/A
TRUE/FALSE
1
Only sheets with values will be visible fo...
ADDSHEET_TOTAL
ADDSHEET_TOTAL
Related Information
ADDSHEET
TOTALSHEET_FIRST
= optional PARAM sheet
Parameter (col A in PARAM)
Mandatory/Optional
Value in col C
Occurrence in PARAM sheet
Comment
FORM
REPORT
ADDSHEET_TOTAL
N/A
<worksheet name>
1
If the ADDSHEET parameter is used, then this optional parameter can be used for REPORTS if a total worksheet should be created when break report...
TOTALSHEET_FIRST
TOTALSHEET_FIRST
= optional in PARAM
Parameter (col A in PARAM)
Mandatory/Optional
Value in col C (example)
Occurrence in PARAM sheet
Comment
FORMS
REPORT
TOTALSHEET_FIRST
N/A
TRUE/FALSE
1
In reports with ADDSHEET functionality the total sheet is placed last in the worksheet tabs. To place the total sheet first you set this parameter to TRUE.
TOTALSHEET_FIRST is a REPORT specifi...
NEW_DATA_BINDING
NEW_DATA_BINDING
Related Information
Parameters in PARAM
Data (New Design)
Data Bindings
= optional in PARAM
Parameter (col A in PARAM)
Mandatory/Optional
Value in col C (example)
Occurrence in PARAM sheet
Comment
FORMS
REPORT
NEW_DATA_BINDING
Available from B...
<OBJECT>
<OBJECT>
Related InformationADDSHEET
= mandatory in combination with another parameter; otherwise, optional
Parameter
Mandatory/Optional
Value in col C (example)
Value in col D (example)
Value in col E (example)
Occurrence in PARAM sheet
Comment
FORMS
REPORT
<OBJECT>
...
ADDINFOn
ADDINFOn
Related InformationADDINFOn in Col A
= 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>
<SQ...
VIEWTAG
VIEWTAG
Related Information
ROWTYPE
COLTYPE
= 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
VIEWTAG
<Tag ID>
<Descri...
SCALE
SCALE
Related InformationSCALE (Col A)
= 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
SCALE
-1000
N/A
N/A
x number ...
ENTER_BEHAVIOR
ENTER_BEHAVIOR
Bizview VersionFeature available from Bizview version - Bizview 7.0
= optional in PARAM
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
ENTER_BEHAVIOR
0/1/2
(Auto, Right, Down)
N/A
N/A
1
Possibility to decide how the ENTER key should move ...
OLD_GENERATION
OLD_GENERATION
Bizview VersionFeature available from Bizview version - Bizview 7.0
= optional in PARAM
Parameter (col A in PARAM)
Value in col C (example)
Occurrence in PARAM sheet
Comment
OLD_GENERATION
TRUE/FALSE
1
Generates report/form old way.
When Bizview 7....
TRACE
TRACE
Related Information
Short Commands to Trigger TRACE (generate document)
Short Command to Trigger TRACE (update form)
Tracing #plandata
= optional in PARAM sheet
Parameter (col A in PARAM)
Mandatory/Optional
Value in col C (example)
Value in col D (example)
Value ...
Short Command to TRACE (Generate Document)
Short Command to TRACE (Generate Document)
Related Information
TRACE
Tracing #plandata
Instead of changing the TRACE parameter in the PARAM sheet to TRUE each time a trace should be done when generating a document, there are quicker ways to trigger a TRACE.
This topic contains the following sections:
Short Command 1
Short Command 2 (versions prior to Bizview 7.0.4)
Short Command 2 (versi...
Short Command to TRACE (Update Form)
Short Command to TRACE (Update Form)
Related Information
TRACE
Tracing #plandata
Instead of changing the TRACE parameter in the PARAM sheet to TRUE each time a trace should be done when updating a form, there is a quicker way to trigger a TRACE.
When clicking the Update button in the Update Values dialog, hold Ctrl+Shift. Then, TRACE will be set as TRUE (even though the parameter is not ...
GLOBAL FILTERS
GLOBAL FILTERS
Related InformationADDSHEET
= optional
Parameter (col A in PARAM)
Mandatory/Optional
Value in col C (example)
Value in col D FORM(example)
Value in col E (example)
Occurrence in PARAM sheet
Comment
FORMS
REPORT
<OBJECT> or other data view field
<filter value(s)>
<filte...
DYNCOL
DYNCOL
Related Information
COLEXPAND
SEARCHCOL (Col A)
SEARCHVAL (Col A)
= 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)
Value in col F(example
Occurrence in PARAM shee...
SUBTOTAL
SUBTOTAL
Related InformationSUBTOTAL (Col A)
= optional in PARAM sheet, but mandatory if SUBTOTAL should be used
Parameter (col A in PARAM)
Mandatory/Optional
Value in col C (example)
Value in col D (example)
Value in col E (example)
Value in col F (example
Occurrence ...
VERSION
VERSION
Related InformationVERSION in FORMS
=mandatory in PARAM sheet or in the template worksheet (FORMS)
= optional in PARAM sheet
Parameter (col A in PARAM)
Mandatory/Optional
Value in col C (example)
Value in col D FORM (example)
Occurrance in PARAM sheet
Commen...
VALT
VALT
Related Information
VALT in column A
VALT in row 1
= optional in PARAM sheet
Parameter (col A in PARAM)
Mandatory/Optional
Value in col C (example)
Value in col D (example)
Occurrance in PARAM sheet
Comment
FORMS
REPORT
VALT
<VALTYPE ID>
<VALTYPE ID>
Ava...
CURR
CURR
Related Information
CURR in Column A
CURR in Row 1
= optional in PARAM sheet or in template worksheet
Parameter (col A in PARAM)
Mandatory/Optional
Value in col C (example)
Value in col D (example)
Occurrence in PARAM sheet
Comment
FORMS
REPORT
CURR
<CURRENCY ID...