You are creating a SQL Server 2008 Reporting Services (SSRS) package which includes a parameter named @ProductID for Company.com.
Through choosing a specific region you should configure the value of the @ ProductID parameter in the report.
You should make sure that you set the report to prevent users from changing the value of the @ ProductID parameter.
Which is the correct answer?
A.
You should set the Prompt value null.
B.
You should modify the Hidden property.
C.
You should configure the internal property.
D.
You should update the biggest values.
Explanation:
Report parameters are defined globally for the report. Report parameters are created automatically if the report query includes parameters, or they can be created manually. After a report parameter is created, you must set properties that identify it and that control how it is used in the report.Report parameters are automatically created for query parameters when a dataset query is saved, or you can create a report parameter manually. After you create a report parameter, you may need to adjust the default values for report parameter properties to get the functionality you want. For example, you may need to change the data type, create a dataset to provide an available values list, create a dataset to for default values, or set whether the values can be blank or null.
Hidden and Internal Parameters
You can set options that control parameter visibility in the published report. Setting the Hidden and Internal options provides different levels of visibility. You can hide the parameter on the parameter input area of the published report, yet set values for it on a report URL or in a subscription definition.
If you set a parameter to Internal, it is not exposed in any way except in the report definition. An internal parameter must have a default value, which can be null if the Allow null value option has been selected.