Bizview from insightsoftware

Bizview Reference Overview
Bizview Reference OverviewThis section contains the following topics: ParametersCustom FunctionsSyntax for SQL SmartTemplate CommandsTemplate Variables
Parameters
ParametersThe Bizview application contains a number of different parameters that should be used when designing templates. 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 parameters for either columns or rows.Parameters in Bizview:Parameters in PARAMParameters in Col...
Parameters in PARAM
Parameters in PARAMIcon Description = mandatory in PARAM = mandatory in PARAM or in template worksheet = mandatory in combination with another parameter, otherwise optional = optional in PARAMParameters defined in the PARAM sheet are global parameters that apply to all data sources in the document.This topic contains the following sections:General ParametersCommon Parameters in PARAMFORM Spec...
SHEETNAME
SHEETNAME         =mandatory in PARAM sheet                                                                                                                        Parameter (col A in PARAM)Mandatory/OptionalValue (example)Occurrence in PARAM sheetCommentFORMSREPORTSHEETNAMETEMPLATE1 The parameter value needs to correspond to the actual template worksheet name.SHEETNAME is a general parameter th...
CLIENT
CLIENT=mandatory in PARAM sheet  Parameter (col A in PARAM)Mandatory/OptionalValue in col C (example)Value in col D (example)Occurrence in PARAMCommentFORMSREPORTCLIENT$CLIENTClient IDs for retrieving valuese.g. NCG#NCGDEV1If $CLIENT, then value will be exchanged with logged in client. If a specific client is stated, then only that client can use the template.CLIENT is a general parameter that ...
USER
USER=mandatory in PARAM sheet                                                                                                                        Parameter (col A in PARAM)Mandatory/OptionalValue in col C (example)Occurrence in PARAM sheetCommentFORMSREPORTUSER$USER1If $USER, then value will be exchanged with logged in user. If a specific user is stated, then only that user can use the templ...
TEMPLATE_TYPE
TEMPLATE_TYPE=mandatory in PARAM sheet                                                                                                                        Parameter (col A in PARAM)Mandatory/OptionalValue in col C (example)Occurrence in PARAM sheetCommentFORMSREPORTTEMPLATE_TYPEFORM/ REPORT/WEBLINK1Defines the type of template i.e form, report or weblinkTEMPLATE_TYPE is a general parameter t...
SEARCHCOL
SEARCHCOLRelated InformationSEARCHCOL in row 1SEARCHVAL=  optional in PARAM or in template worksheet (FORM)                                                                                                  Parameter (col A in PARAM)Mandatory/OptionalValue in col C (example)Value in col D (example)Value in col E (example)Occurrence in PARAM sheetCommentFORMSREPORTSEARCHCOL<OBJECT>n/an/ax times d...
FORM_TAG
FORM_TAGRelated InformationFORM_TAGBizview VersionFeature available from Bizview version - Bizview 7.0 = optional in PARAM Parameter (col A in PARAM)Mandatory/OptionalValue in col C (example)Value in col D (example)Occurrence in PARAM sheetCommentFORMSREPORTFORM_TAG<tag value>optional, <tag value(s)> if other tag(s) should be fetched than in column C1Used to tag saved data with a unique value.F...
ADDSHEET
ADDSHEETRelated InformationADDSHEET in Column AADDSHEET_TOTALTOTALSHEET_FIRST<GLOBAL FILTERS>ADDSHEET_PROCADDSHEET_NAME= optional in PARAM sheet  Parameter (col A in PARAM)Mandatory/OptionalValue in col C Value in col D Value in col E (example)Occurrence in PARAM sheetCommentFORMREPORTADSHEET_PROC<OBJECT>n/an/a1This parameter can be used if a new worksheet should be created for each specified o...
ADDSHEET_PROC
ADDSHEET_PROCRelated InformationADDSHEETADDSHEET in Column AADDSHEET_TOTAL<OBJECT>Bizview VersionFeature available from Bizview version - Bizview 2011 (1.0630.1705)= optional PARAM sheetParameter (col A in PARAM)Mandatory/OptionalValue in col C Value in col D Value in col E (example)Occurrence in PARAM sheetCommentFORMREPORTADSHEET_PROC<procedure name>n/an/a1Instead of using the object values s...
VIEW_EMPTY_ADDSHEETS
VIEW_EMPTY_ADDSHEETSRelated InformationADDSHEET in Column AADDSHEET_TOTAL<OBJECT>ADDSHEET_PROCBizview VersionFeature available from Bizview version -Bizview 2011 (1.0928.2019))Parameter (col A in PARAM)Mandatory/OptionalValue in col C (example)Occurrance in PARAM sheetCommentFORMSREPORTVIEW_EMPTY_ADDSHEETS n/aTRUE/FALSE1From version XXXXXX then empty break sheets will be deleted and not shown. ...
ADDSHEET_TOTAL
ADDSHEET_TOTALRelated InformationADDSHEETTOTALSHEET_FIRST= optional PARAM sheetParameter (col A in PARAM)Mandatory/OptionalValue in col C Occurrence in PARAM sheetCommentFORMREPORTADDSHEET_TOTALn/a<worksheet name>1If the ADDSHEET parameter is used, then this optional parameter can be used for REPORTS if a total worksheet should be created when break reports have been generated.ADDSHEET_TOTAL is...
TOTALSHEET_FIRST
TOTALSHEET_FIRST = optional in PARAM Parameter (col A in PARAM)Mandatory/OptionalValue in col C (example)Occurrence in PARAM sheetCommentFORMSREPORTTOTALSHEET_FIRSTn/aTRUE/FALSE1In 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 specific parameter  to manage where...
<OBJECT>
<OBJECT>Related InformationADDSHEET         = mandatory in combination with another parameter; otherwise, optional                                                                                                  ParameterMandatory/OptionalValue in col C (example)Value in col D (example)Value in col E (example)Occurrence in PARAM sheetCommentFORMSREPORT<OBJECT><object value(s)><object value(s)>...
ADDINFOn
ADDINFOnRelated InformationADDINFOn in Col A= optional in PARAM sheet                                                                                                                      Parameter (col A in PARAM)Mandatory/OptionalValue in col C (example)Value in col D (example)Value in col E (example)Occurrence in PARAM sheetCommentFORMSREPORTADDINFOn<DATASOURCE><SQL query>n/axnumber of timesU...
VIEWTAG
VIEWTAGRelated InformationROWTYPECOLTYPE= optional in PARAM sheet                                                                                                                        Parameter (col A in PARAM)Mandatory/OptionalValue in col C (example)Value in col D (example)Value in col E (example)Occurrence in PARAM sheetCommentFORMSREPORTVIEWTAG<Tag ID><Description>TRUE/FALSExnumber of time...
SCALE
SCALERelated InformationSCALE (Col A)= optional in PARAM sheet                                                                                                                        Parameter (col A in PARAM)Mandatory/OptionalValue in col C (example)Value in col D (example)Value in col E (example)Occurrence in PARAM sheetCommentFORMSREPORTSCALE-1000n/an/ax number of times if sections exists in ...
ENTER_BEHAVIOR        
ENTER_BEHAVIOR        Bizview VersionFeature available from Bizview version - Bizview  7.0 = optional in PARAM Parameter (col A in PARAM)Mandatory/OptionalValue in col C (example)Value in col D (example)Value in col E (example)Occurrence in PARAM sheetCommentFORMSREPORTENTER_BEHAVIOR0/1/2(Auto, Right, Down)n/an/a1Possibility to decide how the ENTER key should move in a specific template. Option...
OLD_GENERATION
OLD_GENERATIONBizview VersionFeature available from Bizview version - Bizview 7.0= optional in PARAM                                                                                                                        Parameter (col A in PARAM)Value in col C (example)Occurrence in PARAM sheetCommentOLD_GENERATIONTRUE/FALSE1Generates report/form old way.When Bizview 7.0 was released, the SQL q...
TRACE
TRACERelated InformationShort 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/OptionalValue in col C (example)Value in col D (example)Value in col E (example)...
Short Command to TRACE (Generate Document)
Short Command to TRACE (Generate Document)Related InformationTRACETracing #plandataInstead 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 1Short Command 2 (versions prior to Bizview 7.0.4)Short Command 2 (versions from Bizvie...
Short Command to TRACE (Update Form)
Short Command to TRACE (Update Form)Related InformationTRACETracing #plandataInstead 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 changed in ...
GLOBAL FILTERS
GLOBAL FILTERSRelated InformationADDSHEET       =  optional                                                                                        Parameter (col A in PARAM)Mandatory/OptionalValue in col C (example)Value in col D FORM(example)Value in col E (example)Occurrence in PARAM sheetCommentFORMSREPORT<OBJECT> or other data view field<filter value(s)><filter value(s)>      if other fil...
DYNCOL
DYNCOLRelated InformationCOLEXPANDSEARCHCOL (Col A)SEARCHVAL (Col A)= optional in PARAM sheet                                                                                                                        Parameter (col A in PARAM)Mandatory/OptionalValue in col C (example)Value in col D (example)Value in col E (example)Value in col  F(exampleOccurrence in PARAM sheetCommentFORMREPORTDYN...
SUBTOTAL
SUBTOTALRelated InformationSUBTOTAL (Col A)= optional in PARAM sheet, but mandatory if SUBTOTAL should be used                                                                                                                        Parameter (col A in PARAM)Mandatory/OptionalValue in col C (example)Value in col D (example)Value in col E (example)Value in col F (exampleOccurrence in PARAM sheetCom...
VERSION
VERSIONRelated InformationVERSION in FORMS   =mandatory in PARAM sheet or in the template worksheet (FORMS)= optional in PARAM sheet                                                                                                                        Parameter (col A in PARAM)Mandatory/OptionalValue in col C (example)Value in col D FORM (example)Occurrance in PARAM sheetCommentFORMSREPORTVERSI...
VALT
VALTRelated InformationVALT in column AVALT in row 1 = optional in PARAM sheet                                                                                                                        Parameter (col A in PARAM)Mandatory/OptionalValue in col C (example)Value in col D (example)Occurrance in PARAM sheetCommentFORMSREPORTVALT<VALTYPE ID><VALTYPE ID>Click for info Available from Bizvie...
CURR
CURRRelated InformationCURR in Column ACURR in Row 1= optional in PARAM sheet or in template worksheet                                                                                                                Parameter (col A in PARAM)Mandatory/OptionalValue in col C (example)Value in col D (example)Occurrence in PARAM sheetCommentFORMSREPORTCURR<CURRENCY ID><CURR ID>Available from Bizview...
DELETE_WHERE
DELETE_WHERERelated InformationDELETE_METHODDISABLE_TEMPL_DELETEAudit Trail = optional in PARAM                                                                                                                    Parameter (col A in PARAM)Mandatory/OptionalValue in col C (example)Value in col D (example)Occurrence in PARAM sheetCommentFORMSREPORTDELETE_WHEREn/a<OBJECT><Object value>x number of ti...
First Page
Back
For an optimal Community experience, Please view on Desktop