Normally you would filter your data using parameters in the query, but if your data source does not support parameters, or if you want to pull all of the data from the data source before filtering it, you can use the following methods.

To filter a banded list group

1. In the Layout view of the report, right-click the banded list group and select Edit Group.
2. Choose the Filters page of the Groups smart panel.
   
3. Enter or select the expression to use for evaluating whether data is included in the group. 
4. Select the Operator to decide how to compare the Expression to the left with the Value to the right.

   =	Select this operator if you want to choose only data for which the value on the left is equal to the value on the right.
   Like	Select this operator if you want to choose data for which the value on the left is similar to the value on the right. For more information on using the Like operator, see the MSDN Web site.
   !=	Select this operator if you want to choose only data for which the value on the left is not equal to the value on the right.
   >	Select this operator if you want to choose only data for which the value on the left is greater than the value on the right.
   >=	Select this operator if you want to choose only data for which the value on the left is greater than or equal to the value on the right.
   <	Select this operator if you want to choose only data for which the value on the left is less than the value on the right.
   <=	Select this operator if you want to choose only data for which the value on the left is less than or equal to the value on the right.
   Top N	Select this operator if you want to choose only items from the value on the left which are the top number specified in the value on the right.
   Bottom N	Select this operator if you want to choose only items from the value on the left which are the bottom number specified in the value on the right.
   Top %	Select this operator if you want to choose only items from the value on the left which are the top percent specified in the value on the right.
   Bottom %	Select this operator if you want to choose only items from the value on the left which are the bottom percent specified in the value on the right.
   In	Select this operator if you want to choose only items from the value on the left which are in the array of values on the right. Values on the right are separated by commas.
   Between	Select this operator if you want to choose only items from the value on the left which fall between the two values on the right. Values on the right are separated by commas.

5. Enter the Value to compare with the expression on the left based on the selected operator. For multiple values (used with the In and Between operators) separate values using commas.

See Also