Parameter Reference

1) Expected Effect

The main function of parameters is to realize real-time interaction between users and data, that is, to filter data. We can use parameters in a variety of situations, such as referencing parameters in cells for dynamic captions, displaying different values based on parameter values, and so on. As shown below:

2) Implementation Roadmap

Using the formula, the parameter is referenced by [$parameter name]to achieve data filtering.

1.Templates Preparing 

1) Create a regular report, create a dataset ds1, and the SQL statement is: SELECT * FROM Sales_Volume.

2) Click [Template > Template Parameter]and add [Region]. The default value is"North China". As shown below:

3) Merge cells A1-C1 and add the formula: $Region + "Sales", as shown in the figure below:

2.Widgets Setting

1) Adding widgets

Add label widget, drop-down box widget, query widget, as shown below:

2)Setting widgets

• Select the label widget with the value of "region:", as shown below:

• Select the drop-down box widget, the widget name is "region", the data dictionary type is set to "Data Query", the dataset is ds1, the actual value is the same as the displayed value, column number 1. Or select the Column Index, and the actual value and display value are region, as shown below:

3. Adding Filter

Double-click A3 cell to add filter criteria, as shown below:

4.Effect Viewing

1）PC

Save the template and click "Pagination Preview" to see what it looks like in Section Iof this article. 

2）Mobile 

The end effect of App and HTML5 is as follows:

For the completed template, see: %FR_HOME% webapps\webroot\WEB-INF\reportlets\doc-EN\Primary\Parameter\Parameter_Reference1. cpt

Click to download the template:

Parameter Reference.cpt