Filter

Applies to

Data Source

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 is a relational database, the filtering is performed by the corresponding database engine; for other data source types, the filtering is performed by Reportizer report engine.

Notes

1. When report data source is a relational database, 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 sources, 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.