Microsoft
70-448 · Question #214
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…
The correct answer is A. Create a distinct dataset that includes all possible values and attach it to the parameter. See the full explanation below for the reasoning.
Question
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?
Options
- ACreate a distinct dataset that includes all possible values and attach it to the parameter.
- BCreate a dynamic dataset that utilizes the WHERE clause to filter by the parameter.
- CCreate a dynamic data source from a dataset by using the IN operator.
- DConfigure the Internal Visibility option for the parameter.
- EChange the dataset from a shared dataset to an embedded dataset in the report.
- FCreate a dynamic data source from a dataset that includes a list of distinct servers.
- GCreate a dynamic dataset that includes a list of the different users.
- HConfigure the Hidden Visibility property.
How the community answered
(28 responses)- A75% (21)
- B4% (1)
- C11% (3)
- G7% (2)
- H4% (1)
Community Discussion
No community discussion yet for this question.