SSRS - Windows User Name as Parameter
Posted on 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?