SharePoint Blog - René Hézser

Anmelden  RSS Feed RSS Feed
Startet die Suche

Archive

Kategorien

Links

Andere Blogs



Add to Technorati Favorites


Reporting on SharePoint Lists  

Feb 222007

You can do Reporting on SharePoint Lists with SQL Server Reporting Services 2005 quite easy.

  1. Configure the Datasource with integrated Security
  2. Define a query like

    <Query>
    <SoapAction>http://schemas.microsoft.com/sharepoint/soap/GetListItems</SoapAction>
    <Method Namespace="http://schemas.microsoft.com/sharepoint/soap/" Name="GetListItems">
    <Parameters>
    <Parameter Name="listName">
    <DefaultValue>SharePoint List Name</DefaultValue>
    </Parameter>
    </Parameters>
    </Method>
    <ElementPath IgnoreNamespaces="True">*</ElementPath>
    </Query>

  3. Hit the "Field Refresh" Button to get the Field from your SharePoint List
  4. Drag your Fields in the Report
  5. Use the Code to eliminate "ID;#" and "<div>","</div>" from your Fields

    Use "=Code.CuttOff(Fields!ows_LinkTitle.Value)" in your Report to display your Fields
 
Posted by René Hézser | 17  Comments | Trackback Url  | 0  Links to this post | Bookmark this post with:        
Tags: Reporting Services
Technorati Tags:

Links to this post

Comments

commented on  Friday, December 07, 2007  11:28 PM  by  I get this error
Hi,

There is an error in the query. Failed to execute web request for the specified URL.

Thank you.

commented on  Saturday, December 08, 2007  5:06 PM  by  AW: Reporting on SharePoint Lists
What shall I say? It works for me. Be sure to change the path to your webservice in the connection string. Also check if your lists display name is different from its internal name (the one in the url).

René

commented on  Thursday, May 08, 2008  10:24 AM  by  Patrick
Hi Rene it doesn't work for me too.
I got the same error as above
Please email me if you have some solution for this to :
naijacoder@hotmail.com

commented on  Thursday, May 08, 2008  5:39 PM  by  re: Patrick
Hi Patrick,
did you doublecheck the Urls and names? The connection string has to be "http://yoursite/subweb/_vti_bin/lists.asmx"
Is there any proxy which might prevent a connection?

René

commented on  Tuesday, October 14, 2008  10:40 AM  by  Not working form me ....
Hi ,

i m also getting error like "Failed to execute web request for the specified URL"

i checked my connection string in IE it is correct.

commented on  Thursday, February 26, 2009  4:02 PM  by  Lee
Works well, thanks for the tips

commented on  Friday, May 01, 2009  6:13 PM  by  Panda
Try using the GUID of the list instead of the list name. You can get the GUID from the URL when you are editing the settings of the SharePoint list. That's what I ended up doing to correct the errors I encountered

commented on  Thursday, June 18, 2009  3:18 AM  by  Carlos
Thank you for your great contributions. They really saved me time and allowed me to access important data we have compiled in several SharePoint list libraries. We also have quite a few SharePoint Forms libraries. Would it be too much to ask for the query to retrieve data from a form library instead? Thanks again.

commented on  Wednesday, June 24, 2009  9:11 AM  by  René Hézser
Hi Carlos,
the lists webservice should also work with libraries. With form libraries, you have to watch out for the internal field names. They can be nasty.

René

commented on  Thursday, September 24, 2009  2:00 PM  by  Daniel
Is the code that is slightly cut off supposed to help remove invalid strings that might come accross?

commented on  Saturday, September 26, 2009  10:05 PM  by  René Hézser
Hi Daniel,
the invisible code is to take the second part of a lookup field (1;#one is the value of a lookup field)

René

commented on  Friday, October 16, 2009  6:10 PM  by  Jennifer
What is the code that is cut off? I'm not familiar with this code. Thanks!

commented on  Thursday, December 17, 2009  8:30 AM  by  SharePoint Data Miner
Hi,

This approach is too slow and error prone.
Try using the SharePoint Data Miner instead.

Adrian

commented on  Saturday, February 06, 2010  6:54 PM  by  René Hézser
Great. Use my blog to promote your software...

commented on  Monday, February 08, 2010  6:15 PM  by  You
Adrian,

Can you please stop advertising your stupid software in all the forums that talk about reporting from list? KTHXBI

commented on  Monday, March 15, 2010  10:08 PM  by  Virtz
What is the end of below code? Thanks.
result = result.Substring((result.IndexOf(";

commented on  Thursday, March 18, 2010  7:16 PM  by  René Hézser
Maybe "#)+2));"
I honestly don't know. Try to see what fits best ;-)

René

Name *:
URL:
Email:
Kommentar:


CAPTCHA Image Validation