FineReport business intelligence tool provides a specific parameter interface to place and query related controls in oder to facilitate parameter query data function.

1. Description

To facilitate parameter query data function, FineReport provides a specific parameter interface to place and query related controls. In addition, you can take simple attribute setting for the Parameter Interface:Attribute settings of parameter interface will be described one by one below.

2. Display Parameter Interface or not

Sometimes, the user hopes to control whether to display the Parameter Interface or not. In this way, you can either set whether to display Parameter Window on the Parameter Design Interface or you can add parameter &__pi__=false following URL when accessing the report to control no display of Parameter Interface.

Set Parameter Interface

You can set whether to display the Parameter Window via the Parameter Interface in our report designer, as shown below. Switch to the Parameter Panel Editing Interface. Click a blank area in Parameter Interface and select Parameter Interface. Uncheck Display Parameter Window at the right Attribute Table and the Parameter Interface will not be displayed:

Via __pi__Parameter

When accessing the report, add &__pi__=false following URL, and you can force the report not to display the Parameter Interface (the report has defined the Parameter Interface and set Display Parameter Window);

For example: http://localhost:8075/WebReport/ReportServer?reportlet=GettingStarted.cpt&__pi__=false.

Note: in the front and back of pi are two underlines in English.

3. Display report result before clicking query

Display Report Result before Clicking Query means that: in parameter definition, the user is not required to manually click the Query button to display report results. Instead, initial query and result output are made available via automatic use of parameter default value.

Realization ideas: first set default value for the parameter. Then, open the Parameter Design Interface and uncheck “Not Display Report Result before Clicking Query”.

Setting method

Enter the Editing Status of Parameter Interface and uncheck “Not Display Report Result before Clicking Query” in the Attribute Panel. Setting is as follows:

Note: When clicking Display Report Result before Clicking Query, set parameter default value. Otherwise, in initial display, filtering will be made based on Null.

Save template and click Preview to see the template. You are not required to click Query Button and the system will query data based on default value in initial time.

4. Set parameter panel background

The default background color of parameter is gray. However, how to set the parameter panel background to make the interface style same as the report style or to achieve other effects (for example, if the report background is white, and you hope that the Parameter Interface background is also white)?

Setting method

Select the Parameter Interface, and click the button following background in the Attribute Table. Change background color. As shown below:

The setting effect is same as that in Paper Back ground.

5. Parameter interface display position

Besides Hide and Parameter Panel Background Setting, you can also set the Parameter Interface display position.

Setting method

The Parameter Interface display positions include Left, Center and Right. Specific setting is as shown below:

Note: The Parameter Interface display positions (Left, Center and Right) will based on the Parameter Interface width, rather than the browser page width.

Left effect is as follows: