Click here to Skip to main content
1,837 members
Articles / Security / .NET 1.1
Article

Configuring SQL Reporting Services 2005 with Windows SharePoint Services 2003

Rate me:
Please Sign up or sign in to vote.
0.00/5 (No votes)
12 Apr 2012 5.9K  
This article explains how to integrate SQL Reporting Services with Windows SharePoint Services 2.0.

This article is a sponsored article. Articles such as these are intended to provide you with information on products and services that we consider useful and of value to developers

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


Written By
Web Developer
United States United States
This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.

Comments and Discussions

 
-- There are no messages in this forum --