SharePoint List – SharePoint List Aggregation for Power Users

Automatically collect, filter, and sort items from multiple SharePoint lists -- all across your portal -- in real time.

The List Rollup Schema Designer takes data aggregation beyond the confines of the SharePoint Content Query Web Part all without requiring any custom coding. Here are some of its features:

Intuitive Interface to Build Powerful List Rollup Schemas
Schemas are used to determine which items from which lists display in the rollup.
Various Discovery Methods Available
Define included lists by selecting individual lists or automatically discovering lists in either sub-sites or all sites in a site collection.
Standardized Data Format
Through selection of master columns, columns of type Number and Date and Time are standardized for easier data mining processes.
Supports Multiple Selection Lookup and People and Group Column Data Types
Unlike SharePoint Contend Query Web Part, return data for column data types Lookup and People and Group that has Multiple Selections enabled.

Try List Rollup 5.0 and rollup and show all your Task Lists within a site in just minutes!

List Rollup Schema Designer

Seeking to aggregate nonstandardized data? List Rollup Classic Edition is your solution.

List Rollup Classic Edition Web Part

Aggregate Data From Different List Types
Aggregate data from a Calendar list with data from a Custom list.
Join Different Column Data Types
Join columns of data type Number with columns of data type Single Line of Text.
Join Columns Based On Display Name
SharePoint Content Query Web Part requires columns to have the same internal name to be joined, with List Rollup Classic Edition, join columns based on the current display name.
Discover Lists Based on List Name
Discover lists based on not just List Type but also List Name. Great for sites with multiple Calendar or Task lists.

Interested in seeing List Rollup Web Part in action within a real application? Jump over to SharePoint Project Management Central to see how List Rollup Web Part conveniently aggregates data across projects into a top level project management site.

Which Bamboo Rollup Product Should I Use?

List Consolidator for Users is a simplified, basic version of List Rollup. It contains the most commonly used end-user features of a SharePoint data aggregation tool. Use this product to offer your end users an easy and quick way to rollup a small number of lists (typically 10 lists or less) on an ad-hoc basis without having to grant higher SharePoint user permissions.

List Rollup* includes the following Web Parts:

List Rollup (Schema Designer) is the next generation of the Bamboo List Rollup - Classic. A new, simplified user interface and backend architecture for creating rollups paired with a grid view Web Part output for easy manipulation of the data, offers a comprehensive feature set of data aggregation functionality that meets small to enterprise level business intelligence needs.

List Rollup - Classic is the original Bamboo List Rollup. This product offers the same features of the List Rollup Schema Designer and almost all of the List Consolidator for Users but also offers one extra feature: Rollup list data from different data types. With this product, you can rollup data from a Number column type into a Single Line of Text column type.

* Both List Rollup Schema Designer and List Rollup Classic Edition are included with the purchase of List Rollup Web Part.

For more detailed information, a feature comparison table is listed in the What Does It Do? section below.

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. Below is a comparison chart between Bamboo List Rollup Schema Designer, Bamboo List Rollup Classic Edition and SharePoint Content Query Web Part (available in MOSS 2007 only):

Key Feature	Bamboo List Consolidator for Users	Bamboo List Rollup Schema Designer	Bamboo List Rollup Classic	SharePoint Content Query Web Part
Include Individual Lists in Aggregation
Automatically discover Lists of same List Type in all subsites
Automatically discover Lists of same List Type in a Site Collection
Automatically discover Lists of same List Type in sibling sites
Automatically discover Lists of same List Name
Aggregate lists of different list types
Join columns of different data types
Exclude individual lists from rollup
Include List and Site Names in item rows
Specify which columns to display in the aggregated list view
Support Multiple Selection Lookup & People and Group columns
Display aggregated data in calendar views
Display aggregated data in chart views
Have aggregated data searchable
Export aggregated data
Run time options in the grid view
Display aggregated data in a grid view with conditional formatting
Allow end users to define their own rollups
Set a default skin or customize the CSS
Translate to any language
Set a default rollup for all users to view and modify while requiring no special SharePoint permissions.