You are designing a Microsoft SQL Server 2005 Reporting Services (SSRS) report. The report uses a dataset that calls a Microsoft SQL Server stored procedure. The stored procedure requires three input parameters that cannot be Null.
The report must meet the following requirements when it runs:
Each of the stored procedure input parameters must be used. All parameter values must be selected from the drop-down lists. Only valid values must be used for input parameters.
You need to set the Report Parameters dialog box configurations to meet the outlined requirements.
Which three tasks should you perform? (Each correct answer presents part of the solution.
Choose three.)
A.
For each input parameter, ensure that the Internal check box is selected in the Report Parameters dialog box.
B.
For each input parameter, ensure that the Default Values property is set to Null in the Report Parameters dialog box.
C.
Add a dataset to the report that has fields that map to the valid values for each of the input parameters of the existing dataset.
D.
Add a TextBox item to the report for each of the stored procedure parameters. Set the Value property to an appropriate field in the dataset.
E.
Add a List item to the report for each of the stored procedure parameters. Set the DataSet property to a dataset that contains the valid values for the parameter.
F.
For each input parameter, ensure that the Available Values property is set to From Query. Ensure that a valid field is specified in the Value field of the Report Parameters dialog box.