You maintain a SQL Server 2008 Reporting Services (SSRS) instance for a shoe company.
An existing report on shoe sales allows the user to see the company’s revenue across many
different attributes.
You need to create a drop down list that filters the report by one or more shoe colors.
You alter the main dataset and configure the report parameter to accept multiple values.
What should you do next?

A.
Create a distinct dataset that includes all possible values and attach it to the parameter.

B.
Create a dynamic dataset that utilizes the WHERE clause to filter by the parameter.

C.
Create a dynamic data source from a dataset by using the IN operator.

D.
Configure the Internal Visibility option for the parameter.

E.
Change the dataset from a shared dataset to an embedded dataset in the report.

F.
Create a dynamic data source from a dataset that includes a list of distinct servers.

G.
Create a dynamic dataset that includes a list of the different users.

H.
Configure the Hidden Visibility property.

Explanation: