SharePoint Designer has this ability too, SPD allows a merge or a join from memory... John Hodgson Lead Solution Consultant HP Consulting & Integration 0411 242 880 mobile | [EMAIL PROTECTED]<mailto:[EMAIL PROTECTED]>
www.hp.com<http://www.hp.com/> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Hans Molleman Sent: Thursday, 28 February 2008 11:15 AM To: [email protected] Subject: [OzMOSS] RE: Join 2 List into 1 View In addition, CorasWorks can do that as well: http://www.corasworks.com/Products/WorkplaceSuite/Features/rollups.asp Hans Molleman | SharePoint Consultant |livePoint | SharePoint Solutions E [EMAIL PROTECTED]<mailto:[EMAIL PROTECTED]>| w +61 2 9929 6333 | m +61 (0) 449 09 909 5 From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ishai Sagi Sent: Thursday, 28 February 2008 10:43 To: [email protected] Subject: [OzMOSS] RE: Join 2 List into 1 View This is called aggregation, and there are alot of solutions on the market for that. A built in one in moss is the content query web part. But the thing with that one is that it aggregates based on the type of content or metadata of the content, and not based on location (you cant point to two lists and say "just these two"). So if you are happy enough with joining all items that are in all lists of type X, I'd say go with that one. An example of a good 3rd party aggregator that does do what you want (can connect to any list type) is http://www.kwizcom.com/ProductPage.asp?ProductId=175&ProductsubnodeId=176 A second good one that does it is http://www.omnisys.co.il/main.asp?lngCategoryID=2555 From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of MacDonald, Mike Sent: Thursday, 28 February 2008 2:42 AM To: [email protected] Subject: [OzMOSS] Join 2 List into 1 View Does anyone know how to pull information from 2(or more) separate lists and combine that information into one view? For example I have some list items in List A that I want to combine with some items in List B to make one view? I am trying to cut down on the number of lists that I create :) Thank you, Mike ------------------------------------------------------------------- OzMOSS.com - to unsubscribe from this list, send a message back to the list with 'unsubscribe' as the subject. Powered by mailenable.com - List managed by www.readify.net ------------------------------------------------------------------- OzMOSS.com - to unsubscribe from this list, send a message back to the list with 'unsubscribe' as the subject. Powered by mailenable.com - List managed by www.readify.net ------------------------------------------------------------------- OzMOSS.com - to unsubscribe from this list, send a message back to the list with 'unsubscribe' as the subject. Powered by mailenable.com - List managed by www.readify.net ------------------------------------------------------------------- OzMOSS.com - to unsubscribe from this list, send a message back to the list with 'unsubscribe' as the subject. Powered by mailenable.com - List managed by www.readify.net
