You are a database developer and you have about two years experience in creating
business intelligence (BI) solutions by using SQL Server2008.
Now you are employed in a company which is named NaproStar and work as a developer of
a SQL Server
2008 Reporting Services (SSRS) for the company.
To meet the business requirement, you develop a SSRS report with a parameter named
@ProductPriceRangeID.
Then you select a specific region to set the value of @ProductPriceRangeID in the report.
In order to stop modifying the value of @ProductPriceRangeID, you have to configure the
report.
So of the methods below, which one would be used to configure the report?
A.
Set the Internal property to configure the report
B.
Remove the default values to configure the report
C.
Clear the Hidden property to configure the report
D.
Clear the Prompt value to configure the report.
E.
Set the Hidden property to configure the report
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 parameterproperties 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.