1,804 articles and 15,361 comments as of Monday, December 27th, 2010

Friday, December 11, 2009

Display a SharePoint List on Another Site (Screencast)

Author: Laura Rogers, Birmingham, AL
SharePoint 911

Would you like to display a SharePoint list or library on another site in your site collection? This can be accomplished using SharePoint Designer, by creating a data view web part. This screencast shows exactly how this is done, with the example of an “Announcements” list on the top level of a site. Using this method, this list can be inserted as a web part onto any other site in the site collection. This is not just static data, this web part will always display live data from the original list.

Author: Laura Rogers, Birmingham, AL
SharePoint 911

View all entries in this series: LauraRogers - Data View Web Part Basics»
 

Please Join the Discussion

27 Responses to “Display a SharePoint List on Another Site (Screencast)”
  1. Dan says:

    Very useful instructions, Laura. Thank you for posting!

    I especially love that, with the DVWP, you can filter it for different audiences (or different conditions), and display it (as you mentioned) on several sites within the site collection.

  2. jorgen_b says:

    Hi Laura.

    Thanks for the tip.
    I’ve tried out the method to create a dwp based on a library. When the dwp is displayed, it only shows references like:

    Created by: Systemaccount

    Any clues…?

    The reason I want to do this is that i want to show PARTS of a library in another site (same collection). When I tried to do this without SPDesigner, I was not able to filter the library list.

  3. jorgen_b says:

    ooops. the HREF actually worked in EUSP.com as well…

    nobr> span> A HREF=”/_layouts/userdisp.aspx?ID=1073741823″ (Systemaccount) /A> img border=”0″ height=”1″ width=”3″ src=”/_layouts/images/blank.gif”/> img border=’0′ height=’12′ width=’12′ src=’/_layouts/images/blank.gif’ alt=” /span> /nobr>

    That should do the trick…

  4. Detlef says:

    Does this work if the other site is a whole other SharePoint instead of a subsite of the current one? I tried it but all the data source library for the other site shows up as empty. So no data to pick from.

  5. Laura says:

    Detlef,
    This only works if within the same site collection. If you want to be able to display data across site collections, Lightning Tools has a product called “Lightning conductor web part”:
    http://www.lightningtools.com/pages/lightning-conductor-web-part.aspx

  6. Rick says:

    Laura-

    Your blogs and webcasts related to Data Form Web Parts have been awesome! Using DFWPs to expose list data across sites is very useful, but I am struggling now with trying to use a DFWP as a new item form across sites. It works fine when the page with the web part is on the same site as the list, but it blows up when the page is on a sub-site. I have deployed the DFWP within the master page.

    The problem appears to be related to the SharePoint:FormField control (the stack trace indicates a failure trying to get_ContentTypeOrder). I have tried to substitute asp controls for the SharePoint control, but that also fails on the insert command.

    Do you know if this is even possible using a DFWP? We are trying to avoid developing a custom control or web part, but it seems like we are heading in that direction. Any advice?

    Rick

  7. Mustafa says:

    Hello

    how i can any page in my list is default page for may list “View ”
    when i click in supported files in list properties i didn’t found the page that ii want to make it default page.

    thanks for your time …

  8. Laura says:

    Mustafa,
    You’ll need to drill down to the list or library where the aspx file is. Your libraries are under the root of the site, and views are in the “forms” folder. Lists are in a folder called “lists”.

  9. Greg says:

    Hi Laura,

    I have a main site holding a lists with multiple projects. Most of the info is managed at that level.
    Then I have multiple subsites on which I want to show only some of the projects.
    How can I filter down the records from the main list and only show those on a specific subsite.
    Either filtering using the URL name or a connected hidden webpart?
    Thanks,
    Greg

  10. Laura says:

    Wow Greg,
    That exact trick is something I struggled with for a while, and could never figure out a good solution. Couldn’t ever find a URL name or site name hidden variable, and also tried using the hidden web part option. Neither worked, out, and I ended up having to just use a DVWP filter, so had to open each new project site in SPD to filter by that project name.

  11. Paul UK says:

    Hi Laura,

    Thanks for your fantastic webcast. I’ve been playing around with data view webparts now this week. As I wanted to create a webpart on my homepage for new pages on a subsite below.

    I created a custom page layout and content type for a news page at site collection level, and created a subsite off my main site to store the news pages (limited to only using the custom content type). Then using a DVWP to aggregate the news items on the homepage of the site. (this is on a development server on MOSS2007)

    My problem is a behaviour problem, I noticed in your webcast once you had added the webpart you could export it as a dwp via the browser.

    Unfortunately for me, I had to dettach my home page from it’s page layout for my default.aspx in SPD to create the DVWP.. then once created, checked in and published.. the DVWP is not editable in the browser. Regardless if I reattach the page layout or not. Also once I go back to the page layout again to make edits it has disappeared! I would really like to be able to export and import the webpart to other areas and change the GUIDs to use in other sites too.

    Do you think my site collection has a problem or am I doing something wrong here? Or is this webcast just for WSS 3.0?

    Hope you can help!

  12. Laura says:

    Hi Paul,
    I don’t really have any experience with creating cusom layouts or anything that has to do with branding. Off the top of my head, it seems like you’re experiencing that problem because you’re not putting the web part in an actual web part zone on the page. A web part zone needs to exist first, so that you have all of those web part options like exporting.

  13. Paul UK says:

    Hi Laura,

    I just managed to solve the problem it seems, if I created a new page with no page layout on the server in SPD, then I can export it into a page attached to a page layout. I think that was the issue (with pagelayouts), as sure I was adding my data view to webpart zones before. Thanks for the repsonse though!

    Best of Luck!

  14. Gemma Normile says:

    Hi Laura,

    Your comments are fantastic. We have a mission critical single list on a main site and were wondering can we use DVWP to only view filtered selections of the main list i.e. not to expose the full list. It is vital that select groups are only permitted to view data from the main list that pertains to them only and not view the entire list itself or other groups views.

    Greg, delighted to hear you seem to be faced with the same issues as us – you’re not alone – can you share your progress with us?

    Many thanks
    Gemma

  15. Andrew says:

    Any idea on how to do this with 2010? I have a list in a site collection I want to use in the subsites, but I can’t find where to specify the Data Source for my Data View.

  16. Laura says:

    Andrew,
    I haven’t seen a way to do it in SharePoint 2010. I think you have to just open that other site in spd, create the web part, and then to to the target site and add the web part file to it.

  17. Laura Rogers says:

    hey guys, here I blogged about one way to do this in sp2010:
    Display a Sub-Site List on a Top Level Site:
    http://www.sharepoint911.com/blogs/laura/Lists/Posts/Post.aspx?ID=84

  18. Kawal says:

    Hi Laura,

    The webcast for some reason is not working. When I click on the play button, it just shows the ‘ready’ status on the media player task bar. Tried it with both Firefox and IE on a Windows XP machine.

  19. Ian Moss says:

    Found this article of yours Laura.

    I have created the webpart for a document library on the top level site and added the webpart successfully to a subsite. Can you please let me know how I can enable the filenames to be clickable, so it actually opens the file from the subsite??

    Thanks, Ian.

  20. Ian says:

    Laura,

    Thank you so much! It’s exactly what I wanted!

    Cheers, Ian

  21. Kannan says:

    Is it possible to show the subsite name as well in the webpart from where the announcement is pulled in?

    Thanks.

  22. Sarah Satterlee says:

    Hi, Laura–Thanks for a great webcast. Your instructions were really clear and very easy to follow. One question: Given master list on top site, for subsites, each with their own audience, do I need to create a separate DVWP for the filters appropriate to the audience? Big Org has two teams, each with their own subsite. I want to maintain Big Org’s list but display Team A’s members on Team A’s subsite and Team B’s members on Team B’s site. Does each team need its own DVWP?

  23. Laura Rogers says:

    Yes, 2 DVWPs would be the best way to go about it in that situation.

  24. Alec says:

    Hi Laura,

    Great Video. Anyways, i followed everything here but when I tried to connect connect to another sub-site site/MyOtherSite from site/MySite to list all the webparts or lists from MyOtherSite it says can’t connect to site/MyOtherSite do you know why? I want a list from site/MyOtherSite showing up in site/MySite.

    Regards
    Lito


Notify me of comments to this article:


Speak and you will be heard.

We check comments hourly.
If you want a pic to show with your comment, go get a gravatar!