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

To filter a dataset

1. In the Data Explorer right-click the dataset to filter and select Edit.  
2. From the Data smart panel, select the Filters page.

3. Type or use the expression editor to provide the Expression by which to filter the data. 

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 with which to compare the expression results. For multiple values (used with the In and Between operators) separate values using commas.

See Also