Pull together and view information from multiple lists quickly and easily for on-the-spot reporting and analysis. The Cross List Web Part combines and presents data associated to a Sharepoint List through Lookup columns. Lookup columns allow you to use information from a column in a second list as drop-down values for the lookup column in the parent list. The Cross List Web Part uses this association to allow you to pick not just the lookup column data, but any column data from the parent list and up to two lookup lists for presentation in a single list view. You can sort the data to target relevant information for your team as well as create a printer friendly view or Microsoft Excel spreadsheet of the list for reporting and analysis. The Cross List Web Part allows you to choose just the information you need and display the consolidated data into one "joined" view.
Cross List Web Part vs. SharePoint Out-of-the-Box Functionality SPS 2003, WSS 2.0 MOSS 2007, WSS 3.0 Bamboo Cross List Aggregate data from a variety of lists into a single view     • Aggregate data from parent list and child lists as linked through the "lookup" fields     • Sort data in the consolidated view     • Filter the Web Part based on parent and/or lookup list filters - New!     • Edit the CSS for the Web Part to style data in the format you need - New!     • Rename the column headings in the Web Part - New!     • Export Cross List items to Microsoft Excel - New!     • Print user friendly version of data in consolidated view - New!     • Provide your own translation of the Web Part user interface and tool pane - New!     •
Let’s say you have a Task List (Parent List A), a User Information list (Lookup List B), and a Project List (Lookup List C). Your manager has asked you to provide a quick status on all tasks including the task name, assigned user name and the user’s email address, the associated project name and project status. Using the Cross List Web Part and lookup fields, you can choose the data you need from the Task List as well as any data you need from the Project List and the User Information List (see diagram below) - not just the data from the lookup columns.
Organizations use SharePoint today to build quick and efficient collaboration portal web sites. As the use of SharePoint grows, IT is being asked to build new applications as an alternative to the traditional database, with the ability to integrate with legacy data to provide a single point of information access. One of the main attractions of SharePoint is the ability to quickly create standard Lists to support different types of tasks. Developers that are familiar with classic database design are using "lookup" fields within lists to architect relational structured data instead of using a flat data structure. SharePoint does not provide a capability to display data from multiple joined lists, even when look up fields are used as index keys into a foreign list.

System Requirements:

Release Notes:

July 2008	Release 1.2
September 2007	Release 1.1
November 2006	Release 1.0
	View our release notes here: http://store.bamboosolutions.com/kb/article.aspx?id=10199

Download Instructions:
To purchase the web part or download the trial software, please add the appropriate product from the table below into your shopping cart and proceed through the check out process. You will have to register and create an account in the storefront so that we can send you the download email. There are no payment, shipping charges, or taxes on the trial download. Once you receive our email, you should be able to download and install the software within minutes. Make sure you download and refer to the application notes for detailed installation instructions.

Installation Instructions:
Complete installation instructions and an usage guide for this web part are included in the Application Notes below. Please make sure you download and read them prior to installing the web part. In addition to the Application Notes, potential installation problems are also documented in our Web Part Deployment and Security FAQ, which can be downloaded here.

Bamboo Community Site:
Please visit our community site where you can read more about our products. Community support, questions and feedback can be founded in our online forums.

Support Instructions:
Please email us at support@bamboosolutions.com and visit our Knowledge Base for additional information on bug fixes, enhancements and release notes at http://store.bamboosolutions.com/kb/.  Our support hours are from 9 AM to 6 PM US EST (GMT-5), and 9:00 to 18:00 Central Europe Time (GMT+1).  For more information about our support plans, visit our customer support page.

Your Thoughts:
Your feedback on this web part is important to us as we make every effort to meet your needs. Email us at sales@bamboosolutions.com. Thank you!

How-To Articles:

Read the Use Cross List Web Part to display data from multiple lists when referenced by lookup fields. A Step By Step Guide.

Knowledge Base Articles:

	Blog Posts and User Forums Cross List Web Part Forum		Product Documentation Cross List Web Part Application Notes.pdf Screencasts & Featurecasts Customer Use Cases Submit your use case
	Knowledge Base Articles

Recent Cross List Web Part Forum Posts

Cross List Custom HTML Edit Issue (1 replies) - Our MOSS intranet is behind ISA 2006, using FBA.  All users are outside the firewall.  MOSS/WSS web services are blocked at the firewall.  Using the Cross-List Web Part, we... Latest post by Chris Dooley, 7/18/2008 1:20:25 PM

Post a New Message | View All Posts | Explore All Forums

At Bamboo Solutions, we are constantly innovating, always improving our products to serve you better. Help us improve this product by suggesting a feature enhancement, or just by voting on the ideas other customers have proposed. Your feedback truly guides our product development effort. To report a suspected bug, rather than suggest a new feature, please click here. Use our product forums for additional questions, please click here.