List

The 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 changed for the List control: (these properties can be found in the Art Board to the right in the Pane Designer)

• Brushes

• Layout

• Common Properties

• Text

Brushes

Change the color of the list box by using the brush in the art board. Changing color can be done in two ways:

• Dragging the marker in the brush area to the desired color.
• Entering a specific # color code in the defined area.

Layout

• Width: Can be changed in the art board or by dragging the bottom-right corner of the control to the right width.
• Height: Can be changed in the art board or by dragging the bottom-right corner of the control to the right height.
• Enabled: Determines whether the control should be enabled or disabled.
• Opacity
• Hidden: Determines whether the control is visible to the end-user.

In the Layout section, the position of the list can also be viewed. View the X and Y position by dragging the list control to desired position. When positioning many controls in a pane, it is a good idea to view the X position of the controls to make sure that they are positioned straight under each other.

Use the "Snap to Grid" feature for the pane to allow more precision when positioning the controls.

Common Properties

Control Tag

The controls in the pane for which values should be sent into the generated document need to be named with a control tag. The control tag ID will then be matched to the tags defined in the Pane worksheet in the template. In column B and C for the matched control tag, the selected value from the selection pane will be inserted in the Pane worksheet.

Tooltip

Enter a tooltip that will display when the end-user hovers over the list control in the selection pane:

Mandatory

Check the box if a selection in the list is mandatory:

Get Latest Value

Check the box if you want the control to always automatically return the latest selected value. If the control also has a default procedure connected, the auto_get_latest setting will override the default value for the particular control.

Important: Not supported in dashboard panes.

Dropdown Height

Enter a specific drop-down height (default is 130). In other words, how large should the drop-down list be when clicking on the list (how many rows should be visible without a scroll bar being created).

List with default dropdown height 130 (6 rows will be visible):            

List with dropdown height 250:

Multi Select

Check the box if the end-user should be able to make several selections in the list. If only one selection should be made, leave this box empty. When checking the Multi Select box, a new field is visible, where max selections should be defined. The default max number of selections that can be made in the list is 10. Setting a max selection number is recommended, otherwise, the selection can result in a very large document which takes long time to generate:

List with multi select:                      

List with NO multi select:

Allow Filtering

Check the box if the end-user should be able filter the results in the list. This feature should be used if the list returns a large number of rows, as it can be difficult for the end-user to quickly find the right values:

List with filter function:

                   List with NO filter function:

Script

The list must be connected to a script. Some standard script are included in the Bizview application. For example, p_pane_objlist (object values) and p_pane_timelist (time values). In addition, there is a possibility to write your own scripts (SQL queries) that can be connected to the list. Custom scripts should be written in DB Sharp Studio or SQL manager and saved with a name starting with s_pane_<xxxx> (scripts) or p_pane_<xxxx> (procedures in SQL manager). If the script is saved with a name starting with s_pane_ or p_pane_, then it will be visible in the Scripts list in Pane Designer:

When a script is selected, then a new section for any necessary input parameters displays:

To read more about the input parameters in dat.p_pane_objlist and how to setup dependent list boxes, see p_pane_objlist.

Default Values

In addition to connecting the list to a script, there is also an option to connect it to a script that defines default values for the list. If any parameter is necessary to define, then these will be visible below the "Default value(s)" list box:

For more information about this feature, see Default values in pane.

Text

• Font: The default font is Verdana. To change the font, select one from the list.
• Size: The default size is 11. To change the size, enter another size in the text box.
• Bold
• Italic