Microsoft SQL Server Reporting Services is a poweful server-based reporting solution that supports the full report life cycle. 
As part of the Microsoft Business Intelligence framework, Reporting Services combines the data management capabilities of SQL Server with the familiar and powerful Microsoft Office System applications to deliver real-time information to support daily operations and drive decisions.

Reporting Life Cycle

• Report authoring
• Reports can be authored by Report developers by using familiar development toolsets such as Visual Studio
• End Users can author reports by utilising the Report Models to create powerful ad-hoc reports 
• Report Management
• Report definitions, folders, and resources are published and managed as a Web service. Managed reports can be executed either on demand or on a specified schedule, and are cached for consistency and performance.
• Report Delivery
• SQL Server Reporting Services supports both on-demand (pull) and event-based (push) delivery of reports. Users can view reports in a Web-based format or as saved document types (Excel, PDF, .CSV).
• Report Security
• SQL Server Reporting Services implements a flexible, role-based security model to protect reports and reporting resources.