This tutorial illustrates how to filter data at the report data source level, as opposed to the report level. This approach is recommended when dealing with comparatively large data sources when the retrieval process is slow.

 

1.Switch to the Field List and drop the required fields onto the report's Detail band.

2.Select the data source in the Report Explorer, expand its Queries collection property in the Property Grid and click the ellipsis for the Filter String property of the required query.

3.In the invoked Filter Editor, construct an expression where the data fields are compared with the required values as shown below.

Every filter condition consists of three parts:

oA data field name.

oCriteria operator, such as Equals, Is less than, Is between, etc.

oA static operand value, another data field or a query parameter.

You can arrange specific conditions into groups with And, Or, Not And, and Not Or operators.

Switch to Print Preview to see the result.