You create a SQL Server 2008 Reporting Services (SSRS) report that contains a dataset.
The dataset retrieves data by executing a stored procedure. The report contains a table and
a matrix that use the dataset.
You need to limit data that is displayed in the table while ensuring that the matrix is
unaffected.
What should you do?
A.
Add a filter to the dataset.
B.
Add a filter to the matrix.
C.
Add a filter to the table.
D.
Add a parameter to the stored procedure that filters the result set.
Explanation: