You develop a SQL Server 2008 Reporting Services (SSRS) instance of a report model.
The organization requires that users of a report be able to dynamically change the server
environment.
You need to create a parameter that gives the user the option to choose the server before
report execution.
What should you do?
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.