Connecting an SSRS report to the Sharepoint 2010 UserProfileService RRS feed

All replies

  • Hi HaggardPete,

    Would like connect to sharepoint web service and use it as data source? Please correct me if my understanding is wrong.

    If in this case, please refer to the following link which has destails inforamtion about how to use a sharepoint web service as a data set.

    Consuming SharePoint 2010 Lists Data in the SSRS 2008 R2 Reports:

    Wednesday, January 25, 2012 7:56 AM
  • Hi Eileen

    Thanks for the help. Basically thats right, however I am having trouble formulating the request when it comes to  accessing the UserProfile service. I believe the User profile service is not quite the same as the standard sharepoint lists service. I was hoping someone would have done this already.


    Regards, Pete


    Thursday, January 26, 2012 10:25 AM
  • Hi Pete,

    I am afraid we cannot access the UserProfileService within an SSRS report directly, we might should access the service with application in programming, please refer to the following about how to uese the User Profile Service Web Service: 

    Please feel free to ask if you have any question.

    Wednesday, March 28, 2012 6:50 AM