Filter

Applies to

Report

Filter condition for report data. This condition is applied to report data source just before previewing the report to filter the report data. When report data source type is ADO or BDE, the filtering is performed by ADO or BDE, respectively; for other data source types, the filtering is performed by Reportizer report engine.

Notes

1. When report data source type is ADO or BDE, there is an alternative (and more efficient) way to specify a filter condition by using WHERE clause of data source's SQL statement. This alternative way can be used only if your data source is an SQL text  (SQL query), not a table name.

2. For non-relational data source types, the filter condition should be Reportizer boolean expression (i.e. expression, which returns TRUE or FALSE), for example: dataset_field_val(1, 'ItemSize') > 1024.

See also Filter Examples.