Indeed Sergio, Of course much more difficult to manage, but fun to play with:)
In SPD, in the Datasource Library tab: Create a connection to another library Create New linked source > configure linked source Select the 2 lists (in your main site, and in the connected one) Select "merge the contents of the data sources" Then insert the dataview on your page 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 Sergio Otoya Sent: Thursday, 28 February 2008 19:34 To: listserver@ozMOSS.com Subject: [OzMOSS] RE: Join 2 List into 1 View Yes, I think SPD allows you to link lists through the datasources options and then create a dataview over that new source. regards, Sergio Otoya | Technical Director |livePoint | SharePoint Solutions E [EMAIL PROTECTED]<mailto:[EMAIL PROTECTED]>| w +61 2 9929 6333 | m +61 (0) 416 275 110 From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Hodgson, John Sent: Thursday, 28 February 2008 4:41 PM To: listserver@ozMOSS.com Subject: [OzMOSS] RE: Join 2 List into 1 View 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: listserver@ozMOSS.com 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: listserver@ozMOSS.com 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: listserver@ozMOSS.com 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 ------------------------------------------------------------------- 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