Reporting Services

Refer the Source Video: 

A server based reporting.
Report are developed 
-in Report Builder  -in Visual Studio -in SQL Server Data Tools(SSDT) -by hand-writing XML

Report Services report 
-..stored in a SQL Server Database Engine - a .rdl file - embedded into .NET applns. 
- integrated with SharePoint

Report Delivery
- to email,mobile devices, & browers -via SSRS web service -on a schedule
 -.when the data changes

SSRS 2012: - Standard version 
-free version in Express Edition (SQLServerExpresswithAdvancedServices)

Architecture of  SQL Server 2012:Reporting Services
-SSRS  can be from small to Big organization -3rd Part companies - provide more look,feel etc..

There  3 components: 
-client ( one requesting the report) - report server ( who you request to)    .SSRS
-data (SQL Server , Oracle, DB2 etc.)
(If you have OLE DB or ODBC provider to get data, even 3rd party ,so any source can get data)

Client -> SSRS (Server) -> Report A ( 3 different sources[sql server relational,Dashboard,Oracle)
.pdf,excel format

Traditional client -server -client request (via a url) of the report server

http://myreportserver.learnitfirst.com/ReportA.rdl

-Server receives that

Report Server make request to Data Source ( still its client-server)

 - client is the report server - server (Data Source)

Report author/administrator can specify how to authenticate to the data source 

windows authentication, sql server authentication.

All client request to report server are made via URL

-users working with applications links to report

-SSRS has the own web server( do not need to install IIS web server to it)

note:nice change in 2008 that with reporting server the web server is installed

Report Server - does more than just connecting to the data source & creating report

- manages secure access to the reports,can schedule delivery, can render report in multiple way etc.