Group Selection Formula

In this dialog you can specify the group selection formula. It will be used to filter the groups that will be displayed in the report. This formula will be used on the data fetched from the database. The group selection formula can not be executed on database; i-net Clear Reports filters out the groups by itself after the records have been fetched from the database.
The return type of the formula must be Boolean.

Notes:

This formula will be used, only, if at least one group is defined in the report. Otherwise this formula will be ignored.
i-net Clear Reports tries to optimize the statement as good as possible. If an used function in the formula can be directly evaluated, the function will be replaced by its result.

Example:

# NumberVar
 
x;
x := Sum ( {MyTable.Price}, {MyTable.Lastname} );
If ( {MyTable.Price} &lt; x / 2 ) Then
    true
Else
    false

Group Selection Formula

Notes:

Example:

{{welcome.getConfig().welcomeTitle}}

Help - Group Selection Formula