Our entire SharePoint web part listing.
Click on the Web Part to read a more detailed description
The List Rollup Web Part consolidates various SharePoint list items from multiple sites and areas into a single real-time DataView with the ability to filter and sort information as needed. You can define which lists and views are included as well as apply CAML filtering as needed. You can also select a master list for all selected lists to conform to for content and formatting. Save templates for resuse or modification in creating other rolled up views based on the same list data.
| List Rollup Webpart vs. SharePoint Out-of-the-Box Functionality |
SPS 2003, WSS 2.0 |
MOSS 2007, WSS 3.0 |
List Rollup |
| Aggregate data from a variety of lists and libraries (e.g. tasks, priorities, issues) into a single master view. Includes support for Document, Image and Forms Libraries. | - | - | |
| Define which lists are included in a rollup view. | - | - | |
| Select different columns from each list for inclusion in the roll-up view, using similar display names. | - | - | |
| Apply full dataview formatting to the rollup view: filter, apply conditional formatting, sort, etc. | - | - | |
| Rollup data across site collections on the same SharePoint Server. | - | - | |
| Maintain list level item security in the rollup view. | - | - | |
| Include the Item Location column in the rolled up Data View to link to the site that the item originated from. | - | - | |
| Use rolled up Data Views with Alert Plus. New! | - | - |
The List Rollup Webpart rolls up selected lists into a single DataView Webpart. To create this DataView Webpart, select a site or area, and then a list and a view, add CAML filtering (optional), and then add the list or view to the Included Lists box. Repeat these steps until all lists have been selected. Then select one of the included lists to be the Master List to determine formatting and the columns to be included in the DataView, type a name for the DataView, and click Create. The rolled up DataView Webpart is created in the Webpart Page Gallery for that page. You can navigate to the Webpart Page Gallery and drag and drop the DataView on this page to view the results. Once you have the DataView the way you want it and you are ready to share it with your users, you can Export it and save it to your desktop or any network location of your choosing. When you want to add the DataView Webpart to a page, just import the Webpart through Modify Shared Page > Add Webparts > Import.
One of the major attractions of implementing SharePoint is the flexibility to create multiple sites and areas. This gives the IT department the ability to centrally control the server, databases and security, and at the same time allows each department or group the ability to manage their own sub-sites. As the usage of SharePoint increases, there is a proliferation of SharePoint sites to manage. This makes it harder for users to keep track of which tasks and documents are located in which sites because in SharePoint today, there is no easy way to see a unified view of such information.