SSRS - Windows User Name as Parameter

Team - I have a SSRS Report which pulls data from various tables in SQL.

Lets say Usertable is a table where  NTlogin, Name and team are saved.
Datatable is a table where ProjectNumber, Name, Details are saved.

The SSRS link has access to all users within the domain. What i need to do is.,

If I open the report, SSRS should get my username & fetch the Name column from the usertable & popoulate only the Projectnumber & Details matching Name column from Datatable.

How do i do this?
LVL 7
ManjuIT - Project ManagerAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
ManjuConnect With a Mentor IT - Project ManagerAuthor Commented:
got it too.., used =Right(User!UserID, Len(User!UserID) - InStr(User!UserID, "\"))
0
 
ManjuIT - Project ManagerAuthor Commented:
oh btw, i tried using "User!UserID" to get the windows username but it comes with domain name & "/". How do i get rid of that?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.