Grouping and Sorting Properties (Filters Tab, Report Designer)
Use the Filters tab of the Grouping and Sorting Properties dialog box to define filter options for the group.
- 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.
Reference
Report Designer F1 HelpGrouping and Sorting Properties (Data Output Tab, Report Designer)
Grouping and Sorting Properties (General Tab, Report Designer)
Grouping and Sorting Properties (Sorting Tab, Report Designer)
Grouping and Sorting Properties (Visibility Tab, Report Designer)
Other Resources
Grouping Data in a ReportSorting Data in a Report
Using Expressions in Reporting Services
