Installing the Reporting Services Add-In for SharePoint
In addition to getting Reporting Services set up and configured for SharePoint Integrated mode, the Reporting Services Add-In for SharePoint needs to be installed and configured. The add-in is a SharePoint Feature that provides the infrastructure to seamlessly integrate Reporting Services within SharePoint. Beginning with SharePoint 2010, the Reporting Services Add-In for SharePoint is included in the software prerequisites for SharePoint, as shown in Figure 3.3.
Figure 3.3 Microsoft SharePoint 2010 Products Preparation tool.
You can install any of the necessary software prerequisites by selecting Install Software Prerequisites from the SharePoint 2010 setup. The Reporting Services Add-In for SharePoint is also available as a separate download from the Microsoft website. (Just search for SQL Server 2008 R2 Feature Pack). Note that the version of the Reporting Services Add-In for SharePoint is based on both the version of SQL Server and the version of SharePoint. There are versions of the add-in for SQL Server 2005, SQL Server 2008, and SQL Server 2008 R2, and versions for SharePoint 2007 and SharePoint 2010.
After installing the Reporting Services Add-In for SharePoint, you see the Report Server Integration Feature in the Site Collection Features gallery.