How-To Rollup two lists in two site collections on a page


We can use the content by Query web part for rolling up of lists in a single place. But this only supports a single site collection. If you want to show the data from two lists residing in two different site collections, then we can use SharePoint Designer. I just explored with the help of my colleague and it works just fine.

In my example I am using three site collections; root, sites/first and sites/second. I have the default document library; Shared Documents in all site collections.

1. Open the root site collection using SharePoint Designer.

2. Create a new aspx page in the root or in the pages library depending on the requirement.

3. Click on the Task Pane and enable the ‘Data source Library’ and now you can see the same on the right side of the screen.

clip_image002

4. Click on the plus sign on the XML Web Services and click on Connect to a web service.

clip_image004

5. Click on Connect to a web service inside the XML Web Services section.

6. Type the URL for the lists.asmx web service within the first site collection. In our example, provide http://server/sites/first/_vti_bin/lists.asmx and click on the Connect Now button.

7. This will provide the following screen. In operation drop-down, select GetListItems.

clip_image006

8. Double click on the listname from the Parameters section and type the name of the document library / list. In my case, I typed Shared Documents and click ok.

9. Repeat the steps from 5 to 8 for the different list in a different site collection.

10. Now we have two connections to two different lists in two different site collections.

11. The last and final step is to link these two sources through Linked Sources.

12. Click on the plus sign in the Linked sources and click on ‘Create a new linked source’.

13. This will bring a new window and click on ‘Configure Linked Source’

clip_image008

14. In the resulting window, select the two XML web services that we have created and added to the list of Selected data sources and click on Finish.

clip_image010

15. Now click the new linked data source and click on Show Data.

clip_image012

16. The above step will bring the following screen. The last step is to insert the z:row to the page that we have created in step 2.

clip_image014

17. Now it’s your turn to add some beautification to the list.

Comments (2)
  1. Anonymous says:

    Seems straight forward enough – unfortuantely I am unable to view the Items folders when I view the data.

    I get:

    GetListResponse

    GetListResult

    List

    No items.

    Would you have any suggestions?  Thanks.

  2. Anonymous says:

    Hi Hari,

    This is an excellent article, i’ve been looking for such a solution for some time now.

    Keep up the good job.

    -Sharat

Comments are closed.

Skip to main content