These are the steps I followed to install a development Microsoft SharePoint 2010 server with PowerPivot and Reporting Services integration.
I installed Microsoft SharePoint Server 2010 by following the steps on:
Then I followed the steps on: http://technet.microsoft.com/en-us/library/bb326356(SQL.105).aspx and http://msdn.microsoft.com/en-us/library/aa905871(SQL.105).aspx to enable Microsoft SQL Server 2008 R2 Reporting Services integration for Microsoft SharePoint Server 2010.
After following these steps, I was able to publish PowerPivot excel reports and Microsoft SQL Server 2008 R2 Reporting Services reports to one top level site collection on Microsoft SharePoint Server 2010. See screen dumps:
Start Microsoft SQL Server 2008 R2 setup > Installation > New installation or add features to an existing installation
New installation or add shared features
SQL Server Feature Installation
Start Reporting Services Configuration Manager
Choose Report Server Instance
Create a new report server database
Report Server Database Configuration Wizard
Report Server Mode > SharePoint Integrated Mode
Additional actions in Reporting Services Configuration Manager
Web Service URL > Apply
Report Manager URL > Apply
The SharePoint 2010 pre-requisite installer now automatically guides you to download and install the Reporting Services 2008 R2 for SharePoint 2010 Add-in. Btw, you can download the Reporting Services add-in manually as well. In most cases you can just activate the Report Server Feature in SharePoint Central Administration (http://technet.microsoft.com/en-us/library/bb677366(SQL.105).aspx). In some case you must first download and install the add-in manually, in my case I re-configured the Reporting Services 2008 R2 for SharePoint 2010 Add-in and then activated the Report Server feature on the Central Administration site.
Reconfigure the Microsoft SQL Server 2008 R2 Reporting Services Add-in > Start > Control Panel > Programs and Features > Right click SQL 2008 R2 Reporting Services SharePoint 2010 Add-in > Configure
Activate Report Server Integration Feature and Report Server Central Administration Feature > Central Administration > Site Actions > Site Settings > Site Collection features
Configure Reporting Services Integration > Central Administration > General Application Settings > Reporting Services Integration
Reporting Services > Reporting Services Integration
Reporting Services > Set server defaults
Create a Report Library > Site Actions > More Options > Report Library
Enable Report Server Content Types
Create a Report > Report Library > Documents > New Report Builder Report (Click once deployment Report Builder 3.0 should start)
Run click once deployment Report Builder 3.0 (78.2 MB)
Create you’re first report
The Microsoft SQL Server 2008 R2 sample databases can be found at: http://sqlserversamples.codeplex.com/ (82.5 MB). At this moment the November CTP sample database are the last version. RTM sample database should be released soon.
Save the report to SharePoint 2010
Open report in Microsoft SharePoint 2010
Result full screen
Result as webpart