Click here to Skip to main content
Click here to Skip to main content
Go to top

Configuring SQL Reporting Services 2005 with Windows SharePoint Services 2003

, 18 May 2007
Rate this:
Please Sign up or sign in to vote.
This article explains how to integrate SQL Reporting Services with Windows SharePoint Services 2.0.

Introduction

This article explains how to integrate SQL Reporting Services with Windows SharePoint Services 2.0.
The PreBuild Microsoft's Reporting Services WebPart is used to be configured to display SQL Reports
which is to be fetch data from SQL Reporting Services.

Introduction to SQL Reporting Services

SQL Server 2005 Reporting Services is a server-based reporting platform that you can use to create and
manage tabular, matrix, graphical, and free-form reports that contain data from relational and multidimensional
data sources. The reports that you create can be viewed and managed over a World Wide Web-based connection.

Configuring SQL Reporting Services 2005 with WSS 2003

Prerequisites

1. SQL 2005 Reporting Services
2. RSWebParts.cab RsWebParts Setup: Execute the following commands in shell to install Reporting Services web part to Windows SharePoint services sites.

stsadm.exe -o addwppack -force –filename "C:\Program Files\Microsoft SQL Server\80\Tools\Reporting Services\SharePoint\RSWebParts.cab"

Screenshot - codepr2.jpg

Creating SQL Report

Steps:

1. Open SQL Server Business Intelligence Visual Studio 2005.
2. Create new Report Server Project.

Screenshot - image001.png

3. In Solution explorer Right click Shared Data sources and select add new data source.

Screenshot - image003.png

4. Enter the name of the data source and select the type of data source.
Now the SharePoint list is retrieved through web service. So its xml type.

5. Enter the web service URL as connection string for the data source.

Screenshot - image005.png

6. Right click the Reports in solution explorer and select add new report.

7. Follow the Reports wizard and choose the data source.

8. Connection string is to be in the xml soap format.

<Query>
    <SoapAction> <a style="COLOR: blue; TEXT-DECORATION: underline; text-underline: single" href="http://tempuri.org/GetEmpInfo">http://tempuri.org/GetEmpInfo</a> </SoapAction> 
</Query>

Screenshot - image007.png

9. Choose the report fields from the data columns.

Screenshot - image009.png

10. Save the Report.

Screenshot - image011.png

Deploying Reports in SQL Reporting Services

Steps

  1. Right click the project and choose properties

  2. Enter the Report server URL in the TargetServerURL

(For e.g. http://10.230.207.40/ReportServer$SQL2005)

Screenshot - image013.png

2. Right click the solution and select Build then Deploy the solution.

Integration with Windows SharePoint Services

Steps

1. Create New Web part Page in WSS.

Screenshot - image015.png

2. Insert the Report Viewer Web Part form Virtual Server Gallery.

Screenshot - image017.png

3. Select Modify Shared web part and Enter the report URL.

Screenshot - image019.png

Report Preview

Screenshot - image021.png

SQL Report Successfuly Generated in SharePoint WebPart

Screenshot - image024.jpg

I hope this article would be helpful to the Developers working on SharePoint integration with SQL Reporting Services 2005.

License

This article has no explicit license attached to it but may contain usage terms in the article text or the download files themselves. If in doubt please contact the author via the discussion board below.

A list of licenses authors might use can be found here

Share

About the Author

Udayakumar Ethirajulu
Web Developer
United States United States
No Biography provided

Comments and Discussions

 
GeneralThanks PinmemberNamoGuy23-Nov-09 7:38 
GeneralMy vote of 1 PinmemberLoveConsultant4-Mar-09 5:51 
GeneralWhere is the report file need to upload on the Share Point server PinmemberArun Patil14-May-08 10:17 
GeneralProblem with SoapAction Pinmembersaisat4-May-07 7:43 
GeneralRe: Problem with SoapAction PinmemberUdayakumar Ethirajulu18-May-07 8:14 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.

| Advertise | Privacy | Mobile
Web04 | 2.8.140922.1 | Last Updated 18 May 2007
Article Copyright 2007 by Udayakumar Ethirajulu
Everything else Copyright © CodeProject, 1999-2014
Terms of Service
Layout: fixed | fluid