Template parameter of Finereport BI means the parameter that is only applicable to current template, which is to be used with filter conditions.

1. Description

Template parameter in our report designer means the parameter that is only applicable to current template, which is to be used with filter conditions. It means that the data set takes out all data and template parameter will filter all useful data in data extension. The template parameter needs to be used with data column filtering.

2. Creating steps

2.1 Open report

2.2 Define template parameter

Click Template > Template Parameter menu to add an area parameter default as “North China”, as shown below:

2.3 Set parameter filter

When previewing template in report designer at this time, you will find the data column still extends all data in the data set. Therefore, template parameter is required for filtering. Double click the Area Data Column cell, and click Filter tab. The Condition will be Area = Parameter $ Area, as shown below:

Note: Select Data Type as Parameter, and the drop-down box will list names of all available parameters. Directly select one.

2.4 Create parameter interface

Click the Pen at the Parameter Module to make the Parameter Interface in an editable status. At the right bottom corner of the Parameter Interface will display the parameter names with no control, as shown below:

Note: Parameter and control are bound via parameter name. That means, if the control name and the parameter name are same, they are successfully bound. If a parameter is bound to a control, it means that an assignment to control at web side is equivalent to an assignment to parameter. Click non-generated parameter, and the control will be automatically bound to the parameter.

Click Add All to bind all parameters to controls and the controls will be displayed in the Parameter Interface. Here, controls include assignment controls corresponding to each parameter, all tab controls and query buttons. Default parameter interface is as shown below:

Click Set button in the Control and select Parameter Control Type.

Note: Aside from clicking Add All, you can also directly drag the control from Control bar to the Parameter Interface. Change the control name as the parameter name to bind the control with parameter. In this way, control assignment will be parameter assignment.

2.5 Save and issue reports

Save report and take a page break preview. Change the Parameter Value as “East China” to query the data of East China.