Solved

How to get User's full Name in SQL server reporting services.

Posted on 2006-06-27
4
1,920 Views
Last Modified: 2012-06-27
Hi,
I have to pass the user's full name into a parameter. I am able to get the userid from Globals.UserId but I am not able to get the user's full name.
Is there any way to get the user's full name (not userid) in SQL server reporting services.

Thanks
0
Comment
Question by:hmnpa
4 Comments
 
LVL 4

Accepted Solution

by:
dnsvh earned 250 total points
ID: 16996610
The answer is 'yes' and 'no'.  There is no built in function that will allow you to retrieve a user's full name.  However, through SQL Enterprise Manager, you can add Active Directory as a linked server and then write SQL statements against Active Directory to get the user's full name.  Here is an article that describes how to create Active Directory as a linked server:

http://www.codeguru.com/Csharp/Csharp/cs_data/searching/article.php/c9953/#more

Hope that helps.

Derrick
0
 

Author Comment

by:hmnpa
ID: 17003393
Thanks Derrick,
Is there any way to make assembly and read the AD and use that assembly in SQL Reporting?
0

Featured Post

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

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

How to increase the row limit in Jasper Server.
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

778 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