You are a SQL Server 2008 Reporting Services (SSRS) developer. You develop a report
with two parameters named Region and City in that order.
When the Region parameter is selected, the City parameter should be filtered by the Region
selected.
You need to enable this functionality.
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.