This post is a follow-up on my previous posts about the new SQL 2012 Business Intelligence Features in SharePoint 2010 using SQL 2012 and SQL 2008 R2
Previous posts about Reporting Services and SharePoint Integration:
How to: Install Reporting Services SharePoint 2010 mode using SQL 2012
SharePoint 2010 SSRS News(Reporting Services) using SQL 2012
How to: Deploy an SSRS Report to a SharePoint 2010 SSRS Integrated Farm
How to: Integrate SharePoint 2010 and Reporting Services 2008 R2
In this post, i’ll try to summarize all the things you need to know about SQL 2012 and SharePoint 2010.
Reporting Services comes in two modes:
Reportings Services implemented as a Service Application and managed through Central Administration
SharePoint Mode can be configured either in “Local Mode” or “Connected Mode”. In “Local Mode” there’s no need for a report server and all reports are rendered in sharepoint document libraries. In “Connected Mode”, your reporting solution can include the features of Reporting Services like subscriptions, snapshots etc.
In SharePoint Mode:
You’ll have the “Power View” feature
You deploy reports to sharepoint document libraries
You start Report Builder from a document library
You manage all the features like subscription, snapshot, data sources, data sets etc. from the report file(.rdl) in a sharepoint document library
You’ll have the new data alert feature
All the logging and management is centralized throug SharePoint Central Administration and the logging is written to the SharePoint ULS logs.
Read more on MSDN:
Reporting Services Report Server (SharePoint Mode)
Reporting Services is a stand-alone application server that provides all processing and management of the service and has nothing to do with SharePoint
Read more on Technet: