Solved

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

Posted on 2006-06-27
4
1,935 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

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

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.

Question has a verified solution.

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

Suggested Solutions

Hello, In my precious Article  (http://www.experts-exchange.com/Database/Reporting/A_15280-Create-Project-in-Microstrategy-Part-I.html)we saw the Configuration part for Microstrategy which included Metadata Creation and DataSource Preparation as …
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.
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…

829 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