Solved

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

Posted on 2006-06-27
4
1,998 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Want Experts Exchange at your fingertips?

With Experts Exchange’s latest app release, you can now experience our most recent features, updates, and the same community interface while on-the-go. Download our latest app release at the Android or Apple stores today!

Question has a verified solution.

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

Hi, In my previous Article  (http://www.experts-exchange.com/Database/Reporting/A_15199-Introduction-to-Microstrategy.html)I discussed some basic understanding of Microstrategy that how we can get in Intro of Microstrategy (MSTR). Now it's tim…
I recently went through setting up a JasperReports Server using the AWS EC2 instance, and this article will cover some basic administration tasks I had to perform.
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…

627 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