Querying data from Sharepoint using Report Builder 2.0: missing fields

Question

I am using SQL Server 2008 with Report Builder 2.0 to try and request data from a Sharepoint list, as described in this tutorial . The report is configured to use an XML data source with a connection string set to http://mySharepointSite/_vti_bin/lists.asmx.

However, I cannot get all the fields from the Sharepoint list, even if I specify a view that contains specifically the fields that I want, and nothing more. Depending on how I manipulate the request, I seem to get either the Release field or Theme field, but not both at the same time. Here is my request as of now:

<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>{8529D70B-D632-4CC8-A1E7-2C25F29BE1E0}</DefaultValue>
         </Parameter>
         <Parameter Name="viewName">
            <DefaultValue>{2FC6AA42-EA95-4C18-AB07-33E25EBBA85D}</DefaultValue>
            <ViewFields>
               <FieldRef Name="Resolve_x0020__x0023_" />
               <FieldRef Name="Product" />
               <FieldRef Name="Release" />
               <FieldRef Name="Theme" />
               <FieldRef Name="Pre_x002d_Req_x0020_Estimate" />
            </ViewFields>
         </Parameter>
      </Parameters>
   </Method>
   <ElementPath IgnoreNamespaces="True">*</ElementPath>
</Query>

3.0 Sharepoint List, " " . - , 2.0, , ?

: nelsonwebs:

• " InfoPath?" ? .
• " ?" , . Sharepoint , , Sharepoint ( ).
• " , , / ?" , Sharepoint , , , Number, Choice, , Sharepoint.

Answer 1

Microsoft . -, , , , . , ElementPath:

<ElementPath IgnoreNamespaces="true">
    GetListItemsResponse/GetListItemsResult/listitems/data/row{@field1,@field2,@field3,@field4}
</ElementPath>