SharePoint and SSRS Integration Options

There are several versions of the SharePoint (MOSS 2007 and SharePoint 2010) and several versions of SSRS (SQL 2000 SP2, SQL 2005, SQL 2008, SQL 2008 R2) released so far. Because of these different versions of SharePoint can integrate different versions of the SSRS different ways, this post will provide the different downloads required for different kind of integration.
 
Native Mode Integration:
 
MOSS 2007 RTM/SharePoint 2010 RTM Native Mode Integration with the SSRS 2000 Sp2/SSRS 2005 RTM/SSRS 2008 RTM/SSRS 2008 R2 RTM using SharePoint 2.0 Web Parts
http://msdn.microsoft.com/en-us/library/ms159772.aspx
 
Integrated Mode Integration:
 
Report Server SharePoint Version Add-in Supported?
SSRS 2005 SP2 MOSS 2007 RTM SQL Server 2005 Yes
SSRS  2005 SP3 CU3 SharePoint 2010 RTM ?? ??
SSRS  2008 RTM MOSS 2007 RTM SQL Server 2008 Yes
SSRS  2008 SP1 CU2 SharePoint 2010 RTM SQL Server 2008 No
SSRS  2008 SP1 CU8 SharePoint 2010 RTM SQL Server 2008 R2 Yes
SSRS  2008 R2 RTM MOSS 2007 RTM SQL Server 2008 SP2 Yes
SSRS  2008 R2 RTM SharePoint 2010 RTM SQL Server 2008 R2 Yes
 
MOSS 2007 RTM and SSRS 2005 Sp2 Integrated Mode – Microsoft SQL Server 2005 Reporting Services Add-in for Microsoft SharePoint Technologies
http://www.microsoft.com/downloads/details.aspx?familyid=1E53F882-0C16-4847-B331-132274AE8C84&displaylang=en
 
MOSS 2007 RTM and SSRS 2008 RTM Integrated Mode – Microsoft SQL Server 2008 Reporting Services Add-in for Microsoft SharePoint Technologies, April 2009
http://www.microsoft.com/downloads/details.aspx?FamilyID=58edd0e4-255b-4361-bd1e-e530d5aab78f&displaylang=en
 
MOSS 2007 RTM and SSRS 2008 R2 RTM Integrated Mode – Microsoft SQL Server 2008 Reporting Services Add-in for Microsoft SharePoint Technologies SP2. It will not release until Sep 2010. At this moment, this integration is available through Microsoft SQL Server 2008 November CTP Report Services Add-in for Microsoft SharePoint Technologies 2007.
http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=44bda62c-0cda-4a99-8d0a-d7fe06b39422
 
SharePoint 2010 RTM and SSRS 2008 SP1 CU8/SSRS 2008 R2 RTM Integrated Mode (official name is connected mode for SharePoint 2010-SSRS integration) – Microsoft SQL Server 2008 R2 Reporting Services Add-in for Microsoft SharePoint Technologies 2010
http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=b3bebf9d-d86d-48cd-94e2-0639a846be80
 
Report Builder Download Links:
 
Microsoft SQL Server 2008 Reporting Services Report Builder 2.0, April 2009 – Also released with the SQL Server 2008 SP1
http://www.microsoft.com/downloads/details.aspx?familyid=DBDDC9B6-6E19-4D4B-9309-13F62901B0D5&displaylang=en
 
Microsoft SQL Server 2008 R2 Report Builder 3.0 – Also released with the SQL Server 2008 R2
http://www.microsoft.com/downloads/details.aspx?FamilyID=d3173a87-7c0d-40cc-a408-3d1a43ae4e33&displaylang=en
 
Hope this will be helpful.
Thanks,
Nik
Advertisements
This entry was posted in SP2010 & SSRS. Bookmark the permalink.

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s