Overview
Application scenarios: If you have installed the FVS plugin, you can view this article to learn about functions related to FVS templates.
Note: Mobile terminals are not supported.
Version
Report Server Version | Plugin Version | Function Changes |
11.0.6 | 1.8.0 | Cancelled Visible on preview. But you can hide or display components in Widget Layer list. |
11.0.6 | 1.5.0 | Added Textbox Widget. |
Function Introduction
When previewing the template, the drop-down options can be displayed by clicking, and other components will be linked through parameters. As is shown below:
For component animation, see FVS Component Animation.
For component styles, see FVS Component Basic Attributes. If you want to modify the widget name, set it on the Content tab page.
Functions
Widget Content
What can be set in the drop-down widget is shown as follows:
For details, see the table below:
Settings | Details |
Name | The widget name is the parameter name, and it is set as English by default. The name needs to be modified according to the actual parameter. |
Font size | The font size of the displayed text in the drop-down box is 12px by default, which has no effect on the font of the options in the drop-down. |
Data dictionary | It is used to add options of the widget. You must set it, otherwise the widget will not display options. For how to set it, see Data Dictionary. |
If you tick Remove Duplicates, it will merge the same items in the drop-down options. Otherwise, it will not merge them and will keep the duplicate options. It will be ticked by default. | |
Default value | You can set the displayed default value of the drop-down box., which supports the following three types. 1. Custom String: Text can be directly input. 2. Field: You can select field in the dataset. If the return value is an array, only the first value in the array will be displayed. 3. Formula: Click fx on the right side to enter the formula. If the return value is an array, only the first value in the array will be displayed
|
Watermark | The light gray watermark text displayed inside the widget during preview will remind you what to input. It will disappear by default after you click the widget to enter text. The widget content is empty by default. |
Permission | It is used to decide whether the widget is editable when previewing. The default option is editable. |
Validation | Allow null: It will be ticked by default. If ticked, the widget is allowed to be null. If not ticked, you can set calibrate prompt text. And if the widget is empty during template preview, the prompt text will be displayed. |
Allow custom value: Set whether to allow inputting values not included in the drop-down menu options.
|
Widget Interaction Events
Click Interaction > Add Event to add JavaScript events for more effects. The drop-down box widget supports After Initialization and Edit Finish events. As is shown below:
The JavaScript event settings box will pop up if you click a specific event. As is shown below:
Note: For JavaScript supported by FVS, see JS Interface Scenarios Supported by FVS Large Screen.
Examples
Preparing the Template
1. Click File > New FVS Report in the top left corner of the designer.
2. Create a database query ds1, enter the SQL query statement SELECT * FROM Sales _Volume where Region='${area}' and set the parameter area default value to East China. Then you will obtain sales data from the East China region by default.
As is shown below:
Adding Drop-down Box Widget
1. Click Widget > Drop-downBox and add it to the page.
On the Content tab page of the configuration panel on the right, modify the name to area and enter East China as the default value to match the area parameter defined in the dataset. As is shown below:
2. Add the drop-down box widget's data dictionary, select the type as Database Table, and select Region field of the sales table in FRDemo. As is shown below:
Adding Column Chart
Click Chart > Column Chart to add the component to the page, and add data with the area parameter to the column chart. As is shown below:
Previewing the Effect
Click Save in the upper right corner and click Preview. If you select different options from the drop-down menu, the column chart will then display the sales volume of salemen from different regions. As shown in section "Function Introduction".
