Instructions for the installation and configuration of Reporting Services in SharePoint Integration Mode
Use this document to install and configure Reporting Services in SharePoint Integrated mode. You can then use Report Builder to create reports using PowerPivot workbooks that you have been published to a PowerPivot Gallery as data sources. After installation, you can design reports by entering the URL of the PowerPivot workbook as the “Server:” in your Report Builder or Report Designer data source. The underlying PowerPivot infrastructure will make the appropriate connection to the embedded PowerPivot database residing within the workbook.
Important: Regardless of your PowerPivot installation (either NEW FARM or EXISTING FARM), perform these steps after you have installed PowerPivot.