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»
Entries in this series:
- New Article Series: Laura Rogers on Data View Web Part Basics
- Data View Web Part, The Basics - Insert a DVWP on Your Page
- 6 Minute Screencast: Insert a Data View Web Part onto a SharePoint Page
- Data View Web Part, The Basics - Folders
- 3 Minute Screencast: Use DVWP to display all files, even those stored in folders!
- Data View Web Part, The Basics - Add a Hyperlink
- Data View Web Part, The Basics - Keep it Clean
- Data View Web Part, The Basics – Multiple Edit Forms
- 3 Minute Screencast: Data View Web Part, The Basics – Multiple Edit Forms
- Live Online Workshop - Data View Web Part Solutions: Part 2
- 5 Minute Screencast: SharePoint Web Services for Non-Developers
- 3 Minute Screencast: Merging SharePoint Document Libraries
- 2 Minute Screencast: Permissions Dashboard
- 4 Minute Screencast: Join View of SharePoint Lists
- Get it Together: Groups and Totals in the Data View Web Part (Screencast)
- SharePoint: Open Links in a New Browser Window (Screencast)
- How to Create a SharePoint Data View Web Part “Rollup” (Screencast)
- SharePoint: "New" Icon (Screencast)
- Display a SharePoint List on Another Site (Screencast)
- Customize the "no items" Display Text in SharePoint (Screencast)
- SharePoint: Displaying Calculated Column SUMS in a View (Screencast)
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.
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.
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…
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.
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
Laura/Detlef,
There’s also an alternative to Lightening conductor at the following location: http://www.pathtosharepoint.com/sharepoint-user-toolkit/Pages/Cross-Site-List-Snapshot.aspx
Just enter the URL of the list you want to re-display and this site will create the code for you that you copy and paste into a CEWP. Maybe not as flexible as Lightening Conductor, but I’ve had issues with LC when multiple web parts are added to the same page.
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
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 …
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”.
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
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.
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!
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.
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!
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
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.
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.
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
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.
Kawal – Just checked and it’s working. If you’re at work, it might be blocked by IT. — Mark
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.
Ian,
Here’s the screencast on how to add the hyperlink:
http://www.endusersharepoint.com/2009/05/14/6-minute-screencast-data-view-web-part-add-a-hyperlink-to-a-field/
Laura,
Thank you so much! It’s exactly what I wanted!
Cheers, Ian
Is it possible to show the subsite name as well in the webpart from where the announcement is pulled in?
Thanks.
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?
Yes, 2 DVWPs would be the best way to go about it in that situation.
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