Multiple site collections Dataview issues

I am trying to create a dataview on a site collection pulling data from a different list in a different site collection.I create the data view, connect to the site but can't see any of the lists or libraries in that site.
snazaireSharePoint AdminAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

I don't think that a dataview can go cross site collections. this would require development.
You can do it with Data View webpart,

But you can't do it with the Content Query web part.

The question is , if you have Mutiple site collections, do you have the same security roles for all.

But assuming that you have the security issues taken care of ,
Here is the SharePoint answer.

The solution is XML Web Services reference. instead of the List reference.


[1] Here is a the WSDL link

[2] You will need to get the Web ID and view ID these are guids , that you can get from STSADM or SPM2007  check SharePoint Admin 2007 on

[3] Operation is : GetListItems.

Here is a sample Query

           <FieldRef Name="ID" />

that would get all items from a list ordered by the ID.

That should work just fine.

It is a bit long , but that is SharePoint ...

PS: psv1973 let me know if you think that wouldn't work,

thank you all and Good luck,

George Gergues
SharePoint Architect.

I agree with psv1973. It is impossible to collect info across sites.
However you  can do that either through custom coding or third party tool like SharePoint List Collection.
Just for your information

Actually, if you're already a ShaPoint 2007 Designer user, it's very easy to create a data view which is feeding from multiple SharePoint lists.

1- Open SharePoint Designer 2007
2- Open your target web site which you're want to show you DVWP (Data View Web Part) on.
3- Navigate to Data Source Library from Data View menu or under the right pane.
4- Click on "Connect to another library..." link beneath "Current Site" section
5- Click on "Configure Linked Source..." button on the opened window
6- Specify a display name and the location of the data source (SharePoint site) where your list(s) are there
7- A new grouped link with the chosen name in step 5 will be added next to the Current Site section including all contents of the newly added site
8- Expand "Linked Sources" under Current Site and click on "Create a new Linked Source..."
9- Add all lists that you want to have a consolidated data source, by clicking "Add >>" button from Available Data Sources" to "Selected Data Sources"
10- Click "Next"
11- Select "Join the contents..." then click on finish
12- Click "OK"
13- Now you should see a new linked data source under "Linked Sources"
14- Click on it and select "Show Data"
15- Now under "Data Source Details" you should see a new data source called "dsQueryResponse" which includes  all row sets for those lists that you selected in step 9
16- From this point you should be able to continue simply as you do to insert a DVWP on your pages

Good luck!


Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
This works great within the same site collection. But as soon as I try to connect to a site outside the same site collection, no lists or libraries are shown.

Does anyone know why this could have happened?
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SharePoint

From novice to tech pro — start learning today.