Share this page

Sunday, February 7, 2010

Installing Reporting Service Integration mode with SharePoint 2010

In this post I want to share how install and configure reporting services with SharePoint 2010. The first thing to know is that we need SQL Server 2008 November CTP because is the only version that works fine with SharePoint 2010.

Install SQL Server 2008 R2 November CTP

1) Download here the version of SQL Server 2008 R2

2) Run the setup.exe and install the database engine and Reporting Services

3) In the wizard installation in the section of reporting services select the integration mode with SharePoint. If you only have the last option available you would configure later using the tool the SQL to configure Reporting Service, as we can see in Image 1.

4) Download Add-In for SharePoint 2010 of Reporting Services November CTP here.

5) Install the Add-In of Reporting Services November CTP for SQL Server 2008 R2 November CTP as we can see in image 2.

[Image 1]
1_ReportingServices

[Image 2]
2_ReportingServicesSharepoint

Now we are going to configure Reporting Services on central administration of SharePoint 2010. In the central administration select “General Application Settings” as we can see in the image3.

[Image 3]
3_Genereal_Application_Settings

In this configuration section you find a new section installed as we can see in Image 4. In this section we will configure the options of Reporting Services.

[Image 4]
4_Reporting_Services_Integration

The first step is to configure the integration mode with SharePoint then we are going to select the link “Reporting Services Integration” as we can see in image 4. When selected this link a new page will be load as we can see in image 5.

[Image 5]
5_Configuring_Integration_Mode

In this section we need configure the options with the values of our reporting services instance, as we can see in the image 5. The options that we need to load are:

1) Report Server Web Service URL: Needed load the URL configured in the reporting services tool configuration (Image 1).
2) Authentication Mode: I’m using Trusted Account because I have one server in the farm.
3) Credentials: You need set an account of group of administrator to have access to the report server.
4) Active the Reporting Services Feature: Here you need set how you want active the feature in the site collections created. In my example I’m activating in all site collections created in my server.

Once the option was configured we are going to press the button “Ok” to confirm our configuration. The process is starting and when finish we can see a confirmation page as we can see in Image 6.

[Image 6]
6_Configuring_Sharepoint_2010_Completed

The last configuration that we must do is enabled a tag in a XML configuration file of ours reporting services instance. Open the file named “reportserver.config” saved in the following path “C:\Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\ReportServer” on the server. In the section 1 we can see the original tag named “ADS” and how must be after our change.

[Section 1]

Original:
<!-- <Extension Name="ADS" Type="Microsoft.Office.Access.Reports.DataProcessing.AdsConnection, Microsoft.Office.Access.Server.DataServer, Version=14.0.0.0, Culture=Neutral, PublicKeyToken=71e9bce111e9429c"/> -->

Modified:
<Extension Name="ADS" Type="Microsoft.Office.Access.Reports.DataProcessing.AdsConnection, Microsoft.Office.Access.Server.DataServer, Version=14.0.0.0, Culture=Neutral, PublicKeyToken=71e9bce111e9429c"/>

Ok, we are ready to use Reporting Services in SharePoint 2010. As the previous version we have a feature (activated when we configure Reporting Services Integration) in the “Site Collection Feature”. Also the installation added 3 content types to add to our site. In Image 7 we can see 2 of them content types added in a document library to create a custom report using the, as we can see in Image 7

[Image 7]
7_Creating_Custom_Report

The “Reporter Builder” is an ActiveX that we need download of the server, as we can see in Image 8.

[Image 8]
8_Download_ActiveX_Reporter_Builder

When finish to download the “Report Builder” must load and we are ready to design our first report, as we can see in Image 9.

[Image 9]
9_Report_Builder

After create our report we could save it in the document library created to put the reports in our SharePoint 2010.

The other content type must be used to create shared connection as data source and save them in a document library in SharePoint. We can create a document library, add this content type and after we can have our connections available to change the data source of the reports.

Fabián Imaz

1 comment:

Mike said...

Would like to recommend HarePoint Analytics for SharePoint: the essential web-analytics solution for SharePoint-based sites and portals. More 70 reports, wide customization, great features.
Homepage: http://www.harepoint.com/Products/HarePointAnalyticsForSharePoint/Default.aspx