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
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.
5) Install the Add-In of Reporting Services November CTP for SQL Server 2008 R2 November CTP as we can see in image 2.
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.
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.
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.
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.
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.
<!-- <Extension Name="ADS" Type="Microsoft.Office.Access.Reports.DataProcessing.AdsConnection, Microsoft.Office.Access.Server.DataServer, Version=22.214.171.124, Culture=Neutral, PublicKeyToken=71e9bce111e9429c"/> -->
<Extension Name="ADS" Type="Microsoft.Office.Access.Reports.DataProcessing.AdsConnection, Microsoft.Office.Access.Server.DataServer, Version=126.96.36.199, 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
The “Reporter Builder” is an ActiveX that we need download of the server, as we can see in Image 8.
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.
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.