Knowledgebase

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:

http://powerpivot-info.com/post/66-step-by-step-guide-on-installing-powerpivot-for-sharepoint

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

Reporting Services

Instance Configuration

Server Configuration

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

http://technet.microsoft.com/en-us/library/bb326289(SQL.105).aspx

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