• Article

Dataset Properties Dialog Box, Filters

Select Filters on the Dataset Properties dialog box to create filters for the dataset.

Options

  • Add
    Add a new filter clause to the list.

  • Delete
    Delete the selected filter clause from the list.

  • Up arrow
    Move the selected filter up in the list.

  • Down arrow
    Move the selected filter down in the list

  • Expression
    Type or choose the expression to which you want to apply a filter. Click the Expression (fx) button to edit the expression.

  • Data type
    Choose the data type for Value. When possible, choose a data type that matches the data type for Expression. For more information, see Filter Equation Examples (Report Builder 3.0 and SSRS).

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

  • Value
    Type the expression or value to use when evaluating the expression specified in the Expression box. Click the Expression (fx) button to edit the expression.