sql server reporting services: Hi. I'm new to SQL Reporting Services and totally self taught so far.
I am trying to find out if there is a way from within a report to find
out the Active Directory user name or possibly other data from AD about
the user running the report from the web. I want to be able to look at
the user and rstrict the data they are allowed to see based on AD
characteristics. This is for a school district and I want teachers to
be able to go to the web page, run a report, but return only data fro
their students. Thanks in advance for any help.

You get the AD username by from the global constant User!UserID. It returns
the username in the form of domain\username.

If you store the AD username of each teacher and a reference to what
students belong to them, you can use this for a query to only return the
data from their students.

I've never tried to query data in the Active Directory through Reporting
Services, but if you look at SQL tutorials, you might find something on how
to query AD data from the usual SQL server tools.
You need to check for information on ADSI

Here are a few links. I haven't tried them myself, but it might give you a
start
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q299410

http://www.databasejournal.com/features/mssql/article.php/2176561

Kaisa M. Lindahl Lervik


[quoted text, click to view]