Filter Data at the Report Level
This tutorial illustrates how to filter data at the report level, as opposed to the data source level. This approach is useful when dealing with relatively small data sources, when data load times are acceptable.
Create a new report or open an existing one.
Bind you report to a required data source. See the Bind to Data section to learn more about providing data to reports.
Click the report's smart tag and click the Filter String property's ellipsis button.
In the invoked FilterString Editor, construct an expression in which the data fields are compared with the required values.
Every filter condition consists of three parts:
- A field of a data source to which a report is bound or the name of the calculated field, which exists in this data source at the same level.
- Criteria operator, such as Equals, Is less than, Is between, etc.
A static operand value, another data field or a report parameter. To access parameters, click the icon on the right until it turns into a question mark.
You can arrange specific conditions into groups with And, Or, Not And, and Not Or operators.
Your report is now ready to be generated. Switch to Print Preview to see the result.