Monday, March 28, 2011

How to: Create a Joined View (Displaying the content of more than one list/ library) using SPD 2010

 

SharePoint 2010 allows you to create views where the data’s can fetched from several different lists. Following are the steps you need to follow to have your own view page.

At the very first stage, create two list, say L1 and L2

clip_image002

clip_image004

Next place some dummy data into those lists as shown below:

clip_image006

clip_image008

Now, open up SharePoint Designer and select Linked Data Sources and then select properties

clip_image010

On the properties window, select Sources tab and then add the two newly created lists

clip_image012

clip_image014

In our case, we need to select the first option.

clip_image016

 

clip_image018

clip_image020

So we have created one linked source which is going to be displayed in the view page.

clip_image022

Now, we need to select the attributes that we want to show in the view page.

clip_image024

We can also sort the values as shown below

clip_image026

clip_image028

clip_image030

clip_image032

Now create a blank web part page in your SharePoint site.

clip_image034

Check out and open that page via SharePoint Designer.

clip_image036

clip_image038

Select the web part zone where you want to display your linked data source and select Data View tab and then select the linked source that we have created just now.

clip_image040

clip_image042

Check in the page and if required publish it as a major version.

clip_image044

clip_image046

 

If needed you can apply Grouping also as shown below

clip_image048

clip_image050

When everything is done, open up the page in the browser and you will see the content of more than one list is appearing in that view page.

clip_image052

 

Cheers,
Avik