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
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
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
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
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
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
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
http://www.microsoft.com/downloads/details.aspx?FamilyID=d3173a87-7c0d-40cc-a408-3d1a43ae4e33&displaylang=en
Hope this will be helpful.
Thanks,
Nik
