70-466 · Question #132
You need to recommend a solution to meet the requirements for the ManufacturingIssues.rdl report. What is the best solution that you should include in the recommendation? More than one answer choice…
The correct answer is C. Add a dataset to the report that uses an ad hoc SQL statement. Configure the dataset to include the parameters required for the different views. Use the default display for the parameters. When adding an ad hoc SQL dataset with parameters in SSRS, using the default parameter display is the simplest correct approach because SSRS automatically maps query parameters to report parameters without extra configuration.
Question
Options
- AAdd a dataset to the report that uses an ad hoc SQL statement. Configure the dataset to include the parameters required for the different views. Add a dataset for each parameter created.
- BAdd a dataset to the report that uses an ad hoc SQL statement. Configure the dataset to include the parameters required for the different views. Update each parameter to use a set of values from Report Designer.
- CAdd a dataset to the report that uses an ad hoc SQL statement. Configure the dataset to include the parameters required for the different views. Use the default display for the parameters.
- DAdd a dataset to the report that uses a stored procedure. Configure the dataset to include the parameters required for the different views. Update each parameter to use a set of values from Report Designer.
How the community answered
(45 responses)- A24% (11)
- B11% (5)
- C58% (26)
- D7% (3)
Why each option
When adding an ad hoc SQL dataset with parameters in SSRS, using the default parameter display is the simplest correct approach because SSRS automatically maps query parameters to report parameters without extra configuration.
Adding a separate dataset for each parameter is redundant and unnecessarily complex, since a single parameterized dataset can handle multiple parameters simultaneously.
Manually updating each parameter with a set of values from Report Designer adds unnecessary configuration overhead when the default display already handles parameter detection correctly.
SSRS automatically detects parameters embedded in an ad hoc SQL query and creates corresponding report parameters using default display settings. This built-in behavior provides the filtering capability needed for different views without requiring manual value lists or additional datasets. It is the least complex solution that fully satisfies the requirement.
Using a stored procedure introduces additional database objects and deployment complexity that is not justified when a simple ad hoc query with default parameters achieves the same result.
Concept tested: SSRS report parameters with ad hoc SQL dataset defaults
Source: https://learn.microsoft.com/en-us/sql/reporting-services/report-data/report-parameters-report-builder-and-report-designer
Topics
Community Discussion
No community discussion yet for this question.