Welcome to MSDN Blogs Sign in | Join | Help

Jackie Bodine: SharePoint Blog

Windows SharePoint Services, Microsoft Office SharePoint Server, and related topics
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:

Posted: Tuesday, February 27, 2007 9:41 AM by Jackie Bodine

Comments

Clari said:

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

# March 20, 2007 4:08 PM

Cipri said:

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

# March 26, 2007 5:19 AM

Thomas Glod said:

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.

# July 6, 2007 7:51 AM

Hamez said:

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?

# July 19, 2007 6:23 PM

bind00 said:

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.

# September 26, 2007 5:09 AM

Himadrish Laha said:

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

# January 7, 2008 2:47 AM

Remya George said:

It is really a helpful stuff.

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

# January 17, 2008 1:35 AM

Autumm Caines said:

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.

# January 30, 2008 5:16 PM

Wdrozenia Sharepoint said:

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

# March 24, 2008 5:10 PM

Kuldeep Kadyan said:

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

Thanks dude!!!

# April 9, 2008 8:05 AM

Matthew Evetts said:

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.

# April 23, 2008 5:07 PM

Matthew Evetts said:

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

# April 23, 2008 5:07 PM

MURTY said:

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.  

# May 9, 2008 2:12 PM

Rob said:

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?

# August 11, 2008 4:56 PM

Marina said:

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

# September 10, 2008 11:15 AM

Ryan said:

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

# September 11, 2008 3:38 AM

Jeffrey said:

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

# September 18, 2008 11:34 AM

Tim Smith said:

Any way to mine data buried under folders ?

Thanks for this post !!  Great help!

# November 15, 2008 12:14 PM

lili said:

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?

# December 1, 2008 5:14 PM

Richard Willis said:

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

# December 11, 2008 5:55 AM

Todd said:

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

# March 4, 2009 9:09 AM

Bernd said:

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

# April 22, 2009 9:06 AM

akhila said:

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.

# May 18, 2009 11:20 AM
Leave a Comment

(required) 

(required) 

(optional)

(required) 

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Page view tracker