Dataset Properties Dialog Box, Filters (Report Builder)

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

Filters that are part of a shared dataset definition on the report server affect all reports that use the shared dataset. Additional filters for the shared dataset can be specified after it is added to a report. These filters affect only the report in which they are defined.

Filters for an embedded dataset affect only the report in which they are defined.

For more information, see Filter, Group, and Sort Data (Report Builder and SSRS).

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.

  The values in Expression and Value must evaluate to the same data type. For example, if Expression is set to a field that has the data type System.Int32 and Value is set to 7, from the drop-down list, choose Integer.

  If the data type option you need is not in the drop-down list, write an expression to convert the value to the correct data type. For more information, see Filter Equation Examples (Report Builder 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.

See Also

Tasks

Add a Filter to a Dataset (Report Builder and SSRS)

Concepts

Report Embedded Datasets and Shared Datasets (Report Builder and SSRS)

Report Parameters (Report Builder and SSRS)

Expression Uses in Reports (Report Builder and SSRS)