SSRS - Using a Multi Value Parameter selection in a Filter on a dataset

Original Post http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/c02370b5-aeda-47ec-a3a8-43b2ec1e6c26

Filter Method:

1. Create a multi-value parameter.  Let's call it @Animals and you select Dog, Cat, Bird (or Select All)
2. Your main Dataset, which will return a result set to your report, does not reference @Animals in it's where clause.
3. Instead, click on Dataset Properties and select Filters
4. In the Filter setup dialog, click on the column in your result set that corresponds to the Animal value.
5. For the operator, select the "In" operator
6. For the value, click the fx>parameters>select parameter>Remove the 0 in the Parameter.Value(0) so it looks like Parameter.Value()
7. Done!