Implement a new XML web service, in the web service, use the SharePoint API to merge or join two or more list. Then, in SSRS, retrieve data from the XML web service using XML data source type.

Well I think I'm totally lost with the XML-thing..

Basically I want to join multiple SP lists to use em as a data source in Report Builder 3.0. I'm using SharePoint 2010.

I know how to build the join query in LINQ/CAML. I've done it before using the SharePoint object-model API. So it wouldn't be a problem to do the same using the web services API.

But what about creating a new XML web service? Could someone guide me through this? Any good tutorials/examples from the very basics would be greatly appreciated.

  • Could you elaborate on what it is you are attempting to do? Also, what version of SharePoint are you using?
    – Dave Wise
    Apr 8, 2013 at 15:10
  • Let me apologize, I rephrased.
    – lephleg
    Apr 9, 2013 at 7:26

1 Answer 1


This article is a good start on creating Web Services that interact with the SharePoint object model. This provides the framework but you would obviously have to put in your code that does the union and returns the results as XML

  • Wow.. This really makes it look like an easy process.. I'll give it a try right away. Thanks Dave!
    – lephleg
    Apr 10, 2013 at 14:24

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.