Table Properties (Filters Tab, Report Designer)

Use the Filters tab of the Table Properties dialog box to define filter options for the table.

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
Table Properties (Data Output Tab, Report Designer)
Table Properties (General Tab, Report Designer)
Table Properties (Groups Tab, Report Designer)
Table Properties (Navigation Tab, Report Designer)
Table Properties (Sorting Tab, Report Designer)
Table Properties (Visibility Tab, Report Designer)

Other Resources

Working with Table Data Regions
Using Expressions in Reporting Services

Help and Information

Getting SQL Server 2005 Assistance

Change History