Types and Differences of Parameters

The FineReport designer provides a parameter query function. This document introduces the types and differences of parameters.

Template Parameter

The template parameter refers to the parameter created in the current template. The parameter can only be used in the current template to design the report, and must be used with a filter condition to filter the data. For details, see Template Parameter.

Global Parameter

The global parameter refers to the parameter created in the current report project. You can define a global parameter under Server > Global Parameter on the menu bar of the designer with the same definition method as that of a template parameter. The parameter can be used in all the reports of the current report project, and must be used with a filter condition to filter the data. For details, see Global Parameter.

Note:

All defined global parameters are saved in the fine_conf_entity table of FineDB. If a global parameter and a template parameter share the same name, the template parameter is used in the system by default.

Template Parameter

Both template parameters and global parameters fall under the category of template parameters. The usage of global parameters is the same as that of template parameters, with the only difference being their application scope. For details, see section "Classification by Application Scope."

Dataset Parameter

When creating a dataset, you can define a dataset parameter in the SQL query statement and filter the data directly during the data query. Dataset parameters are divided into template dataset parameters and server dataset parameters based on the application scope. For details, see Dataset Parameter.

Template Dataset Parameter

You can define a template dataset parameter on the dataset management panel under Template Dataset > Database Query in the designer. The parameter can only be used in the current report. For details, see Dataset Parameter.

Server Dataset Parameter

You can define a server dataset parameter under Server > Server Dataset > Database Query on the menu bar of the designer with the same definition method as that of the template dataset parameter. The parameter can be used in all the reports of the current report project.

Note:

All defined server dataset parameters are saved in the fine_conf_entity table of FineDB. If a server dataset parameter and a template dataset parameter share the same name, the template dataset parameter is used in the system by default.

Relationship Between the Template Parameter and Dataset Parameter

Both methods are used to define parameters, and the functions of the two types of parameters are the same within their respective application scopes.

Parameters are uniquely identified by their names. Therefore, when a template parameter and a dataset parameter share the same name, they refer to the same parameter.