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

image

New installation or add shared features

image

SQL Server Feature Installation

image

Reporting Services

image

Instance Configuration

image

Server Configuration

image

 

 

 

Start Reporting Services Configuration Manager

image

Choose Report Server Instance

image

Create a new report server database

image

Report Server Database Configuration Wizard

image

Report Server Mode > SharePoint Integrated Mode

image

Additional actions in Reporting Services Configuration Manager

Web Service URL > Apply

image

Report Manager URL > Apply

image

 

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

image

Activate Report Server Integration Feature and Report Server Central Administration Feature > Central Administration > Site Actions > Site Settings > Site Collection features

image

Configure Reporting Services Integration > Central Administration > General Application Settings > Reporting Services Integration

image

Reporting Services > Reporting Services Integration

image

Reporting Services > Set server defaults

image

 

Create a Report Library > Site Actions > More Options > Report Library

image

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)

image

 

Run click once deployment Report Builder 3.0 (78.2 MB)

image

Create you’re first report

image

 

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

image

Open report in Microsoft SharePoint 2010

image

Result full screen

image

Result as webpart

image

5 Comments

  1. Hello,
    It’s really nice blog about sharepoint 2010
    SharePoint is a fastest growing product and is implemented by over 18000 companies all over the world. It provides you various benefits
    Thanks

  2. Hi Roel,

    Thanks for sharing this. I implemented alike it without any problems. One thing: I did not understand why you created a second instance (Reporting2008) and later you create the database in the PowerPivot Instance. I used “Add features to an existing instance”, adding the Reporting Service to the PowerPivot instance and this works fine as well.

    Anyway it is the result that counts and thanks again!

    Groetjes, Frits

  3. Hi Roel,

    I have one big question I never found a clear ansewer: shall we setup SQL and SPT on the same server or on 2 different servers? In case of ‘two different servers’ where can I find a best proctice to do that (step-by-step guide)?

    wkr
    Beat

    Beat Gut
  4. Dear All,

    I would really appreciate if any one could guide me that – Does SharePoint Analysis services meaning one report building, i mean where does the OLAP and MOLAP come in?

    UsmanHak

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.