• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2105
  • Last Modified:

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

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
hmnpa
Asked:
hmnpa
1 Solution
 
dnsvhCommented:
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
 
hmnpaAuthor Commented:
Thanks Derrick,
Is there any way to make assembly and read the AD and use that assembly in SQL Reporting?
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now