Solved

SSRS - Windows User Name as Parameter

Posted on 2014-04-23
2
2,522 Views
Last Modified: 2014-04-23
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
Comment
Question by:Manju
[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
  • 2
2 Comments
 
LVL 6

Author Comment

by:Manju
ID: 40017547
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
 
LVL 6

Accepted Solution

by:
Manju earned 0 total points
ID: 40017583
got it too.., used =Right(User!UserID, Len(User!UserID) - InStr(User!UserID, "\"))
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say 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

Title # Comments Views Activity
sql syntax error 9 95
SSRS Reports - get rid of blank columns 3 78
how to calculate Quintiles in ssrs 3 55
SSRS 2013 - Creating a summarized report 19 57
A recent questions about how to add SSRS named instances, couldn't find any that talks about SQL server 2008, anyway I decided to help by creating some screen shots. The installation is straightforward, you just pop the SQL server 2008 installati…
It is helpful to note: This is a cosmetic update and is not required, but should help your reports look better for your boss.  This issue has manifested itself in SSRS version 3.0 is where I have seen this behavior in.  And this behavior is only see…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

740 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