Data View Web Part Demo Reference
Today I did a presentation at the Rackspace Virtual SharePoint Summit. It was a demonstration of what the data view web part is, and some examples of how to use it. Some of you who attended this presentation asked for copies of the demonstration, so fortunately I have already recorded videos showing how to accomplish the same things we covered today.
Join View of Two Lists
There is a way in SharePoint to create a joined view of two different data sources, such as two lists. This is the same concept as creating a query in a database, between two tables that have a common field. Here is the link to my video demonstrating how to accomplish this, using Linked Sources in SharePoint Designer 2007: 4 Minute Video: Join View of SharePoint Lists
Create A Hyperlink
One thing that I didn’t have time to cover in the demo, but is fundamental in data view web parts, is how to create a hyperlink. You want to be able to click to open any of the items in the custom list view that you have created.
This video covers it: 6 Minute Video: Data View Web Part – Add a Hyperlink to a Field
Display a List on Another Site
In this demonstration, I show how to display an announcements list from the top level of the site collection, on any other site. I create a data view web part of the announcements list, and put the web part on a couple of different sub-sites in the site collection. This also shows a good demonstration of the best practice of creating the data view web part on a temporary web part page during the creation process:
Display a SharePoint List on Another Site
And for future reference, here are the rest of my Data View Web Part Videos.
This is outstanding! Thanks for putting them together in one post.
I was very interested by this post (Display a List on Another Site) but it seems to be a broken link : 404 NOT FOUND
These links are all fixed.
hi laura, i’ve watched ” Join View of Two Lists ” ..
FYI : i have external list (called PC Data, its user PC information gained by Dell KBOX Agent plus employee name) and then i create custom list (called PC inventory, which user entry the item & have a lookup to another external list ” employee list “).
what i’m going to ask is how to join external list (PC Data) with custom list (PC inventory), i want to compare which PC still not entry by user vice versa which PC still not installed KBOX agent, i’ve already create linked sources between PC Data & PC Inventory list, but when i create data view web part & choose the linked sources, the data source not show in ” current data source ” section ??
but when i join between two sharepoint list which not external list, the current data source show as in your screencast.
so, how can i join external list (PC Data) with custom list (PC inventory) ?
Hi Indra,
Sorry, I’ve never tried it with an external list. I recommend that you an an external data column to your sharepoint list, and then select a few other columns to be pulled over. That way, you’d be looking at both lists as one list.
Thank you !! I was wondering how to get the link to work with a list item.
Hello Laura –
I’m hoping to view the 4 minute screencast of Joined Views; however, it seems the link is not working?
I also had troubles viewing any of the other screencasts as well as the page was not found…
http://www.screencast.com/users/EndUserSharePoint/folders/SharePoint%20-%20Data%20View%20Web%20Part/media/ae394174-961c-4978-a976-78a4232f9e8f
Thanx!
Jeff
Hi Jeff,
Those links all work fine for me, including the one you posted in your comment.