SharePoint List – Allow Users to Combine SharePoint Lists

Put the power of data aggregation into the hands of your users.

Set a default rollup view for users to modify, or allow users to create their own rollup from scratch.

List Consolidator for Users Web Part offers users a way to quickly create a single aggregated view of the data most important to them across project sites. With a simple, easy to use 5-step configuration, each user can easily create views to meet their specific needs within the confines of a single Web Part --and without making requests to a SharePoint Administrator. No complicated XSLT code required, navigating to multiple sites to update data, or requiring users to have Designer rights to project sites. A SharePoint Administrator simply installs the Web Part into the SharePoint Farm and then adds the List Consolidator Web Part to any existing Shared Web Part page. That is all it takes! Using a familiar SharePoint List View configuration screen, users then define what data they want to view and how it is displayed. With the default rollup view feature, the SharePoint Administrator also has the option to define a default aggregated view for all users --providing them with a starting point for customizing the view.

List Consolidator for Users

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.

Organizations today are moving away from the tedious processes of tracking project details, such as day-to-day tasks, events and project documents, using common systems like paper, miscellaneous desktop applications, e-mail, and network directories. Looking to help users spend less time finding information and more time using information to make informed decisions, organizations are choosing to use the out-of-the-box collaboration features of SharePoint. However, with the ability to create dedicated SharePoint Sites for each project in an organization, Project Managers are required to constantly navigate from one project site to another simply to update and review existing project data. This process prevents organizations from reaching the productivity and user acceptance goals they set out to achieve with SharePoint.

While List Consolidator for Users allows users to update project tasks (or any list items) from a single, aggregated task view, it can also do the following:

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.