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.