Installing SSRS 2008 R2 on SharePoint 2010

After installing PowerPivot on SharePoint 2010 thanks to the excelent guid of VidasM i decided to try and install report services 2008 R2.

To start I downloaded the SQL Server® 2008 R2 November CTP Reporting Services Add-in for Microsoft SharePoint® Technologies 2010 and followed the instructions there:

Step 1: Install a SharePoint technology instance. (Already did this when installing PowerPivot with SharePoint)

Step 2: Install SQL Server 2008 R2 November CTP Reporting Services and specify that the report server use SharePoint Integrated mode.

Step 3: Configure Reporting Services.

Step 4: Download the Reporting Services Add-in by clicking the rsSharePoint.msi link later on this page. To start the installation immediately, click Run.

After installing Reporting services and the add-in your reporting server is ready to be integrated with SharePoint, in SharePoint 2010 we have some new admin screens.

To integrate go to central admin, general application settings:

When you successfully installed the add-in a reporting services icon will be there. Click Reporting Services Integration:

Add the report server web service url (To get the URL, open the Reporting Services Configuration tool, connect to the report server, and click Web Service URL. Click the URL to verify it works. Copy the URL and paste it into Report Server Web Service URL.), select your authentication mode (windows authentication is prefered). Add a username and password of your admin account. Click ok to configure and start the integration.

After the installation you can set the reporting services default.

What is changed in SP2010 is that there isn’t a report library available. You have to add content types to a default library. So go to a site collection, site actions,  View all site content.

Create a Asset library:

Now we have to make sure we can add reports to the library. To do this we have to add content types:

Open the library, click on library tools, library settings, Under Content Types, click Add from existing site content types. In the Select Content Types section, in Select site content types from, click the arrow to select Reporting Services. In the Available Site Content Types list, click Report Builder, Report Data Source and Report and then click Add to move the selected content type to the Content types to add list.

Now we are ready to upload reports and execute them from within our webparts:

More reading about this on BOL:

How to: Configure Report Server Integration in SharePoint Central Administration

How to: Add Report Server Content Types to a Library (Reporting Services in SharePoint Integrated Mode)

  • sgf

    Thanks for the writeup. I couldn’t find any other posting that noted there is no longer a report or datasource library

  • Report Library is still available in SharePoint 2010, but you have to enable the “SharePoint Server Enterprise Site features” on the site collection and site where you want to create a Report Library. Personally, I think the Asset Library is not suited for Reporting Services reports, although you might have the same doubt about the Report Library which also is not primarily meant for Reporting Services reports.

    • Kasper de Jonge

      Hi Hans,

      Yes thanks, i have seen a report library as well but wasn’t sure when it would appear as an option. Strange thing is you cannot create a report library in a PowerPivot site collection. Will have to investigate some more.

      Kasper

  • ranjani

    Hi Kasper,

    Nice post. I have a doubt . I deployed my report to a report library but i want the report in the library to be autorefreshed in specific duration of time . eg 2 days once need to check for the updates . Please let me know whether this can be achieved.

    Thanks in advance

    Regards,
    Ranjani