locked
How to Create a Data Set which queries the all the files and folders in Sharepoint Document Library? RRS feed

  • Question

  • Hi,

    1. I have a Sharepoint Document Library which contains nested folders, thus the files are present at root level and in all the sub folders within the form library.

    2. I need to create a Data set in Report Builder 3.0, whcich queries all the files in folders and sub folders.

    3. Generally i use "U2U CAML builder tool" to generate a CAML query or use the "Query Designer" option in Report Builder 3.0 to generate the appropriate query to fetch the data.

    4. Now using U2U tool, in order to fetch all the files in folders and subfolders i have connected using "Sharepoint WebService" and then build the query using "GetListItems" options by right-clicking the desired document library. This fethces me all the files in folders and subfolders.

    5. When i copy the query generated in step 4 and paste it in Report Builder 3.0 query desinger, it gives me error while saving the query as "The SharePoint List query is not valid. the XML element <Queryoptions> is not valid"

    Also please find the query that i am using below

    <RSSharePointList xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
      <ListName>FormLibrary</ListName>
    <Query>
     <Where>
     <Eq>
      <FieldRef Name="Region" />
      <Value Type="Text">
      <Parameter Name="Region" />
      </Value>
     </Eq>
     </Where>
    </Query>
    <ViewFields>
    <FieldRef Name="Region" />
    <FieldRef Name="Country" />
    </ViewFields>
    <QueryOptions>
     <ViewAttributes Scope="Recursive" />
    </QueryOptions>
    </RSSharePointList>

    Has any one faced this issue earlier or tried fetching the all the files in folders and subfolders in SSRS using Report Builder 3.0 tool.

    Any suggestions/pointers on this would be higly appreciated.

    Regards,

    Ketan Gandhi


    Regards, Ketan Gandhi

    Monday, December 3, 2012 11:37 AM

All replies