Bizview Functional Descriptions Overview
Bizview Functional Descriptions OverviewThis section contains detailed descriptions of special functionality in Bizview that is not included previously in the documentation.Functional DescriptionsNote: Some of these descriptions are reused from older versions, and may or may not be accurate to the newest version of the function.#SECTIONnScriptsSelection PanesDrill DownDrop DownDashboard Design...
Functional Descriptions
Functional DescriptionsThis section contains the following topics:#SECTIONnScriptsSelection PanesDrill DownDrop DownDashboard DesignWorkflow DesignAudit TrailAUTO_UPDATEXML_InvoiceGeneral CommentsNote: Some of these descriptions are reused from older versions, and may or may not be accurate to the newest version of the function.
#SECTIONn
#SECTIONnRelated InformationParametersPARAM worksheet with several #SECTIONnSeveral sections of reports and/or forms can be created within one template. Since one workbook in Bizview only can contain one template and sometimes the same template should show various types of reports, different #SECTIONs can be used.When using #SECTION in column A in the template, the designer can create multiple ...
PARAM Worksheet with Several #SECTIONn
PARAM Worksheet with Several #SECTIONnRelated Information#SECTIONnWhen the template contains several sections, the parameters in PARAM can be tagged to different sections or applied to all sections. The section tag should be stated directly after the parameter within brackets [].If the parameter is stated without any SECTION tag in column A, then it will apply to all sections in the template:No...
Scripts
ScriptsRelated InformationScript EditorRibbon ScriptsEventsIn addition to parameters in PARAM, column A, and row 1, a template script can be connected to the template. The connected script can contain several different functions/methods which can be used in the template when creating Custom Buttons or Events. The script is created in Script Editor and is written in C# language.You can link the ...
Script Editor
Script EditorRelated InformationRibbon ScriptsEventsIf you are a BV30 user, you have access to System menu > Designer Tools > Template Scripts. In the Template Scripts grid, you can view all saved template scripts and expand the detail view to see all templates linked to the specific script. Open a script in the Script Editor by selecting the Script ID hyperlink:In the Script Editor, you can wr...
Ribbon Scripts - Custom Buttons
Ribbon Scripts - Custom ButtonsRelated InformationScript EditorStandard ScriptsTemplate ScriptsRibbon Scripts are scripts that create custom buttons in the ribbon when the document is generated. These buttons can then be used to execute some function or other event. Bizview contains four standard scripts that can be used and linked to custom buttons in the form. In addition to these standard ...
FUNCTION
FUNCTIONRelated InformationScript EditorRibbon ScriptsStandard Scripts = mandatory for each custom button scriptFor each custom button, a FUNCTION must be specified. The FUNCTION is the connection to the script written in the Script Editor and it is this parameter that defines what actually should happen when the end-user clicks the button.The application also supports four standards scripts wh...
TEXT
TEXTRelated InformationScript EditorRibbon Scripts = mandatory for each custom button scriptFor each custom button, a TEXT property should be defined. The TEXT parameter is simply the text that should be shown for the button in the ribbon when opening the form/report.When adding or editing a custom button in template design, you need to add a Text property for the button:When the right panel is...
IMAGE
IMAGERelated InformationScript EditorRibbon Scripts = optional for each custom buttonFor each custom button, an icon can be connected. The IMAGE parameter is simply a reference to an icon ID and the icon will be shown in the button in the ribbon. The icon should be preferably 16*16 and must e selected from the Image Library. If a custom button is created without an icon, the ribbon button will ...
TOOLTIP
TOOLTIPRelated InformationScript EditorRibbon Scripts = optional for each custom buttonFor each button in the Scripts worksheet, a TOOLTIP can be defined. The TOOLTIP parameter is simply a tooltip text that will be shown when the end-user hover over the button in the ribbon.When adding or editing a custom button in Template Design, you can add a tooltip property for the button:When the right pa...
VALIDATION_MESSAGE
VALIDATION_MESSAGERelated InformationScript EditorRibbon ScriptsStandard Scripts = optional for each custom buttonA custom button can be defined to first show a confirmation dialog before the actual custom button function is executed.To include a confirmation message when a user clicks the Custom button from the ribbon, add a message in the Confirmation Message field in the Add New or Edit Cust...
Generated Document
Generated DocumentRelated InformationScript EditorRibbon ScriptsBelow is an example of a form with two custom buttons defined:
Standard Scripts
Standard ScriptsRelated InformationRibbon ScriptsIn addition to customized ribbon scripts written in Script Editor, some standard scripts can be used in templates when creating custom buttons in a form template:bv_AddNewRow - Standard script for adding new rows in forms.bv_AddEmptyRow - Standard script for adding an empty row in forms.bv_ApplyProposal - Standard script for applying formula prop...
BV_AddNewRow
BV_AddNewRowRelated InformationRibbon ScriptsStandard ScriptsADDROW_FILTERCF_GETTABLEbv_AddEmptyRowIn a FORM, a standard script can be used to create an "Add new row" button in the ribbon. Note: This script is only applicable to forms with expanded rows (EXPAND in column A). If end-users should be able to add new records in the form, then this script should be used to create a button in the rib...
BV_AddEmptyRow
BV_AddEmptyRowRelated InformationRibbon ScriptsStandard Scriptsbv_AddNewRowIn a FORM, a standard script can be used to add an "Empty new row" button in the ribbon. Note: This script is only applicable for forms with expanded rows (EXPAND in column A). If users should be able to add new records in the form, then this script can be used to create a button in the ribbon, or the script bv_AddNewRo...
BV_ApplyProposal
BV_ApplyProposalRelated InformationRibbon ScriptsStandard Scriptsbv_RecallFormulaIf formulas are used in data cells in a form, and #ENTRY is used in order for the user to be able to change the proposed value, then the bv_ApplyProposal standard script should be used to make it possible to apply new proposals based on the previous formula in the cells. Cells with formulas in combination with #ENT...
BV_RecallFormula
BV_RecallFormulaRelated InformationRibbon ScriptsStandard Scriptsbv_ApplyProposalIf formulas are used in data cells in a form, and #ENTRY is used in order for the user to be able to change the proposed value, then this standard script should be used to make it possible to apply new proposal based on the previous formula in the cells. Cells with formulas in combination with #ENTRY will result in...
Events
EventsRelated InformationTemplate ScriptsScript EditorUse Procedure in EventDescriptive texts in EventsEvents are scripts (or procedures) that will trigger a specific action at a specific time. Events can either be connected to public methods in a linked template script or to a procedure. For more information about how to use a procedure (SQLPROC & SQLDDL) in an event, see "use procedure in ev...
Using Procedure in Events
Using Procedure in EventsRelated InformationEventsThere are two types of procedures, SQLDDL and SQLPROC. SQLDDL should return a SQL that runs when the procedure is completed, commonly used to return SQL creating temp tables. SQLPROC is used, but does not necessarily return any values. These procedures must be defined in the Event right panel in Template Design.This topic contains the following ...
Descriptive Text in Events
Descriptive Text in EventsRelated InformationEventsIt is possible to add a descriptive text that displays for the user when the report/form is being generated. This feature is most useful if the event takes a long time to execute when opening a report/form, and therefore, you might want the user to know what happens by showing a more descriptive text.When editing or adding a new event from the ...
Selection Panes
Selection PanesRelated InformationPane DesignerPane worksheetCF_GETPANEVALUESystem Administration - Pane DesignerSelection Panes are panes in which the end-user can make necessary selections to generate a report or a form. Most times, selections need to be defined for a document to get the correct numbers in the report or form. For example, defining which period the document should be generat...
Pane Designer
Pane DesignerRelated InformationSelection PanesPane worksheetCF_GETPANEVALUEData views in pane designerStandard pane proceduresThe selection panes that are connected to the templates should be created in the Pane Designer.The following properties can be changed for the pane area (the white area):Size of the pane (the white area) can be changed by dragging the bottom right corner. Color of the p...
Design Controls
Design ControlsRelated InformationSelection PanesPane DesignerData Views in Pane DesignerStandard Pane ProceduresThe following controls can be used in the Pane Designer to create a Selection Pane:LabelListAuto ListCheckboxImageDynamic ImageDate PickerTextbox
Label
LabelRelated InformationSelection PanesPane DesignerPane $ VariablesThe label control in the Pane Designer inserts a label in the pane. A label is simply a text that should be shown in the pane. When the label control is selected in the ribbon, it is inserted below the actual pane area. Drag the label to the desired place in the pane:The following properties can be changed for the Label: Brushe...
List
ListRelated InformationSelection PanesPane DesignerStandard Pane ProceduresThe List control in the Pane Designer inserts a combo box in the pane. A list control displays a list when the end-user clicks on the combo box. When the list control is selected in the ribbon, it is inserted below the actual pane area. Drag the list to the desired place in the pane:The following properties can be change...
Auto List
Auto ListRelated InformationSelection PanesPane DesignerStandard Pane ProceduresBizview VersionFeature available from Bizview version - Bizview 2011 R3 (1.0404.1530)The Auto List control in the Pane Designer inserts a list box where the end-user can enter a value to filter the list. An Auto List control displays a list when the end-user clicks on the arrow to the right in the control, but the u...
Checkbox
CheckboxRelated InformationSelection PanesPane DesignerStandard Pane ProceduresThe checkbox control in the Pane Designer inserts a checkbox in the pane. When the control is selected in the ribbon, it is inserted below the actual pane area. Drag the checkbox to the wished place in the pane:The following properties can be changed for the Checkbox control: (these sections can be found in the Art B...
Image
ImageRelated InformationSelection PanesPane DesignerThe Image control in the Pane Designer opens an Image library dialog. Select an image and click OK. The control is then inserted below the actual pane area. Drag the image to the desired place in the pane:The images available in the dialog are those that are uploaded in the Image Library (found in the System Administration panel). The size of ...
Dynamic Image
Dynamic ImageRelated InformationSelection PanesPane DesignerImage (control in Pane Designer)Bizview VersionFeature available from Bizview version - Bizview 2011 (1.0630.1705)Instead of inserting an actual image in the selection pane, you can use a dynamic image control. This control will then change the image that is shown, depending on the logged in client. Dynamic images can both be saved on ...