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.

Steps

SQL Report Successfuly Generated in SharePoint WebPart

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.

Comments and Discussions

This was great to find on the web, We had been working on installed the SharePoint Report Server Webpart with no luck. After finding this we uninstalled those and followed the steps to install the one under SQL Server folder system and it worked first try. The only thing we noticed was the on some of our SQL Servers the web part file and foler where not present and when I did finally find it, the file was under the 90 directory, not the 80 directory. If that helps someone else.

Great article !I have some confusion about the report file location. Where is the location to upload report file either in 'shared documents' folder or any other folder.if yes the which are those files need to be upload on that shared documents(.rdl,.data.rds) or else only .rdl

I am trying to access the lists.asmx from the sharepoint server and access the GetList method. this is my query<query> <soapaction>http://schemas.microsoft.com/sharepoint/soap/GetList

But I a getting an error.

TITLE: Microsoft Report Designer------------------------------

Could not generate a list of fields for the query.Check the query syntax or click Refresh Fields on the query toolbar.The 'p' start tag on line 248 does not match the end tag of 'ul'. Line 250, position 17.

------------------------------ADDITIONAL INFORMATION:

The 'p' start tag on line 248 does not match the end tag of 'ul'. Line 250, position 17. (System.Xml)

Any idea how to fix this

This is my datasource http://servername/_vti_bin/Lists.asmx with xml as the type