Filter operations

Top  Previous  Next

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.