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.
You use SSRS to design a report with a dataset contained. Besides, the dataset uses a stored procedure to regain data resources.
With the use of the dataset, a table and a matrix are contained in the report.
Now you are assigned a task to limit the data displayed in the table without affecting the data displayed in the matrix.
What action should you perform to accomplish this task?
A.
A filter should be added to the table
B.
A parameter should be added to the stored procedure with the result set filtered
C.
A filter should be added to the stored procedure.
D.
A filter should be added to the dataset
E.
A filter should be added to the matrix