SharePoint Development & Administration + InfoPath

By Default, items in a SharePoint list can't be grouped by a Choice field if it allows multiple selections (checkbox). To be able to group by the value of a Choice field in a SharePoint list or library which allows multiple selections, you need to ensure that the Choice field/column is set as Radio Buttons or a Drop Down Menu. Both of these options only allow a single selection of the available choices, which is required to allow grouping by the column/field using Standard SharePoint List views. To group by a Choice field which allows multiple selections (checkboxes), convert the Web Part to a Data View using SharePoint Designer, then apply grouping doing the following: 1. From the "Common Data View Tasks" menu for the Data View Web Part, select "Sort and Group:" from the options to open the Sort and Group Dialog, add any field into the Sort Order section to activate the "Edit Sort Expression..." button. Click the "Edit Sort Expression..." b...

The following article demonstrates how to integrate an InfoPath form with a SharePoint form library, using a centralised template stored in a SharePoint document library and linked to a site Content Type. The form is set up to submit to a SharePoint form library Overview: Set up SharePoint libraries Design the form template Publish form template to SharePoint Content Type Configure the form's primary data connection to submit to the SharePoint library Secondary Data Connections to receive or submit data to a SharePoint list Setting up SharePoint to store the Form template and receive Submitted forms: If InfoPath Form services are available on your SharePoint server, you have the option to store the form template using Central Administration's managed templates list. To make the form available using this method it must uploaded to the Managed Templates List, the activated for the required site collection. In this example I publish the form template to a ...

Problem I have a data connection retrieving ID values from a library’s items to determine the maximum ID of items currently in the list. Certain metadata results in items not appearing in the default view. When InfoPath queries the data connection, only IDs of items which display in the default view are retrieved. This became a problem as the maximum ID found by InfoPath was 240, when documents existed in the library with an ID of 246. To complicate the matter even further, a number of documents had been added and removed from the library making the next available ID 268. I needed InfoPath data connection to give me the maximum ID of current documents (246). Cause Data connections in InfoPath return the same results as the default view for the specified SharePoint list. Solution 1: Create a view which returns all items in a list / library (no filter criteria) – Set this view as default Will work well for lists libraries with less than 2000 items, and when a custom view is not ...

The following screenshot (MOSS 2007) shows the setting that is required when creating a view to display all documents in the library, ignoring the directory structure. This page can be accessed from any document library or list by selecting "Modify this View" or "Create View" from the View dropdown menu. Using this feature can increase relevance of the items/results displayed from the library as sorting and grouping can be performed using metadata without displaying folders. When using this method, the directory structure is preserved. Posted as a solution to http://www.sharepointblogs.com/forums/p/20623/44064.aspx#44064 on 10/03/09