IconDo you have two lists that you would like to display their data in one convenient location? Well, the SharePoint Data View should work perfectly for this type of use. Follow along with the article to understand more about using the Data View to connect two list and display information of your choosing.

To begin, you must have SharePoint Designer 2007 and appopriate permissions within both lists and the site(s). Also, some general understanding of MOSS is always a plus. Got it? Good, let’s continue.

Getting Setup:

1. Open the Site holding the page you wish to display the data view on in SharePoint Designer 2007.

Step1

2. Detach the Page from the Layout and Check it out so we can edit it using SPD

Step 2

3. Once the page has finished loading select the appropriate Web Part Zone and click Data View > Insert Data View

Step3

You will now see the Data Source Library Task Pane on the Right Panel

DataSourceLibrary

Please note: If your lists are on another site collection you will have to use the Connect to another library… link

4. Expand Linked Sources and click Create a new Linked Source…

Step 4

The Data Souce Properties window pops up; click Configure Linked Source…

5. Add lists you want linked from the Available Data Sources to the Selected Data Sources and click Next

Step 5

6. For this example we will be using the “Join the contents of the data sources…” option; when you are done click Next

Step 6

7. In the Data Source Task Pane expand the drop-down to our newly created Linked source and click Show Data

Step 7

8. Select the appropriate columns from each data source and expand the Insert the Selected Fields as… drop-down and insert as either single or multiple item view (depending on your preference).

Step 8

9. Now you will see the data in either a side-by-side view or stacked (depending on if you joined or merged when linking the two data sources)

Step 9

10. Pretty it up a bit and make the Data View display the information how you want, save the page, reattach to the page layout and, finally, check in to major version.

Like this article? Why not leave a comment? Scroll down to do just that!

Devin Walker is a San Diego-based WordPress Developer and enthusiast. He is the author of several popular and highly-rated WordPress themes and plugins. In his free time he enjoys playing Golf and traveling.

Follow Devin:

  • Rick

    I was reading over your post and I think I am a little confused. You can not query Lists in a different site collection. Do you know something I wish I did?

    I just want to clarify that you are not able to query lists and libraries across site collection with “Connect to another library”.

    Thanks,
    Rick

  • sid

    Thank you so much…it was of such a great help …i was looking for a no code good solution and dang i got ur article…i owe u a beer man..thanks again dude..

  • Richard

    @Rick: You can query lists and libraries across Site Colletcions, unless you’re trying to do a roll up.

    I can’t remember exactly if it was with the XML or XML Web Service but you did have to point to the Lists.asmx. I’m sure you can find more info online :)

  • Dale

    Can you add to either list then after it’s put up on sharepoint? I mean add new items content to either list? Even though this is only a “view”.

  • Beanyjon

    Hello, can i used this procedure or an adption of it to show to lists side by side but ….
    Have a lookup on list B pulling in a column from list A, then only showing data when the two fields match?
    Also is there a way to export this newl created dataview to a spreasheet?

  • Sarah

    Is there a way to apply the same method to SharePoint Designer 2010?   I can’t find the same buttons in SPD 2010.

  • Hasan Siddiqui

    Hi I have fallow ur step. but i have two list with lookup relation and i need data acording look up filde show the all data between two list in same columne whre the relation exist