Filter operations

By default FastReport filters the data rows, which contain the value, equal to the value of the control. This behavior is defined in the FilterOperation property of the control. You can use the following operations:

Operation	Equivalent	Effect
Equal	=	Filter the value if it is equal to the control's value.
NotEqual	<>	Filter the value if it is not equal to the control's value.
LessThan	<	Filter the value if it is less than the control's value.
LessThanOrEqual	<=	Filter the value if it is less than or equal to the control's value.
GreaterThan	>	Filter the value if it is greater than the control's value.
GreaterThanOrEqual	>=	Filter the value if it is greater than or equal to the control's value.

For example, if the FilterOperation property of the control is set to LessThanOrEqual and you enter the value 5 in the control, then all the data rows will be chosen, for which the corresponding column value is less than or equal to 5.

For the data of string type, you can use extra operations:

Operation	Effect
Contains	Filter the value if it contains the control's value.
NotContains	Filter the value if it does not contain the control's value.
StartsWith	Filter the value if it starts with the control's value.
NotStartsWith	Filter the value if it does not start with the control's value.
EndsWith	Filter the value if it ends with the control's value.
NotEndsWith	Filter the value if it does not end with the control's value.

For example, if the FilterOperation property of the control is set to StartsWith and you enter the A, then, all data rows whose corresponding data column's value starts with A, will be chosen.