Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

Extract data from sharepoint list into SSRS 2008

  Asked By: Roxanne    Date: May 15    Category: Sharepoint    Views: 2175

I am trying to extract data from sharepoint list to SQL reports using SSRS
2008.This sounded simple enough to just query Sharepoint list webservice from
SQL data source in SSRS 2008 as below:


<SoapAction>http://schemas.microsoft.com/sharepoint/soap/GetListItems</SoapAction>" target="_blank" rel="nofollow">schemas.microsoft.com/.../SoapAction>
<Method Namespace="http://schemas.microsoft.com/sharepoint/soap"
<Parameter Name="listName">
<DefaultValue>list guide value </DefaultValue>
<Parameter Name="viewName">
<DefaultValue>view guid value</DefaultValue>

This method works well for ListView webparts ONLY.However,we required
customisation and had to join 2 different sharepoint lists into one merged
list. For doing this, we had to use dataview webpart.

Now, the problem with this webpart is, it does not display any list guid
values or view guid values and the above query to extract data from
sharepoint list webservice fails.

I am wondering if anyone had some luck with this kind of requirement where
you have to extract data from dataview webpart into sql reports?



No Answers Found. Be the First, To Post Answer.

Didn't find what you were looking for? Find more on Extract data from sharepoint list into SSRS 2008 Or get search suggestion and latest updates.