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   Relational Database Capabilities for SharePoint Lists		Product Documentation   Cross List Web Part Application Notes Online   Screencasts & Featurecasts Sign up for a FREE Bamboo Webinar Customer Use Cases Submit your use case
	Knowledge Base Articles

Recent Cross List Web Part Forum Posts

high fashion is esay (0 replies) - Welcome to visit our company site http://www.vegov.com we Wholesale and retail the following products：clothing&fashion T-Shirt,Hoodies, Jeans,for man，women, and kids.Jacket, Trousers & Pants, Underwear,... Latest post by vegov33, 7/2/2009 10:45:36 AM Cross List Source Edit Documentation (1 replies) - I have searched the internet and this site and can not find any guides for customizing the Cross List Edit Source dialog. Is there any documentation available? If not can you give me some details of... Latest post by Jeff Kozloff, 6/9/2009 3:49:25 PM Parent lists showing ok. Lookup lists showing "none" (2 replies) - Hi, I have downloaded and installed the trial of cross list web part. I have added the web part and gone to modify it. When I select parent list, I can see all my lists for my site but when I go to lookup... Latest post by blackprint, 5/26/2009 9:55:27 AM Multiple Instances Cross List WP on 1 page (2 replies) - Hi Bamboo, Can someone tell me if it is possible to have multiple instances of the Cross List WP on 1 page? I have that now but the export to Excel does not work properly anymore, it shows data from the... Latest post by Adriaan, 5/8/2009 10:24:00 AM "There is no data to display" message (3 replies) - Hi, I have one "Task" list with a lookup to the title column in a document library called "Task Docs". I can see and configure it, but when the result is displayed I get "There... Latest post by DaisyAnand, 2/2/2009 4:42:18 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.