Overview
This document is applicable to users who have installed the FineVis Data Visualization plugin to learn plugin functions.
Version
Report Server Version | Plugin Version | Functional Change |
---|---|---|
11.0.16 | V1.x | |
11.0.16 | V2.0.0 | Optimized the interactive effect of the widget Content panel. |
11.0.16 | V2.0.1 |
|
11.0.22 | V2.8.0 | Separated parameters from widget names, and added Bound Parameter. For details, see section "Widget Content." |
Function Description
During the template preview, you can select options from the drop-down tree widget to link the widget with other components through parameters. The following figure shows the effect.
For details about the component animation, see FVS Component Animation.
For details about the component style, see FVS Component Style and Attribute.
Function Description
Widget Content
The following figure shows the setting items on the Content tap page of a drop-down tree widget.
The following table describes the settings in detail.
Setting Item | Description |
---|---|
Bound Parameter | The value entered here is a parameter name used to bind a parameter to the widget. The value is empty by default, and you need to set this value based on the actual parameter to be bound. You can bind an existing parameter, or enter a new value to create a parameter. |
Option Source | Three creation methods, namely Automatic Creation, Basic Layered Creation, and Fast Layered Creation, are available for setting Actual Value and Display Value of a drop-down tree. |
Option | Multiselect: If it is ticked, you can select multiple options in a drop-down tree. If it is unticked, you can select only one option in a drop-down tree. Multiselect is unticked by default. If Multiselect is ticked, whether Return Leaf Nodes Only is ticked will affect whether child nodes are automatically selected when the parent node is ticked.
|
Expand Tree Nodes Asynchronously: It is the node loading logic, which can affect the performance. This option is ticked by default.
| |
Return Leaf Nodes Only: A drop-down tree is a hierarchical widget where each terminal leaf node has its full hierarchical path. Only the leaf nodes of a drop-down tree are returned by default. If you select Phnom Penh, the return value is Phnom Penh. | |
Return Full Hierarchical Path: A drop-down tree is a hierarchical widget where each terminal leaf node has its full hierarchical path. If it is ticked, the complete hierarchical path is returned, and the returned value is of the array type. Return Full Hierarchical Path is unticked by default. After it is ticked, for example, when Phnom Penh is selected, the returned value is Southeast Asia,Cambodia,Phnom Penh. | |
Returned Value | The Returned Value setting item appears only when Multiselect is ticked and Return Full Hieradrchical Path is unticked. This setting item allows you to set the format of the return value for a multi-select drop-down tree with the Array and String formats.
For example, if Separator is set to Comma (,), and Starter and Terminator are both set to Single Quotation mark ('), the returned value will be 'Value1,Value2,Value3'. |
Default Value | You can set the default value displayed in a drop-down tree widget. The following three types of default values are available: 1. Custom String: You can directly enter the text.
2. Field: You can select fields from the dataset. If a field value conforms to multiple value formats and Multiselect is enabled, multiple options will be selected as the default value. 3. Formula: You can click fx on the right to enter a formula. For example, you can use the formula =Table1~A1 or =[[1,11,111],[1,11,112]] to retrieve the value of cell A1 in the Table 1 component. |
Watermark | Light gray watermark text is displayed in the widget during the preview to remind you to enter the required information. The watermark disappears after an option is selected or the required text is entered. The input box of Watermark is empty by default. |
Permission | The setting item is used to set whether the widget is editable during the initial page preview. Allow Edit is selected by default. |
Validation | Null Value Validation: This option is used to determine whether the widget can be empty. Allow Null is ticked by default.
|
Custom Value Validation: This option is used to determine whether you can enter values that are not included in the drop-down options.
| |
Content Style | Font Style: You can set the font styles of the text displayed in the widget, such as the type, size, and color. The size of the widget icon is also affected by the setting of Font Style, as shown in the following figure. ![]() 1. The font in the drop-down options is not affected by the setting. The font style of the drop-down options can be changed through the FVS template style. 2. If you modify the font color, and then set the FVS template style, the font color will change with the theme. You need to reset the color as needed. 3. The color of the widget icon can be set in the style setting of the template theme. |
Widget Interaction Event
Choose Interaction > Add Event. You can add a JavaScript event to achieve more effects. After Initialization and Edit End events can be added for the drop-down tree widget, as shown in the following figure.
The corresponding Execution Setting box will pop up on the right after you click one of the events, as shown in the following figure.

Example
Template Creation
Choose File > New FineVis Visualization Dashboard in the upper left corner of the designer, and create a blank dashboard. You can customize the dashboard name and size, as shown in the following figure.
Data Preparation
Create a dataset ds1 with the SQL statement: SELECT ShipperRegion,ShipperCountry,ShipperCity FROM Orders_new where ShipperCity!=''. The dataset will be served as the data dictionary for the drop-down tree widget.
Create a dataset ds2 with the SQL statement: SELECT * FROM Orders_new ${if(len(area)=0,"","where ShipperCity = '" + area + "'")}.
The following figure shows the steps.
Drop-down Tree Widget Design
Component Adding
Choose Widget > Tree > Dropdown Tree in the component area, drag a Dropdown Tree component into the canvas, set Bound Parameter to area, which is the dataset parameter set in ds2, as shown in the following figure.
Option Source Setting
1. Click to open the Option Source setting box, and click
to add a layer. Creation Method is set to Fast Layered Creation by default, as shown in the following figure.
2. Select the corresponding value for each layer, and set the corresponding Dependent Layer and Dependent Field, as shown in the following figure.
Table Component Design
Component Adding
1. Choose Other > Text > Table in the component area, drag a Table component into the canvas, and click Edit Component on the configuration panel to open the table editing page, as shown in the following figure.
Table Content Design
Drag the corresponding fields into the cells, and adjust the cell formats as needed, as shown in the following figure.
4. Click Return to FineVis Visualization Dashboard to return to the canvas.
Effect Display
PC
Click Save in the upper-right corner, and then click Preview. The following figure shows the effect.
Mobile Terminal
For details about the preview method, see FVS Preview on Mobile Terminal. The following figure shows the effect.
Template Download
For details, you can download the template: FVS Drop-down Tree Widget Example.fvs.