What should you do?

You are designing a Microsoft SQL Server 2005 Reporting Services (SSRS) report. 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?

You are designing a Microsoft SQL Server 2005 Reporting Services (SSRS) report. 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.
Run the Database Engine Tuning Advisor tool in the database.

B.
Create a dataset filter and include the appropriate limiting expression.

C.
Create a Report Parameter dialog box and include the appropriate limiting expression.

D.
Add an expression to the Visibility property and include the appropriate limiting expression.



Leave a Reply 0

Your email address will not be published. Required fields are marked *