Parameter Assigned

For a query that property allows specifying a parameter name receiving the result value of the column of the query. This parameter must be declared in the query with, for example a default value (Updated by a Value). If the parameter is numeric for example, the default value can be 1 or 0.

Once the query is run, the Assigned value to this parameter will be the result of the concerned column (it could be the first value, the last value or the sum of the values).

Each query column can thus feed a different parameter, giving best performance as only one query can feed several parameters.

The purpose of this new feature since version 4.20 is to retrieve the result value of several fields in a query and keep them in memory in several parameters. These parameters can thus be used later in another report included in the same report book in order to display the value or to use them in the area <Run Condition> visible in the global report properties.

See also for a report: Parameter Assigned