Monday, March 05, 2012 9:07 AM
I was able to combine two lists in same site collection using SPD and DVWP.
Is it possible to combine two lists from different site collections using SPD and DVWP?
Monday, March 05, 2012 9:38 AM
The following blog posts might help you
Monday, March 05, 2012 9:51 AM
Thanks Prasath, i looked at the link but isn't it the same site collection?
im looking for different site collection.
Monday, March 05, 2012 10:08 AM
Did you check this post, there seems to be some options to achieve this, please check if this can help you
Monday, March 05, 2012 12:37 PM
I got this when i follow the instruction,
when i clicked Show Data this is the error returnedThe server returned a non-specific error when trying to get data from the data source.
Check the format and content of your query and try again.
If the problem persists, contact the server administrator.
Tuesday, March 06, 2012 12:35 AM
If you are using SharePoint 2007, the above link clearly explains the solution. I have done this multiple times in SharePoint 2007. Try do created the linked source again and re-create your web part.
If you are using SharePoint 2010, this option is ruled out.
- Marked As Answer by Jack-GaoMicrosoft Contingent Staff, Moderator Friday, March 16, 2012 10:59 AM