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

Posted on 2006-05-10
Medium Priority
Last Modified: 2008-03-06
First time trying this...here 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?  

Question by:joesladek
  • 4

Author Comment

ID: 16658519
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.

Author Comment

ID: 16659065
I figured it out - sorry to bother you with my silly ramblings...


Author Comment

ID: 16660629
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.


Author Comment

ID: 16756243
still open?!?

Accepted Solution

EE_AutoDeleter earned 0 total points
ID: 16839612
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.


Featured Post

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Hi, I am very much excited today since I'm going to share something very exciting Tool used for Analytical Reporting and that's nothing but MICROSTRATEGY. Actually there are lot of other tools available in the market for Reporting Such as Co…
Hi, In my previous Article  (http://www.experts-exchange.com/Database/Reporting/A_15199-Introduction-to-Microstrategy.html)I discussed some basic understanding of Microstrategy that how we can get in Intro of Microstrategy (MSTR). Now it's tim…
We’ve all felt that sense of false security before—locking down external access to a database or component and feeling like we’ve done all we need to do to secure company data. But that feeling is fleeting. Attacks these days can happen in many w…
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…
Suggested Courses

831 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question