Describe SQL Server Reporting Services lifecycle.The phases of the Reporting Life Cycle involve:
This stage involves creation of reports that are published using the Report Definition language. RDL is an XML based industry standard for defining reports.
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.
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.
It is important to protect reports as well as the report resources. Therefore, Reporting Services implement a flexible, role-based security model.