1.

What are the various stages involved in Report Processing in the context of SQL Server Reporting Services (SSRS)?

Answer»

We specify a report definition file (.rdl) in XML format when we GENERATE a report. This file contains all of the information REQUIRED by the report processor to merge report data and layout. When we view a report, it GOES through the stages listed below:

  • Compile: Evaluate report definition expressions and STORE the produced intermediate format on the report server.
  • Process: Execute dataset queries and mix intermediate format with data and layout to create a finished product.
  • Render: Send the paged report to a RENDERER extension to assess how much information fits on each page.
  • Export (optional): We can save the report in various different formats such as a doc file or a pdf.


Discussion

No Comment Found