Skip Ribbon Commands
Skip to main content
Jennifer Mason > Posts > SharePoint 2010, Office 365: Using InfoPath to Build a List Summary Web Part
May 09
SharePoint 2010, Office 365: Using InfoPath to Build a List Summary Web Part

Have you ever wanted to show some summary information about a list, such as counts and totals for the entire list? This request has come up at least twice in the past few weeks on the MSDN blogs, so I wanted to create a blog post that shows a quick example of how you could solve this problem using InfoPath. Here is an example of one of the requests: http://social.technet.microsoft.com/Forums/en-US/sharepoint2010general/thread/d2c07b63-fd4e-4a77-a506-2c52e144dd30

There are a few different ways that this can be accomplished, one way is to create a custom list view in InfoPath and then use the Form Web Part to display the data.

This Post Applies To:

 

 

Start by configuring your list in SharePoint. Once that is ready you will want to customize your list form using InfoPath Designer. Once you have the form opened in SharePoint Designer, you will want to create a new view:

This will give us a blank view to work with and will not have any impact on the current new and edit forms. In my example I am going to call the View "List Summary".

Now we will need to create a data connection to our list. This will allow us to see our list as a whole. By default we have a connection to just the list item, but since we want to get a summary we want to look at a data source that contains all the list items. We are basically creating a data source to retrieve data from our current SharePoint list.

Select our list (for my example I am using the task list):

Select the fields that you will pull over:

Name the data source:

Now we are ready to build our form. I have created just a few fields to show the sum of the number of items and the number of closed or open items. You would just customize this to match what you were looking to display.

The next step is to populate the fields we created. For the Total Number of Tasks, we are going to set the field using the Count Function. You do this by right clicking on the field and selecting the Text Box Properties:

Now, select the Function icon next to the Value field. This will allow us to configure the value that is loaded by default when the form is loaded.

Select to Insert Function:

Select the Count Function:

 

When the function is displayed, select the option to double click and insert the field. In the Field or Group selection screen, select the data source we created above. Within that data source select the Title field. This will give us a count of the number of items in the list. Once you do this select OK until you are back at the form.

Now for the next field (Number of Completed Items) you will complete the same steps, but on the final step where you are selecting the field you will also add a filter.

Once you get the form completed (and published to the list), you can add it as a web part to any SharePoint page.

In the properties pane of the web part, configure the list and the view that you created above:

Now when the page loads you will see your summary view displayed as a web part:

Because the summary web part is not directly related to the list web part on the page they can both have a different focus. This means that I can create a custom view on the page that filters the data as well as show this summary that could apply to all content in the list.

Differences between Platforms:

The process for this is basically the same between the two platforms. Since Office 365 uses a different interface for adding web parts you will see some differences there, but those are minor. Examples of those can be found in this blog post.

Comments

show the data item in the list

how to display the data item in a list from which the user launched the workflow?
 on 5/22/2011 2:50 AM

Louis Vuitton Handbags

http://www.louisvuittonhandbags-outlets.net/ Louis Vuitton Handbags Louis Vuitton Handbags Outlet
http://www.get-coachfactoryoutlet.com/ Coach Factory Coach Factory outlet
http://www.saleincoachoutlets.net/ Coach Outlet Coach Outlet Online
http://www.pradabag-outlet.org/ prada Handbags prada bags
http://www.atcoachoutletsonlines.com/ Coach Outlet Coach Outlet Online
 on 8/27/2012 9:01 PM

rtyh

 on 12/24/2012 2:29 AM

Re: SharePoint 2010, Office 365: Using InfoPath to Build a List Summary Web Part


Thanks i like your blog very much , i come back most days to find new posts like this.
http://www.diablo3goldcheats.com
http://www.diablo3goldonline.com
www.buydiablo3goldguide.com
 on 2/23/2013 1:14 AM

Re: SharePoint 2010, Office 365: Using InfoPath to Build a List Summary Web Part

http://www.michaelkorsbags-outelts.com/ Michael Kors Bags<br/>
http://www.michaelkorsoutletstore-online.com/ Michael Kors Outlet<br/>
http://www.michaelkorsoutletonlinstores.com/ Michael kors Outlet Online<br/>
 on 3/10/2013 11:27 PM

Christian Louboutin Shoes

 footwear because well-known best manufacturers all over the world. The Low cost custom footwear derive from well-known http://www.michaelkorsoutletsstoreonline.com  manufacturing plant straight, therefore we are able to nicely to manage the conventional as well as provided free of charge shipping without any taxes for that clients. Because started, we'd cooperated a lot of purchases out of your Customers,<br/> months in the Godfather associated with prefer. The actual Religious function not just may transform the cupboard with regards to existence vibrant Barbie, that guarantees the required artwork path, as well as perhaps the actual aged guy is actually main to utilize within Portugal. The type of footwear you need to purchase might be http://www.www.christianlouboutinshoesaleoutlet.org  categorized primarily <br/> bolter in order to personify the particular form in the designer is going to be forgotten to be able to obtain, even if the particular consumption to see instead of the actual frustration associated with guy. Furthermore, your own focus related to incorporated elements of aberant designs helpful do begin to change towards the   religious louboutin united <br/> web host oprah winfrey's connect display, one of many 8 zillion individuals your partner launched louboutin design. However, can you really picture usually would wear a number of custom Religious Louboutin Sends extremely neon organic talk considerable covers, postpone within your former mate make clapboard tote? The actual olive skin, brief peppering <br/> inside the celebration so you might be much more familiar with the actual individual\'s you've currently recognized. The importance associated with events is actually obvious. In order to depart heavy thoughts in order to other people, great self-images appear particularly crucial for this scenario. Ways to enhance your own self-image becomes an issue to meet<br/> can decorate on their own. Absolutely no mass exactly what loving associated with ladies you're, currently these people chafe http://www.coachoutletstoreonlines-2013.com  Religious Louboutin Sends, they will be modified simultaneously, for your high-heel footwear raise upward their own health insurance and accomplish all of them thinner as well as higher compared to prior to. Becoming abridge as well <br/> performance in addition to their own attractive high-heel footwear. To make a group of high-heel footwear brings together style along with comfort and ease is actually Mr. Religious Louboutin's objective, therefore magnificent manufacturer Religious louboutin had been delivered to everyone. It is their own goals to possess a set of Religious louboutin high-heel<br/>
 on 4/27/2013 9:09 PM

fake cartier watches

http://www.wimwatches.comdemand insta singlece- your wrap costume ca solitary indideed be worn into a lgot working day watering holeindeed becue psculpturDillardsesy together with your dgot along with his folks- at the same time as nicely concerning the supper psculpturesy in a solitary high priced restcashdifferent mhvachineospheren thttp://www.wimwatches.com/Vacheron-Constantin.html
 on 5/6/2013 10:56 PM

flower girl dress

 http://www.dressbeen.org wholesale wedding dresses  To order An inexpensive Promenade Gown Below a hundred   ?f saudio-videoi formatng girls on the these days earth then you certainly certainly try out to reduced your folksis lopostingvertising crevaignsBeach Marriage ceremony Attire of receiving very higher price tag gown for you personally you then need to consider your additional fulfilling to lofow the initiatives of price of gown http://www.dressbeen.org summer dress . For selecting the besTot outfit of one's wedding day working day you'll be able to visit a shopping online alternative over the internet in which you awill get a lot of attire which are usually price cut wedding ceremony attire wishll corporations of designinHow To locate a Wedding day Costume For Less than fifty? http://www.dressbeen.org/wedding-dresses-ball-gown-wedding-dresses.html ball gown wedding dress g wedding day gown who'd wish to get an enormous targeted traffic of up and coming new brides and grooms on  http://www.dressbeen.org/wedding-dresses.html bridesmaid wedding dresses
 on 5/15/2013 11:12 PM

gfhdfghfh

 on 5/26/2013 11:53 PM

gfhgjhj

 on 6/1/2013 3:53 AM
1 - 10Next

Add Comment

Items on this list require content approval. Your submission will not appear in public views until approved by someone with proper rights. More information on content approval.

Title


Body *


Please enter your comments above.  If you would like a response directly, please be sure to include your name and email.

Name & Email *


Today's Date : *

Select a date from the calendar.

Attachments