SQL Server Reporting Services Integration with SharePoint

Written By: Abin Jaik Antony -- 10/20/2010 -- join -- contribute -- (4877) comments -- printer friendly version

Rating: Rate --

Categories: Configurations, Integration with other products , MOSS 2007, WSS3

< Prev - 1 | 2 | 3 | 4 | - Next > | Become a paid author


The scope of this tip is to explain the architecture, configuration & deployment of SSRS in SharePoint integration Mode.


Before going directly into the configuration, we can have a look into the architecture . This will help us to understand it deeply.

SSRS architecture in Native Mode and in SharePoint integration Mode.

The SQL Servers Reporting Services architecture have mainly 3 parts /layers

  • Data Layer
  • Application Layer
  • Client Layer

The Data layer consists of the Base Data Sources like data warehouse / transactional DB / Analysis Services Cube , Report Server Databases etc.

The Application layer consists of Reporting Services, Report Manager , Web Services etc.

The Client Layer can be any front end like SharePoint web parts or other front end tools.

After the deployment of reports from BIDS (Business Intelligence Development Studio) , the .rdl (report definition language) files and the shared data sources will be stored inside Report Server database. On the request for any report from a Client , the request passes to the Report Manager and is processed within Report Services from the fetched data of Data Sources. The generated report is returned to the Client from the Application Server as HTML/XML/PDF.

Basically there are two modes for configuring SSRS.

  1.  Native Mode
  2.  SharePoint Integration Mode.

The outline architecture for Native Mode is explained above. This article will review SharePoint integrated mode's configuration , architecture & deployment.

Before configuring the Report Server in SharePoint Integration Mode ,let's make sure that server is installed with the Report Services Add – in  (on the SharePoint Server) and SQL Server SP2 (on database the server).

In SharePoint Integrated mode, the architecture is a little different from Native mode. The reports definition files and Data Sources are stored in the SharePoint Content database Also, there is no concept of “Report Manager” in SharePoint Integrated mode since it is deployed to the SharePoint Reports Library. Security trimming for reports is handled using standard SharePoint permisions.

In SharePoint Integrated mode, when a user makes a request for a particular report, the Report Server Proxy Endpoint will take care of the report processing from SharePoint along with Report Services to return the rendered result.

< Prev - 1 | 2 | 3 | 4 | - Next >

Learn more about SharePoint

Sponsor Information

Copyright (c) 2010-2017 Edgewood Solutions, LLC All rights reserved
privacy | disclaimer | copyright | advertise | contribute | feedback | about
Some names and products listed are the registered trademarks of their respective owners. |