Microsoft
70-448 · Question #120
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…
The correct answer is B. You should create a dataset filter and include the appropriate limiting expression. See the full explanation below for the reasoning.
Question
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?
Options
- AYou should run the Database Engine Tuning Advisor tool in the database.
- BYou should create a dataset filter and include the appropriate limiting expression.
- CYou should create a Report Parameter dialog box and include the appropriate limiting expression.
- DYou should add an expression to the Visibility property and include the appropriate limiting expression.
How the community answered
(21 responses)- A5% (1)
- B81% (17)
- C5% (1)
- D10% (2)
Community Discussion
No community discussion yet for this question.