Dataset (Filters Tab, Report Designer)

Use the Filters tab of the Dataset dialog box to define filters for the dataset.

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 arrow to move the selected filter up in the list.

• Down
  Click the Down arrow 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
Dataset (Data Options Tab, Report Designer)
Dataset (Fields Tab, Report Designer)
Dataset (Parameters Tab, Report Designer)
Dataset (Query Tab, Report Designer)

Other Resources

Defining Report Datasets
Using Expressions in Reporting Services

Help and Information

Getting SQL Server 2005 Assistance

Change History