Combo Box is an element of filtering on the dashboard, which is used to filter data for analysis, depending on the selected value. This element is an analogue of the List Box element, with the only difference that all values are contained in the drop-down menu. It can be located anywhere on the dashboard. Depending on the size of the dashboard panel in the viewer, it can grow or shrink by width only.
 

 

 

This chapter will cover the following:

Combo Box editor;

Table Of Properties.

 

The Combo Box element may be subordinate to other filtering elements or be the main filtering element for them. The Combo Box item can work in two selection modes:

One. In the viewer you can select only one value of the Combo Box. Accordingly, data filtering for the elements of the dashboard will be executed only by one value.

Multi. In the viewer you can select several values of the Combo Box. Accordingly, data filtering for the elements of the dashboard will be executed by all selected values.

 

The item is set up in its editor. To call the editor, you should to the following in the report designer:

Double-click the Combo Box;

Select the Combo Box and select Design in the context menu.

 

Information

 

The search string for elements will be displayed automatically, if the number of values of the element will be 10.

 

 

 

Combo Box editor

In the editor of the Combo Box element, you may add elements with data, set up the mode for selecting values, select the main element of filtering.
 

 

The Key field. The data element is specified there by the values of which the data will be filtered.

The Name field. Indicates the data item which values will be displayed in the Combo Box element. If the name is not specified, then the names of keys will be displayed in the list item.

The Field field. Displays the expression of the selected item data field.

The Selection Mode parameter. Specifies the number of simultaneously selected values of a Combo Box item — One or Multi. If one value is selected, the data will be filtered by the current value of the Combo Box element. If the Multi mode is set, the filtering will be performed for all selected values.

The Show (All) Value option. Enables the option to select all values in the Combo Box element. If this option is enabled, then the Select (All) Value value will be present in the Combo Box element.

The Show Blanks parameter allows you to display or not to display blank values from a data source in the list of the values of the current element.

The Parent Element parameter. It is used to define the main filtering element for the current Combo Box element. The data of these filter elements will be interrelated, and depending on the selected value of the main element, the list of values of the current element will be filtered.

 

Get acquainted with the step-by-step instruction in the Dashboards with Combo Box chapter.

 

 

List of properties

The list shows the name and description of the properties of the element which you may find in the properties panel of the report designer.

 

Name

Description

Data Transformation

Customizes the data transformation of the current item.

Group

Adds the current item to a specific group of items.

Back Color

Changes the background color of the element. By default, this property is set to From Style, i.e. the color of the element will be obtained from the settings of the current element style.

Border

A group of properties that allows you to customize the borders of the element - color, sides, size, and style.

Font

A group of properties defines the font family, its style, and size for the values of the element.

Fore Color

Specifies the color of the values of the element. By default, this property is set to From Style, i.e. the color of the values will be obtained from the settings of the current element style.

Style

Selects a style for the current element. The default it is set to Auto, i.e. the style of this element is inherited from the style of the dashboard.

Enabled

Enables or disables the current item on the dashboard. If the property is set to True, the current item is enabled and will be displayed when previewing the dashboard in the viewer. If this property is set to False, this element is disabled and will not be displayed when previewing the dashboard in the viewer.

Margin

A group of properties that allows you to define margin (left, top, right, bottom) of the value area from the border of this element.

Padding

A group of properties that allows you to define padding (left, top, right, bottom) of values from the range of values.

Text Format

Sets the formatting of values for the element.

Name

Changes the name of the current element.

Alias

Changes the alias of the current item.

Restrictions

Configures the permissions to use the current item in the dashboard:

The Allow Change option enables or disables changes of the element. If checked, the current item can be changed.

The Allow Delete option enables or disables the deletion of an element.

The Allow Move option allows or prohibits moving an element.

The Allow Resize option enables or disables resizing of an element.

The Allow Select option enables or disables the element selection.

Locked

Locks or unlocks resizing and replacement of the current element. If the property is set to True, the current element cannot be moved or resized. If this property is set to False, then this element can be moved and resized.

Linked

Binds the current location to the dashboard or another element. If the property is set to True, then the current item is bound to the current location. If this property is set to False, then this element is not tied to the current location.