What should you do?

You are designing a Microsoft SQL Server 2005 Reporting Services (SSRS) report. The report dataset consists of a WHERE clause: WHERE machineID IN (@machineID). The values in the machineID column change constantly. When the report is run, users must be prompted to use a list of valid values for the @machineID parameter. When the report is run, a list of valid values for the @machineID parameter must be made available to populate the @machineID dataset parameter. You need to create a Multi-value report parameter that will meet the requirement. What should you do?

You are designing a Microsoft SQL Server 2005 Reporting Services (SSRS) report. The report dataset consists of a WHERE clause: WHERE machineID IN (@machineID). The values in the machineID column change constantly. When the report is run, users must be prompted to use a list of valid values for the @machineID parameter. When the report is run, a list of valid values for the @machineID parameter must be made available to populate the @machineID dataset parameter. You need to create a Multi-value report parameter that will meet the requirement. What should you do?

A.
Select an appropriate default value from a dataset query.

B.
Select an appropriate available value from a dataset query.

C.
Select the Internal check box, and then select an appropriate default value from a dataset query.

D.
Select the Internal check box, and then select an appropriate available value from a dataset query.



Leave a Reply 0

Your email address will not be published. Required fields are marked *