Home > Articles > Data > SQL Server

  • Print
  • + Share This
This chapter is from the book

Report Processor

The Report Processor ties components of a report server together and takes care of caching within SSRS. Caching refers to an ability of the SSRS to keep a copy of a processed report and return that copy when a user opens the report. Caching can shorten the time required to retrieve a report, especially if the report is large or is accessed frequently. All report caches are stored in the SSRS catalog (specifically ReportServerTempDB database) and survive both SQL Server and Report Server restarts.

Report Processor performs the following operations:

  • Execution— Retrieves a report definition and combines it with data retrieved by the data-processing extension. This operation generates an intermediate format.
  • Rendering— Renders the intermediate format to a requested output format using rendering extensions.
  • Processing of models— This is similar to Execution operation for reports that are generated by Report Builder and contain a semantic model (or simply a model, which serves as a data source for a report) and a semantic query. Semantic query refers to a query performed against a model that, in turn, just like a SQL query, generates a report's data set.

This is how Report Processor responds to users' requests:

  • New interactive report request— Intermediate format is generated and passed to the rendering extension; user receives rendered report.
  • Request to generate cache or snapshot— Intermediate format is generated and stored in the database.
  • Request for cached report or snapshot— Intermediate format is retrieved from cache (or snapshot) and passed to the rendering extension; user receives rendered report.
  • + Share This
  • 🔖 Save To Your Account