In WSS v2 we were able to open FrontPage, add a DataView WebPart, enter the location for another site collection in our farm in the Data Source settings and then format the DVWP to show content from lists and libraries on the other site. Although the concept is the same, WSS v3 (& MOSS) no longer works quite the same way!
After adding the datasource for the source site collection, SharePoint Designer shows 5 types of data that you can pull in:
-
Database Connections
-
XML Files
-
Server-side Scripts
-
XML Web Services
-
Linked Sources
You no longer see SharePoint Lists or SharePoint Libraries. You only get to use those datatypes if the source list is within the same site collection as the page you are adding the DVWP to. It took quite a while fighting with SharePoint designer trying to get these lists to show up before I found the answer that it is no longer possible from the Microsoft Office Online site: Add another SharePoint site to the Data Source Library.
ARGH! Why remove this functionality?! It breaks all DVWP's that were created in WSSv2 using it!
The work-around? Use the SharePoint Web Services, or the RSS webpart.... Any others?
As a reminder, the Lists web service can be found here: http://{site}/_vti_bin/Lists.asmx
<Monty />