TechNet
Export (0) Print
Expand All

Dataset Properties Dialog Box, Filters

 

Applies To: SQL Server 2016

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

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 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.

Filter, Group, and Sort Data (Report Builder and SSRS)
Report Datasets (SSRS)

Community Additions

ADD
Show:
© 2016 Microsoft