SharePoint By Bugday

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:

SharePoint Mode:

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)

Native 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:
http://technet.microsoft.com/en-us/library/bb522825.aspx