Creating Simple Report using Reporting Services SP2 and SharePoint 2007 Integration

I've been running around in circles all afternoon trying to create one simple report using Reporting Services (with latest SP2 installed) and SharePoint 2007. To the best of my knowledge, I have everything configured correctly:

When I access http://<server>/ReportServer, I see the server name of my SharePoint site.

When I click on the name of my SharePoint site, it shows me the directory structure I have created within my SharePoint Site

When I drill down in the directory, I can ultimately see the forms I created in my forms library (created via InfoPath 2007).

The next step is to create one simple report from the data in one of these forms libraries and a report on all the items within a form library. I'm stuck at the first step of creating a report, namely what to enter as the Data Source and the connection string. With a SQL database this isn't an issue.

How does one create a data source that will allow reporting over SharePoint content with the setup described above? And, if you have information that is found in the SQL Books Online, please be kind and post links so others know where to find this information.

You may want to check out this thread on how to use a SharePoint list as a Datasource:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1154115&SiteID=1

HTH
Prash

|||

I've looked at that thread many times and was able to extract information from a list using web services. But, with Reporting Services SP2 integration with SharePoint 2007, I figured they would have included built-in support to create reports in BIDS that consume SharePoint Lists and Document Libraries.

Perhaps I'm not seeing the full extent to which Reporting Services SP2 integration is supposed to act. My thoughts were that a SharePoint integration mode would allow reports to not only be stored on SharePoint sites, but also allow reports to be about the SharePoint site itself.

|||

Reporting Services SP2 integration with SharePoint 2007 does not include built-in support for consuming SharePoint Site data to be displayed in a Report.

thanx,
Prash

|||

I tried to workaround this issue

by Creating Microsoft Access 2007 Database, using Linked SharePoint List as a tables, then I created Reporting Service Report Using this Database, in Visual Studio the Report is working fine by showing the data correctly but when you try it on the report server reporsitory directly or in the Windows SharePoint Service 3 site It doesn't work at all, it keep loading and loading until the error unexpected error appear if am running it from the sharepoint site. even thougth I configured the data sources correctly in sharepoint for the report

Any help on that

Thanks

Mohd

|||

Hi,

You may be interested by our Reporting Services Data Extension : ERSDE that lets you build reports using SharePoint lists.

Though it was initially built for SPS 2003/WSS V2 lists, most of the features still work with MOSS 2007/WSS V3. We will soon release an update for Moss 2007/Wss V3.

Frdric Latour

Enesys