Post reply

Error pulling data from Sharepoint List

  • October 7, 2010 at 1:50 pm

    #227749

    Hey folks, hoping somebody can help me out here.

    I'm using SSRS and trying to connect to a sharepoint list.

    I followed the steps here:

    http://www.codeproject.com/KB/reporting-services/ReportFromSharePoint.aspx

    But I'm still getting an error. I'll give as much info as I can.

    For the shared datasource, I'm using a link that when I plug it into a browser it brings back "Lists Web Service," so I think that part is fine.

    When I try to enter the "SOAP CALL" into the Query string of my data set I get an error.

    Soap Call:

    <Query>

    <SoapAction>http://schemas.microsoft.com/sharepoint/soap/GetListItems</SoapAction&gt;

    <Method Namespace="http://schemas.microsoft.com/sharepoint/soap/" Name="GetListItems">

    <Parameters>

    <Parameter Name="listName">

    <DefaultValue>{338D5EA1-CAA3-42D9-8D71-369A5B874219}</DefaultValue>

    </Parameter>

    </Parameters>

    </Method>

    <ElementPath IgnoreNamespaces="True">*</ElementPath>

    </Query>

    Error Message:

    ===================================

    Could not generate a list of fields for the query.

    Check the query syntax, or click Refresh Fields on the query toolbar.

    (Microsoft Report Designer)

    ===================================

    Failed to execute web request for the specified URL. (Microsoft.ReportingServices.DataExtensions)

    ------------------------------

    Program Location:

    at Microsoft.ReportingServices.DataExtensions.XmlDP.InMemoryCommand.ExecuteWebRequest(ICredentials credentials)

    at Microsoft.ReportingServices.DataExtensions.XmlDP.InMemoryCommand.Execute()

    at Microsoft.ReportingServices.DataExtensions.XmlDP.InMemoryCommand.<>c__DisplayClass1.<ExecuteReader>b__0()

    at Microsoft.ReportingServices.DataExtensions.XmlDP.WebRequestHelper.ExecuteServerCallAsNtUser(ServerCall serverCall, WindowsIdentity ntUser)

    at Microsoft.ReportingServices.DataExtensions.XmlDP.InMemoryCommand.ExecuteReader(CommandBehavior behavior)

    at Microsoft.ReportDesigner.Design.Query.GetSchemaByExecutingQuery(IDbCommand command, Boolean fSilent, Boolean& fCanceled)

    at Microsoft.ReportDesigner.Design.Query.UpdateFields(IDbCommand command, Boolean fUseWorkaround)

    ===================================

    Anyone have any thoughts? I'd really appreciate any and all help.

    Thanks,

    Parag

  • October 12, 2010 at 6:07 am

    #1235434

    Anyone have any thoughts?

  • October 21, 2015 at 1:52 pm

    #1834766

    The data source should be XML for this Query

    /_vti_bin/lists.asmx

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply