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 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.