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

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?
0
Manju
Asked:
Manju
  • 2
1 Solution
 
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
 
ManjuIT - Project ManagerAuthor Commented:
got it too.., used =Right(User!UserID, Len(User!UserID) - InStr(User!UserID, "\"))
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.

Join & Write a Comment

Featured Post

Introducing Cloud Class® training courses

Tech changes fast. You can learn faster. That’s why we’re bringing professional training courses to Experts Exchange. With a subscription, you can access all the Cloud Class® courses to expand your education, prep for certifications, and get top-notch instructions.

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