xml - querying data from Sharepoint using Report Builder 2.0: missing fields -


I am using SQL Server 2008 with Report Builder 2.0, as mentioned in the data from a SharePoint list The report has been established to query and use an XML data source with query string set on query http: //mySharepointSite/_vti_bin/lists.asmx . However, I do not think all the fields from the Sharepoint list, even if I specify a view in which particular fields which I want and now no matter how I manipulate the query, let me either either Release field or theme field is available, but not both at the same time. This is my query because it is just right:

  & lt; Query & gt; Soap Action & gt; Http: //schemas.microsoft.com/sharepoint/soap/GetListItems</SoapAction& gt; & Lt; Method namespace = "http://schemas.microsoft.com/sharepoint/soap/" name = "GetListItems" & gt; & Lt; Parameter & gt; & Lt; Parameter name = "list name" & gt; & Lt; DefaultValue & gt; {8529D70B-D632-4CC8-A1E7-2C25F29BE1E0} & lt; / DefaultValue & gt; & Lt; / Parameters & gt; & Lt; Parameter name = "visual name" & gt; & Lt; DefaultValue & gt; {2FC6AA42-EA95-4C18-AB07-33E25EBBA85D} & lt; / DefaultValue & gt; & Lt; ViewFields & gt; & Lt; FieldRef name = "Resolve_x0020__x0023_" /> & Lt; FieldRef name = "product" /> & Lt; FieldRef name = "release" /> & Lt; FieldRef name = "theme" /> & Lt; FieldRef name = "Pre_x002d_Req_x0020_Estimate" /> & Lt; / ViewFields & gt; & Lt; / Parameters & gt; & Lt; / Parameters & gt; & Lt; / Method & gt; & Lt; Elementpath IgnoreNamespaces = "True" & gt; * & Lt; / ElementPath & gt; & Lt; / Query & gt;  

When I tested Report Builder 3.0 with my built-in Sharepoint List data source type, it was able to see both the theme and release field in my list. Does anyone know what is happening with Report Builder 2.0, however, when I do not see all the fields in the given list and see?

Update: In response to NelsonWeb's question:

  1. "Is there an InfoPath form in the list?" I do not know? It just looks at the text data.
  2. "How is input into list data columns?" I'm not sure what you're asking for data in Sharepoint has been recorded by other people and I think they only use the general SharePoint meaning (by adding a new item to the list).
  3. "Have you customized the list like adding / adjusting content type?" This is a list that was on our SharePoint site for a while, and it has been optimized in it. , It has the number of field types, multiple line text and choice, but I think these are only the default SharePoint types.

Found a solution for me on the gene chain, obviously when a field is a zero value Even if you want in that area, this field will not return. This trick is to clearly list the fields in the ElementPath tag:

  & lt; ElementPath IgnoreNamespaces = "true" & gt; GetListItemsResponse / GetListItemsResult / listitems / Data / Row {@field1, @field2, @field3, @field4} & lt; / ElementPath & gt;  

Comments