<div>
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.<br />

</div>


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.


<div>
I figured it out - sorry to bother you with my silly ramblings...<br />
<br />
:D
</div>


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

:D

<div>
Answer: ms-help://MS.SQLCC.v9/MS.S<wbr />QLSVR.v9.e<wbr />n/rptsrvr9<wbr />/html/d234<wbr />08e5-e65b-<wbr />4f49-a98f-<wbr />234454d5d2<wbr />67.htm <br />
<br />
in the BooksOnline had everything i needed. Thought I'd post the answer that helped me consume an AD webservice.<br />
<br />
<br />

</div>


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.




<div>
<div class="content wysiwyg-content">
First time trying this...here goes.<br />
<br />
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. &nbsp;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. &nbsp;How do I get the report to hit the web service for the groups and use the returned xml to filter the data? &nbsp;<br />
<br />
TIA<br />
--joe <br />

</div>
</div>


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?  

TIA
--joe 


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

A database report is the formatted result of database queries and contains useful data for decision-making and analysis. Most good business applications contain a built-in reporting tool; this is simply a front-end interface that calls or runs back-end database queries that are formatted for easy application usage.