Linked Data Source Joining

 

To work with inked data source join,

there must be one common column relationship between two lists.

Otherwise it is not works.

do following Steps:

Step: 1

Create two Lists with Names as Indent Request and Indent Response

and its common column name is     MOC ID NO

Step: 2

Create linked data source(JoiningLists) using these two lists with join selection.

Step: 3

Create web part page

Step: 4

Create Data View web part

Step: 3

Open SharePoint designer with respective site url

On the left pan click on site Pages

Click on Web part page

Give name: JoiningLists

Click on between the web part zone

<WebPartPages:WebPartZone runat="server" Title="loc:FullPage" ID="FullPage" FrameType="TitleBarOnly">

<ZoneTemplate>

On the Top of ribbon select Data view

Next click on More Data Sources

Select Linked data source: JoiningLists

Next click on OK and save &Next click on the title field td

Click on common column in the response table

 

Next Click on data source dropdown and Select joined subview. It opens following popup so we need to select common column in both table MOC ID NO and click on OK

Comment the column heading of the response list as follows.

 

Add required column names in dvt_2.rowview  

 

 

Add column heading the top of heading column names only.

By adding the bellow code after columns heading we can get total record count on the top of page 

 

By adding the bellow code after group column name

we can get group wise rows count as follows

Note: if the columns are not displayed in the same column information then give fixed width for column title and column data  

After this also not displayed in the proper manner give class name “table” for columns heading table.

<table border="0" width="100%" cellpadding="2" cellspacing="0" class="table">

Example:

 

 Click on bellow link for Information On Linked data source