How to add a Web Part Connection using SharePoint Designer 2010

Home > Blogs > SharePoint > How to add a Web Part Connection using SharePoint Designer 2010

How to add a Web Part Connection using SharePoint Designer 2010

Like This Blog 2 Spike Xavier
Added by October 5, 2012

Many times it is helpful to create what we call a master details type of view on some data. For example, I have a list of SharePoint Courses and I find it easier to keep all of the data about each course in a single list and use SharePoint 2010's out-of-the-box view engine to present the data as needed via web parts. I don't need to do any custom programming to get a wide variety of views on the course data.

In this blog I will set up a web page that will allow users to click on an icon next to a course number and see the actual course outline in a web part below.

In order to do this I will use the following steps:

  1. Create a Custom List and add some data to the list.
  2. Create a Custom View called CourseOutline and edit the Tabular View to remove the Allow individual item checkboxes setting on this view.
  3. Create a new page and insert 2 web parts pointing at the courseOutlines List.
  4. Edit the titles of the web parts to Course and Outline.
  5. Attach the custom CourseOutline View to the bottom web part.
  6. Open the site in SharePoint Designer 2010 and edit the Page.
  7. Add a web part connection.
  8. Test the page.

 

Custom List

Custom List SharePoint 2010


I have prepared an out-of-the-box team site at the top level site of a new site collection for this demonstration. I have already created a list called courseOutlines and populated it with data. The image above shows the Columns and their respective data types (I changed the title column to CourseName)
(image of columns)


Custom View

Custom View SharePoint
 
Create a Custom View called CourseOutline. I do this by choosing the List tab and clicking on the Custom View Icon.
 

Standard View

Standard ViewSharePoint

 
I select Standard View.

Outline

Outlin SharePoint 2010
 
I name the View Outline, leave the default since it is a Public View, and select only 2 columns:CourseNumber and CourseOutline. I then scroll down so that I can edit the Tabular view section.


Tabular View
 
Tabular View SharePoint 2010

I click the + icon next to Tabular View.


Change Setting
 
Change Settinb SharePoint 2010

I uncheck the box next to Allow individual item checkboxes. I don't need users to be able to select individual items in this view. I scroll down and click OK (not shown)
 

Verify View

Verify View SharePoint 2010

 
I check the view and since this is what I want I move on to creating the page.


Create Page

Create Page SharePoint 2010

 
I click Site Actions>New Page
 

Name Page

Name Page SharePoint 2010

 
I name the page CourseDetails and click Create.
 

Insert First Web Part

Insert First Web Part SharePoint 2010

 
I select the Insert tab and click on Existing List in order to insert the web part that will show the courses.
 

Course Outlines

Course Outline SharePoint 2010

 
I select courseOutlines from the Web Parts Gallery and click on Add.
 

Repeat

Repeat SharePoint 2010

 
I repeat the insert web part process to place a duplicate web part below the first one.
 

Edit Bottom Web Part

Edit Bottom Web Part SharePoint Designer 2010

 
I click on the black triangle (ufo reference LOL) and select Edit Web Part from the menu that appears.
 

Select View

Select View SharePoint Designer 2010

 
I Select Outline from the Selected View drop down menu and then I click the + sign next to Appearance so I can change the title of the Web Part.
 

Change Web Part Title

Change Web Part Title SharePoint Designer 2010


 
I change the Title of the bottom web part to Outline, then I click OK (not shown).
 

Edit Title of Top Web Part

Edit Title Web Part SharePoint Designer 2010

 
I select the black triangle glif on the top web part and choose edit web part.
 

Change Title

Change Titile SharePoint Designer 2010

 
I expand Appearance and change the title to Course and click OK (not shown)
 

Save Page

Save Page SHarePoint Designer 2010

 
I click the Save Icon.


Edit inSharePoint Designer

Edit in SharePoint Deisgner 2010

 
I choose Site Actions > Edit in SharePoint Designer to open the site in SharePoint Designer 2010 where I will add the web part connection.
 

Site Pages

Site Pages SharePoint Designer 2010

 
I select Site Pages in the Navigation Pane, and click on the CourseDetails.aspx link which opens the summary page.
 

Edit File

Edit Files SharePoint Designer 2010

 
I click on the Edit file link in the Customization section of the Summary page.
 

Add Connection

Add Connection SHarePoint Designer 2010

 
I make sure to select the WebPartPages:XsltListViewWebPart and then click Add Connection from the ribbon.
 

Set Up Connection

Setup Connection SharePoint Designer 2010

 
I leave the defaults here which is for the Course Web part to Send Row of Data To and click Next.
 

Get Filter Values From

Get Filter Values From SharePoint Designer 2010

 
In this case the Web Part Connection Wizard is pretty intuitive and has correctly summized that I want to connect to the Outline web part so I click Next.
 

Map the Fields

Map the Fields SharePoint Designer 2010

 
I click in the Columns in Course table and select CourseName in the Inputs to Outline CourseName row to map those columns.
 

Check Settings

Check Settings SharePoint 2010

 
I check the settings and click Next.
 

Finish

Finish SharePoint Designer 2010


 
I click Finish.
 

Save the Changes

Save the Changes SharePoint Designer 2010

 
I make sure to click the Save Icon in SharePoint Designer 2010 then I close the program. I click yes to the prompt.
 

Refresh the Page and try it out

Refresh the Page and try out SharePoint Designer 2010

 
I go ahead and refresh the page then I will see the small glyphs to the left of the CourseNumber with a new Select column.

Depending on your list, web part, and columns you choose during the Web Part Connection Wizard you might be presented with the option to present the 'Filter' column as a hyperlink but in this example that was not the case. If you click on the Gyph the course outline will change accordingly. I clicked on the Glyph next to SPD2010 and noticed the Outline web part changed accordingly.

This is a very useful skill to have in SharePoint 2010.

Enjoy!
Spike Xavier
SharePoint Instructor – Interface Technical Training
Phoenix, AZ

Videos You May Like

Using Navigation Controls in a Collaboration Site in SharePoint

0 340 1

In this SharePoint training video, I want to talk about the Navigation Controls in SharePoint. They tend to fall into two kind of different categories; one with the navigation controls in a typical Collaboration Site such as a Team Site or a Project Site. These are Sites that are based on the Team Site Template … Continue reading Using Navigation Controls in a Collaboration Site in SharePoint

How to Use SharePoint Navigation Controls in a Publishing Site

0 225 2

For more SharePoint training videos in this series, see: Part 1 – Using Navigation Controls in a Collaboration Site in SharePoint Part 2 – » Using Navigation Controls in a Publishing Site in SharePoint « Part 3 – Configuring SharePoint Navigation in a Publishing Site – Activating the Publishing Feature Part 4 – How to Configure Navigation in SharePoint … Continue reading How to Use SharePoint Navigation Controls in a Publishing Site

Detailed Forensic Investigation of Malware Infections – April 21, 2015

4 630 5

How does an investigator hunt down and identify unknown malware? In this recording of our IT Security training webinar on April 21, 2015, Security expert Mike Danseglio (CISSP / CEH) performed several malware investigations on infected computers and identify symptoms, find root cause, and follow the leads to determine what’s happening. He demonstrated his preferred … Continue reading Detailed Forensic Investigation of Malware Infections – April 21, 2015

Write a Comment

See what people are saying...

    Share your thoughts...

    Please fill out the comment form below to post a reply.