List Rollup Web Part for SharePoint lets you easily provide group, departmental, or division level status to your manager by creating a rolled up, real-time, single view of multiple lists across sites.

The List Rollup Web Part consolidates various SharePoint list items from multiple sites and areas into a single real-time data view 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 re-use or modification in creating other rolled up views based on the same list data:

• 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.
• Automatically find and roll up Lists using automatic site discovery traversals.
• Ability to add List Rollup Data Views to the Web Part Page Gallery on creation.
• Use rolled up Data Views with Bamboo Solutions' Alert Plus.
• Use rolled up Data Views with Bamboo Solutions' Chart Plus.

The List Rollup Web Part rolls up selected lists into a single DataView Web Part. To create this DataView Web Part, 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 Web Part is created in the Web Part Page Gallery for that page. You can navigate to the Web Part 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 Web Part to a page, just import the Web Part through Modify Shared Page > Add Web Parts > Import.