This topic has not yet been rated - Rate this topic

Server Properties (Execution Page)

SQL Server 2012

Use this page to set a timeout value for report execution. This value applies to all reports that are processed by the current report server instance. You can override this value for individual reports. The value you specify must accommodate all report processing that occurs on the report server, plus query processing performed on the database server when the report server retrieves data that is used in the report.

To open this page, start SQL Server Management Studio, connect to a report server instance, right-click the report server name, and select Properties. Click Execution to open this page.

Options

Do not timeout report execution: Allow a report server unlimited time to complete report processing.
Limit report execution to the following number of seconds: Set a time constraint on report execution. The time period starts when the report is requested. If the time period ends before the report is fully processed, the report server cancels the process and any in-process queries to external data sources.

Tasks

Set Report Server Properties (Management Studio)

Connect to a Report Server in Management Studio

Reference

Report Server in Management Studio F1 Help

Concepts

Set Report Processing Properties

Setting Time-out Values for Report and Shared Dataset Processing (SSRS)

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD