Sharepoint 2010 Integration with SSRS 2008R2:
As Sharepoint 2010 is one stop environment which can be useful for all enterprise needs, Sharepoint come up with a tight integration with SSRS 2008R2 which can host the SSRS reports directly in Sharepoint rather deploying them to reporting server.
Advantages of Sharepoint integrated mode for SSRS.
- Publishing, Viewing Dashboards, Management and delivery of reports through Sharepoint user interface.
- Leverage Sharepoint Collaboration and work flow capabilities with rich reporting experience.
- Shared security principles across SSRS and Sharepoint.
- Minimize the resource usage by eliminating separate reporting server.
Architecture:
Following image shows the integration between Sharepoint and SSRS.
When you open a report from a SharePoint site, the Report Server endpoint connects to a report server, creates a session, prepares the report for processing, retrieves data, merges the report into the report layout, and displays it in the Report Viewer Web part.
The report server synchronizes operations and data with SharePoint and tracks information about the files it processes. When you modify properties or settings for any report server item, the change is stored in a SharePoint database.
Components that provides the integration:
To combine the servers in a single deployment, you integrate an installation of SQL Server Reporting Services with an instance of SharePoint products.
On SharePoint side, it provides the Reporting Services Add-in provides the Report Server proxy endpoint, a Report Viewer Web part, and application pages so that you can view, store, and manage report server content on a SharePoint site or farm.
On Reporting Services side, it provides updated program files, a SOAP endpoint, and custom security and delivery extensions. The report server must be configured to run in SharePoint integrated mode, dedicated exclusively to supporting report access and delivery through your SharePoint site.
After you install the Reporting Services Add-in on SharePoint and configure the two servers for integration, you can upload or publish report server content types to a SharePoint library, and then view and manage those documents from a SharePoint site. Uploading or publishing report server content is an important first step; the Web Part and pages become available when you select report definitions (.rdl), report models (.smdl) and shared data sources (.rsds) on a SharePoint site.
Supported and unsupported features SharePoint add-in and Report Server :
Not all features are supported in all combinations of report server, Reporting Services add-in for SharePoint, and SharePoint Products. The recommended and most complete combination is to use SharePoint 2010 Products, the SQL Server 2008 R2 Reporting Services add-in for SharePoint 2010 Products, and SQL Server 2008 R2 report server in SharePoint Integrated mode.Here is the link which provides the supported ans un supported features of SharePoint add-in and Report Server.
