Click here to Skip to main content
13,298,348 members (81,385 online)
Click here to Skip to main content
Add your own
alternative version


22 bookmarked
Posted 14 Apr 2007

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.


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


1. SQL 2005 Reporting Services
2. 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\"

Screenshot - codepr2.jpg

Creating SQL Report


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.

    <SoapAction> <a style="COLOR: blue; TEXT-DECORATION: underline; text-underline: single" href=""></a> </SoapAction> 

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


  1. Right click the project and choose properties

  2. Enter the Report server URL in the TargetServerURL

(For e.g.$SQL2005)

Screenshot - image013.png

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

Integration with Windows SharePoint Services


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.


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


About the Author

Udayakumar Ethirajulu
Web Developer
United States United States
No Biography provided

You may also be interested in...


Comments and Discussions

GeneralThanks Pin
NamoGuy23-Nov-09 8:38
memberNamoGuy23-Nov-09 8:38 
GeneralMy vote of 1 Pin
LoveConsultant4-Mar-09 6:51
memberLoveConsultant4-Mar-09 6:51 
GeneralWhere is the report file need to upload on the Share Point server Pin
Arun Patil14-May-08 11:17
memberArun Patil14-May-08 11:17 
GeneralProblem with SoapAction Pin
saisat4-May-07 8:43
membersaisat4-May-07 8:43 
GeneralRe: Problem with SoapAction Pin
Udayakumar Ethirajulu18-May-07 9:14
memberUdayakumar Ethirajulu18-May-07 9:14 
Refer my Post for Fetching list through webservice[^]

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

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

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