Using ADSI as datasource in MS-SQL Reporting Service for data-driven subscription or filtering

First time trying goes.

I've got some reports on which the data must be specific to the region that a user is from, the user is in a group in AD that specifies which region they are from.  I know I can get their User!UserId on the report - I've even got a nifty AD web service that returns AD groups based on user id.  How do I get the report to hit the web service for the groups and use the returned xml to filter the data?  

Who is Participating?
Because you have presented a solution to your own problem which may be helpful to future searches, this question is now PAQed and your points have been refunded.

joesladekAuthor Commented:
I'm going down the path of using AD as an additional datasource - still looking for any assistance to speed up my progress...I think it SHOULD be possible for a reporting service to consume another web service, but I haven't been able to find a good reference yet.
joesladekAuthor Commented:
I figured it out - sorry to bother you with my silly ramblings...

joesladekAuthor Commented:
Answer: ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/rptsrvr9/html/d23408e5-e65b-4f49-a98f-234454d5d267.htm

in the BooksOnline had everything i needed. Thought I'd post the answer that helped me consume an AD webservice.

joesladekAuthor Commented:
still open?!?
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.