Report Processing Overview

[This topic is pre-release documentation and is subject to change in future releases. Blank topics are included as placeholders.]

Report execution refers to processing that takes place when a user or the report server accesses a report. During report execution, the report server processes a report in three stages: report processing, data processing, and rendering.

Report processing begins with a published report definition. A report definition contains one or more queries, layout information, and code references or expressions. Report and data processing combine a resulting dataset with layout information in the report definition to construct a report in an intermediate format that can be saved for fast retrieval, or directed to a rendering extension that processes it into a format that the user sees. After processing is complete, reports are compiled as a common language runtime assembly and executed on the report server. The report server can use the intermediate format in a variety of ways. Caching, snapshots, and report history are all features that use reports stored in intermediate format.

When a report is accessed, either through on-demand or push access, the report server either performs end-to-end processing, or returns a report saved in intermediate format that is subsequently rendered in a specific format. Report execution settings determine which outcome occurs. If a report server administrator specifies that a report be accessed from cache or as a snapshot, the intermediate format is retrieved from the report server database and then rendered for viewing. Otherwise, all stages of processing are performed.

The following diagram shows the progression of a report as it moves through different processing phases. Data and report processing are performed on a report definition, resulting in a report that is in the intermediate format. Reports that are in intermediate format are subsequently rendered to a specific viewing format.

Report processing diagram

report processing diagram

Note

Report processing is not supported in SQL Server 2005 Express Edition with Advanced Services. For more information about features in this edition, see Reporting Services in SQL Server 2005 Express Edition with Advanced Services.

See Also

Concepts

Report Manager

Other Resources

Monitoring Report Server Performance
Configuring a Report Server Installation
Deployment (Reporting Services)
Administration (Reporting Services)
Starting and Stopping the Report Server Windows Service

Help and Information

Getting SQL Server 'Katmai' Assistance