You are designing a Microsoft SQL Server 2005 Reporting Services (SSRS) report.
The query that builds the dataset for the report uses a WHERE clause to filter the rows.
The report parameter must perform the following actions:
Use the new parameterized query.Run without any user input.Allow users to change the value that is passed to the query by selecting a value from a drop-down list.
You need to modify the settings of the Report Properties dialog box to meet the outlined requirements.
Which four tasks should you perform? (Each correct answer presents part of the solution. Choose four.)
A.
Ensure that the Internal check box is selected.
B.
Ensure that the Default values property value is set to Null.
C.
Ensure that the Prompt property is set to an appropriate value.
D.
Ensure that the Data type property is set to an appropriate value.
E.
Ensure that the Default values property value is set to Non-queried by using an appropriate default value.
F.
Ensure that the Available values property value is set to Non-queried by using the appropriate labels and values.