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} < x / 2 ) Then
		true
Else
		false

i-net software strives to provide accurate product documentation. Please give us your feedback using the form below.
NOTE: This form is for documentation feedback only. For technical assistance, please send an email to crystalclear@inetsoftware.de.