Capture NT ID of Logged in user as a parameter in MS SSRS Report RRS feed

  • Question

  • Hi,

    I would like to get the NT id of the Logged user as a parameter for SSRS Report. The SSRS Report is querying the Reporting database of MS Project Server 2010.

    The NT id would be used as a parameter to Query the projects of the user. The Login user id would be used to get resourced and other Query data. However, I am unable to get the NT id or login id the Query for SSRS Report designer.

    Any help in this regard would be appreciated.

    • Edited by Abhijit PS Monday, November 10, 2014 4:02 PM Question had to be changd
    Monday, November 10, 2014 3:59 PM

All replies

  • Abhijit,

    The user NT Account is stored in the MSP_EPM_ResourceView. 

    However, if you want to use this with the current logged in user, then you need to develop the report, with the user as the parameter, then place it on a web part page, add the Current User Filter webpart to the same page, and connect both. 

    Not sure if this is what you are looking for?


    Prasanna Adavi, Project MVP

    Blog:   Podcast:    Twitter:    LinkedIn:   

    Tuesday, November 11, 2014 3:52 PM