SQL Server Reporting Services Question:
Download Job Interview Questions and Answers PDF
Describe Reporting Lifecycle?
Answer:
The Reporting Lifecycle includes
- Report designing – The designing is done in Visual Studio Report Designer. It generates a class which embodies the Report Definition.
- Report processing – The processing includes binging the report definition with data from the report data source. It performs on all grouping, sorting and filtering calculations. The expressions are evaluated except the page header, footer and section items. Later it fires the Binding event and Bound event. As a result of the processing, it produces Report Instance. Report instance may be persisted and stored which can be rendered at a later point of time.
- Report Rendering: Report rendering starts by passing the Report Instance to a specific rendering extension (HTML or PDF formats). The instance of reports is paged if paging supported by output format. The expressions of items are evaluated in the page header and footer sections for every page. As a final step, the report is rendered to the specific output document.
- Report designing – The designing is done in Visual Studio Report Designer. It generates a class which embodies the Report Definition.
- Report processing – The processing includes binging the report definition with data from the report data source. It performs on all grouping, sorting and filtering calculations. The expressions are evaluated except the page header, footer and section items. Later it fires the Binding event and Bound event. As a result of the processing, it produces Report Instance. Report instance may be persisted and stored which can be rendered at a later point of time.
- Report Rendering: Report rendering starts by passing the Report Instance to a specific rendering extension (HTML or PDF formats). The instance of reports is paged if paging supported by output format. The expressions of items are evaluated in the page header and footer sections for every page. As a final step, the report is rendered to the specific output document.
Download SSRS Interview Questions And Answers
PDF
| Previous Question | Next Question |
| Explain the architecture of reporting services? | What are the ways to tune Reporting Services? |