Data Region Filters (Report Designer)

Use the Filters dialog box to define filters for the data region.

Options

• Expression
  Type or select the expression to evaluate.

• Operator
  Select the operator to use to compare the expression and the value.

• Value
  Type the expression or value against which to evaluate the expression in Expression. The default type for Value is System.String. Use expression syntax, which starts with an equal sign (=), to enter Visual Basic expressions. For example, to enter the numeric value 10, use =10.

• And/Or
  Displays the relationship with the filter on the next row. Enabled for one row when you start entering an expression in the next row.

• Up
  Click the Up button to move the selected filter up in the list.

• Down
  Click the Down button to move the selected filter down in the list.

• Delete
  Click the Delete button to delete the selected filter.

See Also

Reference

Report Designer F1 Help

Other Resources

Filtering Data in a Report
How to: Add a Filter (Report Designer)
Using Expressions in Reporting Services

Help and Information

Getting SQL Server 2005 Assistance

Change History