Filtering Data

If the data source bound to your report contains far more data rows than are necessary for processing report creation, you can exclude excessive or undesired data. To accomplish this, construct a filtering expression, using single or multiple data fields.

This document describes two approaches to filtering data with the Web Report Designer.

Filter Data at the Report Level

To filter report data, switch to the Properties Panel, Actions or Data category, click the ellipsis button for the report's Filter String property.

In the invoked Filter Editor,

In every filter condition, the left part contains either the data field name, or the name of the calculated field, report parameters.

To access parameters, expand the drop-down menu for a value placeholder and select the Parameter item.

This will convert the value placeholder into a parameter placeholder. Click this placeholder to insert the required parameter.

Filter Data at the Data Source Level

To filter data at the report data source level, do the following.

  1. Invoke the SQL Data Source Wizard. Field List panel, select the required SQL query and click the Edit query button.

  2. On this wizard page, click Run Query Builder... to edit the SQL query.

  3. In the invoked Query Builder, Filter property, and in the invoked Filter Editor,

See Also