You create a SQL Server 2008 Reporting Services (SSRS) report. The report is hosted in a
SharePoint environment.
The UserID is passed into the report automatically when the user views the report. The
UserID will be used to link to other pages on the SharePoint site via url.
You need to prevent the user from seeing their UserID
What should you do?
A.
Create a distinct dataset that includes all possible values and attach it to the parameter.
B.
Create a dynamic dataset that utilizes the WHERE clause to filter by the parameter.
C.
Create a dynamic data source from a dataset by using the IN operator.
D.
Configure the Internal Visibility option for the parameter.
E.
Change the dataset from a shared dataset to an embedded dataset in the report.
F.
Create a dynamic data source from a dataset that includes a list of distinct servers.
G.
Create a dynamic dataset that includes a list of the different users.
H.
Configure the Hidden Visibility property.
Explanation: