1

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.

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

1 Answer 1

Reset to default
0

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

Improve this answer
1
  • Wow.. This really makes it look like an easy process.. I'll give it a try right away. Thanks Dave!
    – lephleg
    Commented 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.