Overview
Application scenarios: If you have installed the FVS plugin, you can view this article to learn about functions related to FVS templates.
Versions
Report Server Version | Plugin Version | Function Changes |
11.0.6 | 1.8.0 | Cancelled Visible on preview. You can hide or display components in the Widget Layer list. |
11.0.6 | 1.5.0 | Added Check Box Group Widget. |
Function Introduction
When previewing the template, you can tick different options in the Check Box Group Widget to link other components through parameters. The effect is as shown below:
For component animations, 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
Settings in the Check Box Group Widget are 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 modifying according to the actual parameter. |
Font Size | The font size of the content in the widget defaults to 12 px. |
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 Check Box Group Widget, which supports the following three types. 1. Custom String: You can input text directly, and when you enter multiple values, multiple options can be ticked. When you enter multiple values, the format needs to be consistent with the widget's Return type. When the return value is not modified, it is separated by a comma in English by default, such as: East China,North China.
2. Field: You can select field in the dataset. If a field has multiple values, multiple selections will be made.
3. Formula: Click fx on the right side to enter the formula. If the formula corresponds to multiple values, multiple selections will be made.
|
Return | Array: The return type is an array, for example: if three values are ticked, the return value will be:value1,value2,value3. |
String: The return value type is a string, and it needs to define the Separator, Starting Symbol, and Terminator. That is, multiple values that are ticked will be concatenated into a string according to the separator. Example: If the separator is defined as a comma, the starting symbol and terminator are both defined as single quotes, the return value will be value1,value2,value3.
| |
Layout | There are following three types you can choose. 1. Auto Fill: It can automatically adjust the number of rows and columns based on the option content. 2. Fixed Columns: It can be set to display as n columns. The default is one. 3. Fixed Rows: It can be set to display as n rows. The default is one. |
Permission | It is used to decide whether the widget is editable when previewing. The default option is editable. |
Validation | Allow null: It is ticked by default. If it is ticked, the widget is allowed to be null. If it is not ticked, you can enter content in Calibrate prompt text. And if Select All is not ticked during template preview, the prompt text will be displayed. |
Widget Interaction Events
Click Interaction > Add Event to add JavaScript events for more effects. The check box group widget supports After Initialization and Click 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.
2. Create a ds1 in database query, enter the SQL query statement SELECT * FROM Sales _Volume where Salesperson in ('${spe}') and set the parameter spe default value to Sun Lin. Then you will obtain sales data of Sun Lin by default.
As is shown below:
Adding Check Box Group Widget
1. Click Widget > CheckboxGroup and add check box group to the page.
On the Content tab page of the configuration panel on the right, modify the name to spe to match the spe parameter defined in the dataset. As is shown below:
2. Add check box group widget's data dictionary, select the type as Database Table, and select Salesperson field of the sales table in FRDemo. As is shown below:
To match the in statement in SQL, the return value type of this widget is set to String and you can input the separator as ',' by yourself.
After setting the separator, you can set the default value. And the format should be kept the same. If you need to set multiple default values in this case, you need to use the separator ',' to separate them, and input Sun Lin','Jin Shipeng.
Then set the layout according to the situation. As is shown below:
Adding Line Chart
Click Chart > Line Chart to add the component to the page, and add data with the spe parameter to the line chart. As is shown below:
Previewing the Effect
Click Save and click Preview. When you tick different options, the line chart will then display the product sales of corresponding salespersons. As is shown in section "Function Introduction".
Previous：FVS Drop-down Check Box Widget
