You are developing a SQL Server 2008 Reporting Services (SSRS) report for Company.com.
The source of the SSRS report data is a Transact-SQL stored procedure.
The procedure does not have any input parameters and returns all records in a set of tables. Three other applications that run on Microsoft SQL Server also use the stored procedure.
You need to limit the amount of data that is displayed on the report without affecting any other applications that use the stored procedure.
What should you do?
A.
You should run the Database Engine Tuning Advisor tool in the database.
B.
You should create a dataset filter and include the appropriate limiting expression.
C.
You should create a Report Parameter dialog box and include the appropriate limiting expression.
D.
You should add an expression to the Visibility property and include the appropriate limiting expression.