SharePoint List Collection is a Web Part which can collect lists from different sites to display in a single grid view. It can also create different views in list collection web part as in lists.
The following example will show how to use SharePoint List Collection.
There are two lists in different sites.
Open the page to which you want to add list collection web part. Click Edit Page on Site Actions menu.
Then, click Add a Web Part.
Choose cross-site collection web part, and click Add.
Exit Edit Mode, and cross-site list collection web part has been added on the page.
On the Settings menu, click Add collection part.
On Add collection part page, select the site, list and view.
Select select columns, and click OK.
After selecting columns, return to the front page, the items from different lists are now displayed on list collection web part.
Click Create View in the View menu or in the Settings menu.
In Choose a view format section, click Standard View.
In Name and Audience section, type a view name, and choose View Audience.
In Filter section, choose the lists and list view name.
Select the columns, and specify the display order in the view.
Then, in Edit Menu section, select the column linked to Edit Menu.
In Sort section, choose which column to sort and specify the sort order.
In Header Filter section, do not this checkbox to disable filter on header of columns.
In Group By section, select the column to determine how to group items in the view.
In the Totals section, select the column which you want to display summary calculations in the view, such as count, average, maximum, minimum.
In Item Limit section, type the number of items to display per page, default value is 50.
Then, click OK. Go to list collection web part page, and the view is created as following.
Click Gantt View in Choose a view page.
Specify View Name and View Audience.
Select the list and view to display in the view.
Specify Title, Start Date, Due Date, and Percent Complete fields.
In the Header Filter section,click checkbox Enable filter on header.
Specify the columns and their order in Columns section.
Then, click OK the Gantt View is as following.
In Choose a view section, click Calendar View.
Specify View Name and View Audience in the Name and Audience section.
Select the list and view in Filter section.
Specify view title and sub heading in the calendar Columns section,And select Don’t display list items checkbox.
Note:What can Don’t display list items checkbox do? If you click this checkbox, the Columns, Edit Menu, Header Filter and Group By sections will be hidden in the configuration part.
In Default Scope section, choose which scope type you want.
In Time Interval section, specify Begin and End date.
Then, click OK. The Calendar View is as following.
You can filter items according to conditions in the standard, project and calendar view. For instance, you want to display items which are assigned to Lily from the Task Schedule in the Gantt View.
Click the arrow in the From List column header of the web part, choose Task Schedule.
Click the arrow in the Assigned to column header, choose Lily.
The following is the result:
The filter function is the same as standard and calendar view.
You can manipulate items directly on list collection web part. Click the arrow that appears on the column and links to Edit Menu, you can manipulate the item as in list view web part.
The manipulation is the same both in gantt view and calendar view.
List collection web part supports adding items to different lists.
On New menu, you can choose which list you want to add item to. For instance, you can add an item to Task Schedule list in SharePoint Lists site.
The new item is added to Task Schedule list and also displayed on the calendar view of list collection web part.
Note: The new icon only display on the column which is linked to edit menu.
The operation is the same in both calendar and Gantt view.
SharePoint List collection supports two types of filter web part: Choice and Text.
On the Site Actions menu, click Edit Page. Add the choice filter web part on the page.
Click Modify Shared Web Part in the menu, and specify the Filter Name and choice options in the box.
Click OK to save the configuration. And click the Web Part menu go into Send Filter Values To, click the web part which you want to filter. Here we choose Cross-site list collection web part.
In the Configuration Connection dialog box, choose the Status column in dropdown list.
Click Finish button, and exit from the Edit Mode page.
Click browse button on the web part.
Choose Not Started radio button in the Select Filter Value(s) dialog.
Then click OK. The filter result is following.
The steps to configure Text Filter web part is the same as steps of configuring Choice Filter web part. You just need to input filter name and connect it to the column.
Input the filter value in the textbox, then the result is below.