Displaying a list on another site (in the same site collection)


A pretty common request is the ability to display content from one site on another site.  For example, you might have a blog sub site, and want to show those posts on the home page of the parent site.

In WSS V3, this is easy to do with SharePoint Designer.

First, we’ll open the site and page we where we want to display the list in SharePoint Designer.  One way to do this is to open SharePoint Designer and choose “Open Site…” from the File menu.  Another way is to browse to the page and then click the “Edit with Microsoft Office SharePoint Designer” option in Internet Explorer:

Inside SharePoint Designer, in the design view of the page, click where you want the list to go, and then select “Insert Data View” from the Data View menu:

In the Data Source Library Task Pane, select “Connect to another library…”, since we want to display a list that is not in this site: 

Click Add, then choose a display name, and type in the URL to the site where the list is:

Click OK in both dialogs, and then expand the new Library until you find the list you want:

Next, click on the list and select “Show Data”:

Now the task pane shows the columns from the list:

You can now insert the items by selecting “Multiple Item View” from the insert menu:

Let’s start by changing the layout:

The Repeating Form layout is close to the blog layout:

Text fields are HTML encoded by default.  To fix this, click on the arrow near the body field, and change the Format as: to Rich Text:

 You can now remove column headers and edit any styles that you like:

To make a field into a link, set the format to be Hyperlink.  In the popup box, you can set the URL, and you can include values from the item by clicking the “fx” button:

When you’re done, save the page, and view it in the browser:


Comments (39)

  1. Clari says:

    HI

    I am trying to get a list of tasks from a website that uses SSL, so the address is https://www.mywebsite.com/sites/subsite1/tasks

    I keep getting an error messsage "Unable to connect to https://www.mywebsite.com/sites/subsite1/tasks"

    How can get this working?

    Thanks

    Clari

  2. Cipri says:

    Hi,

    I need your help…

    I managed to follow the steps from the artcle, but, when  have to click the "Insert selected fields as…" the "Multiple Item View" is not apearing, the only item is "Single item view" and is not even enabled.

    Do yo have any ideas?

    Cipri

  3. Thomas Glod says:

    Nice blog post. Thank you. This way works fine when you want to present data from another site in a table. It seems there is no standard way in Sharepoint designer to show a calendar view from the main site on another subsite in the same site collection. It doesn´t look very nice to present a calendar list in a table. Please let me know if you know a way to do thís.

  4. Hamez says:

    I have a problem with a particular server.  

    On my development server I was able to add a sub-site’s data source library to a top level site, and the lists showed up as expected.  

    However on a clients production server, I tried the same thing (Add a sub-sites data source library), as a site collection admin and there is only one site collection, but the lists did not show up.  Does anyone know what could be causing this?

  5. bind00 says:

    I can connect to other sites but I don’t get any lists or libraries. Just Database Connections, XML Files, etc.

    It used to work before it was upgraded to WSS 3.0.

  6. Himadrish Laha says:

    Thanks for your nice article!

    I really appreciate the stuff. Just to confirm one thing, the same can be implement in WSS 2.0. If you have FrontPage 2003, and simple way you can follow insert data view web part, and so on.

    Cheers!

    Himadrish

  7. Remya George says:

    It is really a helpful stuff.

    Is there any facility to reply from the new site and get that reflected in the original site?

  8. Autumm Caines says:

    Great tutorial and Thank you Thank you Thank you… I was trying to figure this out for about 2hrs before I came upon your post. Figured out how to link from outside RSS feeds and such but trying to the posts inside the site was driving me nuts.

    @Cipri from a few comments previous

    I had the same problem with the Multiple Item View not showing up… not sure what causes it but I just draged the fields that I wanted and droped them into the page, from there the tutorial was the same.

  9. Is it possible to use DataView WebPart to edit items in a remote Sharepoint list? Like EditForm for remote list?

  10. Kuldeep Kadyan says:

    Mind blowing blog…i was looking from a long time specially for Blog Site.

    Thanks dude!!!

  11. Matthew Evetts says:

    The "insert selected fields as" menu was not showing up for me at all.  I had to click "insert data source control" before "show data" in the step before inserting fields.  This overwrites whatever you’ve clicked on in the SharePoint page.  The "insert selected fields" menu should now be available.

  12. Matthew Evetts says:

    Other than my post above this tutorial went like a breeze!  It has saved me some huge headaches!

  13. MURTY says:

    Hi Jackie. That is an awesomeeee post. I have a few questions.Can we set audience so that it is visible to only a certain group. Also without active directeory can we set groups, e-mail addresses etc.  

  14. Rob says:

    This is a great post, very usefull.

    Has anyone seen a way to do the same thing, but show the data in a calendar view?

  15. Marina says:

    Hi!

    Did you answered Clari?

    I am getting the same error.

    Thank you in advance, Marina

    HI

    I am trying to get a list of tasks from a website that uses SSL, so the address is https://www.mywebsite.com/sites/subsite1/tasks

    I keep getting an error messsage "Unable to connect to https://www.mywebsite.com/sites/subsite1/tasks"

    How can get this working?

    Thanks

    Clari

  16. Ryan says:

    Hi,

    Thanks for this nice guide.

    Is it possible to have the dataviewer show only one item from another library. Somthing like your guide, but one could provide an ID to point out a specific item in that library we want to show.

    Regards,

    Ryan

  17. Jeffrey says:

    Thanks!   How would I display the "Links" list from one site in another as the URL doesn’t display properly?

    Thanks for any help!

    Jeffrey

  18. Tim Smith says:

    Any way to mine data buried under folders ?

    Thanks for this post !!  Great help!

  19. lili says:

    hello =]

    i want to get my list from the top level site to a subsite, i can see it in sp designer but i get an error in my browser do i have to change something else?

  20. If anyone is interested I’ve just released a beta version of a web part which will display lists from the same or other site collection, and also display calendars. It is a commercial product, but if you are interest have a look at my blog at http://blog.salamandersoft.co.uk/CategoryView,category,ListView.aspx

  21. Todd says:

    Is there a way to do this for those of us who are not server admins and don’t have SharePoint Designer or FrontPage?

  22. Bernd says:

    Okay,

    seems quit good, but i couldn’t get it running through diffrent subfolders of a list.

    The list has 3 subfolders in the root-folder and there is a view, showing up all entries regardless of the sourcefolder.

    Is it possible to show this…?!

    THX in advance

    Bernd

  23. akhila says:

    I followed the exact steps but , it threw me a unexpected  server  error. When I connect to Databases its working fine.

    Is there any work around for this.

  24. Ajay Kumar-Teliris says:

    Nice article, Works very fine.

    Thanks

    Ajay

  25. Venkata subbarao says:

    Hi its very great post but i have one question how to add the list items from this please help me i am not geting the new button and action buttons using the above procedure.

    Thanks In Advance…..

  26. sampada says:

    HI ,

    Thanks for the wonderfull post.

    I am facing a problem following the steps. I am bot getting any lists,data libraries but connect xml etc.

    I am new to sharepoint designer . Can anyone please help me?

    Thanks in advanced.

  27. Doc Tech says:

    This post rocks!   What took me so long to find it!  Accomplished exactly what I needed.  THANK YOU!

  28. Tabby (tabbcat@yahoo.com) says:

    Following these steps, but "Insert Selected Fields as.." is greyed out!  Any ideas?

  29. Jill says:

    How can you get this to work to pull in from another site collection.  Is there a post somewhere that shows how to do that?  Thank you

  30. Nate says:

    I was able to get a list from a calendar from another site.  Unfortunately, I can’t it to do a calendar view.  It just displays it as a list.  Is this doable?

    I apologize if I’m repeating this post again, but I’m having some computer trouble.

  31. albert says:

    How do you do this if the list is from a site in another site collection? I tried this method and it doesn’t work.

  32. JB says:

    It worked great. I can even export the custom web parts that I just created using this tutorial.

    QUESTION: I now have to take this web parts and deploy to another sharepoint site (test, qc, and production).

    What all I need to change with this xml web part so it can be  deployed to any sharepoint site….

  33. Naresh Reddy says:

    Hi ,

    how can i display mutliple lists from multiple sites  together in on home page in a tabular ,dashboard manner.

    pls help me out!!!

    thanks in advance

  34. Michael says:

    You really need to do a better job of displaying the images you have on these posts, they are not clear enough to make out. I think it would really help to be able to see the examples you give.

    Thanks,

  35. Drew says:

    3 years and not a single answer to a single question.  Well done MS!  Way to really relate to the people asking for help.

  36. Come on Jackie, Like Drew, most of us are waiting for reply to the queries. That's why you write a blog – to help.

  37. Peter Ward says:

    http://www.wardpeter.com

    See my blog entry..

  38. Madhuri says:

    I get the site cannot be opened error when I try to add another source library.

    Please help me out.

    Thanks in advance.