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

Posted on 2006-05-10
Last Modified: 2008-03-06
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?  

Question by:joesladek

    Author Comment

    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

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


    Author Comment

    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

    still open?!?

    Accepted Solution

    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 your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    1. Set up your parameter at the report level as usual, check the box Multi-value, and set the Data Type to String 2. Set the Stored Procedure Parameter to varchar(max)  --<---- This part here is the key to it's success Example:    @cst_key var…
    Jaspersoft Studio is a plugin for Eclipse that lets you create reports from a datasource.  In this article, we'll go over creating a report from a default template and setting up a datasource that connects to your database.
    Sending a Secure fax is easy with eFax Corporate ( First, Just open a new email message.  In the To field, type your recipient's fax number You can even send a secure international fax — just include t…
    This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.

    746 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

    Need Help in Real-Time?

    Connect with top rated Experts

    14 Experts available now in Live!

    Get 1:1 Help Now