none
Project Server 2013 SSRS reports by logged in user RRS feed

  • Question

  • Hi All,

    We are using Project Server 2013. We have developed a project list SSRS report which list all active projects. I want display the project list based on the user logged in. i.e. if a project manager logged in it should only his projects.


    Thanks in advance, taj



    • Edited by arun_2014 Wednesday, May 21, 2014 7:25 PM
    Wednesday, May 21, 2014 7:23 PM

Answers

All replies

  • Hi,

    I did someting similar 2 years ago for Project Server 2013. I create a Data Source, Type XML, connection string "...PWA/_vti_bin/psi/project.asmx" with integrated security. I created a data set with above data source with query of type text like

    <Query>
       <Method Namespace="http://schemas.microsoft.com/office/project/server/webservices/Project/" Name="ReadProjectStatus"/>
    <SoapAction>http://schemas.microsoft.com/office/project/server/webservices/Project/ReadProjectStatus</SoapAction>
     <ElementPath IgnoreNamespaces="true">ReadProjectStatusResponse/ReadProjectStatusResult/diffgram/ProjectDataSet/Project</ElementPath>
    </Query>

    This is using web services ReadProjectStatus, which does only list projects, the user is allowed to open. See http://msdn.microsoft.com/en-us/library/office/gg210536(v=office.15).aspx for more. So another data set, which allows filter data.

    Perhaps this gives you at least a starting point?

    Success!
    Barbara


    To increase the value of this forum, please mark the replies that helped to solve your issue as answer. If you find answers to questions from other forum participants to be helpful, please mark them as helpful. Your participation will help others to find an appropriate solution faster. Thanks for your support!

    Wednesday, May 21, 2014 8:02 PM
    Moderator
  • With an excellent advice from Barbara just wanted to add a little bit

    You can also use the SSRS property User!UserID(available OOB) in parameter, which gives you the network ID of current logged in user,

    which you can use to filter the result set upon joining the project user view and resource user view to get the ResourceNTAccount and comparing against


    Wednesday, May 21, 2014 9:17 PM
    Moderator
  • Hi,

    Thanks, we tried with User!UserID property, we have received a message that "value not available" , it there is an prerequisites need to be done.


    Thanks in advance, Taj


    • Edited by arun_2014 Thursday, May 22, 2014 11:45 AM
    Thursday, May 22, 2014 11:45 AM
  • No prerequisites for this default global property available within SSRS Check this http://msdn.microsoft.com/en-us/library/dd255216.aspx

    See below for example

    http://blogs.wrox.com/article/filtering-user-specific-report-data-in-sql-server-reporting-services/


    Thanks | epmXperts | http://epmxperts.wordpress.com

    • Marked as answer by arun_2014 Tuesday, May 27, 2014 9:19 AM
    Thursday, May 22, 2014 1:04 PM
    Moderator
  • Thanks for your help. The parameter default value needs to be configured with User!UserID

    Thanks in advance, taj


    • Edited by arun_2014 Tuesday, May 27, 2014 9:20 AM
    Tuesday, May 27, 2014 9:20 AM