Describe SQL Server Reporting Services lifecycle

Answer 1

The phases of the Reporting Life Cycle involve:

Report authoring
------------------------
This stage involves creation of reports that are published using the Report Definition language. RDL is an XML based industry standard for defining reports.

Report management
-----------------------------
This involves managing the published reports as a part of the webservice. The reports are chched for consistency and performance. They can be executed whenever demanded or can be scheduled and executed.

In short Report Management includes:
- Organizing reports and data sources,
- Scheduling report execution and delivery, and
- Tracking reporting history.

Report delivery
---------------------
Reports can be delivered to the consumers either on their demand or based on an event. Then they can view them is a web-based format.

Report security
---------------------
It is important to protect reports as well as the report resources. Therefore, Reporting Services implement a flexible, role-based security model.