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.

	Blog Posts and User Forums Cross List Web Part Forum   Relational Database Capabilities for SharePoint Lists		Product Documentation Cross List Web Part Application Notes Online       Working for a U.S. Government agency or on behalf of one? See our Section 508 Compliance page for information regarding Bamboo product accessibility.   Screencasts & Featurecasts Sign up for a FREE Bamboo Webinar Customer Use Cases Submit your use case
	Knowledge Base Articles
	New Web License Manager Introducing Bamboo Web License Manager         Bamboo Web License Manager Use Case and FAQs         How to activate a Bamboo product via WLM         How to confirm the activation status/find a key with web licensing         Why am I unable to find my product listed in Bamboo's Web License Manager?         How to activate a Bamboo product via Web Licensing if my server(s) do not have internet access         How can I confirm whether or not my product supports web licensing?         Web License Manager Webcast         NEW trial period for Bamboo products!

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:

Recent Cross List Web Part Forum Posts

"There is no data to display" ERROR with SP lookup fields (0 replies) - Hi I have two linked lists COMPANIES & CONTACTS CONTACTS has a COMPANYID lookup field If i define COMPANYID as a standard SP lookup field, I can add all the fields of both tables, BUT i get... Latest post by philippehenri, 1/20/2010 10:37:19 AM Problems activating feature (1 replies) - Hi, I installed the Webpart on a MOSS, choosing one of two Applications. After twice getting an error concerning the web application ressources (in German, it said: ""Diese Lösung enthält... Latest post by Bamboo PM Girl, 9/24/2009 2:54:38 PM Customize CSS (0 replies) - I am trying to go into the Source Edit to make changes to the headers. I keep getting this message when hitting save. . "Message from webpage: Please enter XML format" Even if I open the... Latest post by JamieG, 9/18/2009 7:47:10 AM "There is no data to display" (0 replies) - I've configured the trial version per the attached screenshot. It looks like it should work, but I get the "There is no data to display" message. Latest post by jkoeppen, 9/4/2009 11:56:56 AM How many child lists can be referenced? (1 replies) - I got the impression that the Cross List Web Part could connect a parent list and two child lists. However, with the trial version I can only reference 1 child list. This works just fine but I need to... Latest post by ru1fdo, 8/28/2009 5:10:04 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.

System Requirements:

Release Notes:

January 2010	Release 1.5
October 2009	Release 1.4
September 2009	Release 1.3
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!