none
SSRS Report - Programme ? RRS feed

  • Question

  • Hi, this is a continuation of a previous thread..I am trying to obtain the Project Type value so I can filter for just Master Project data only in a SSRS report.  When I add [Project Type] into a field within a row within a table in the report and then run it it returns the value of 0 for both projects and master projects.  My understanding is that it should return "6" for master projects, any ideas why it is not doing so?

    Thanks

    Steve

    Friday, January 22, 2016 10:02 AM

Answers

  • Hi Stev,

    Check the below query and see if this helps you. This is copied from the following thread -

    https://social.technet.microsoft.com/Forums/projectserver/en-US/1e9a4282-3275-4ba1-a627-f20faacec7bb/sql-reporting-from-master-projects?forum=projectprofessional2010general

    SELECT   ProjectUserView_Master.ProjectName AS MasterProjectName,
              
    FROM     MSP_EpmProject_UserView AS ProjectUserView_Master INNER JOIN
               MSP_EpmTask_UserView AS TaskUserView_Master ON ProjectUserView_Master.ProjectUID = TaskUserView_Master.ProjectUID INNER JOIN
               MSP_EpmProject_UserView AS ProjectUserView_Sub ON TaskUserView_Master.TaskName = ProjectUserView_Sub.ProjectName INNER JOIN
               MSP_EpmTask_UserView AS TaskUserView_Sub ON ProjectUserView_Sub.ProjectUID = TaskUserView_Sub.ProjectUID
    WHERE   (ProjectUserView_Master.ProjectType = 6)

    If above example query doesn't help then could you let us know your query with result set and desired output?


    Cheers, Badal Ratra MCTS


    • Edited by Badal Ratra Friday, January 22, 2016 11:02 AM
    • Marked as answer by Stev Scott42 Friday, January 22, 2016 11:23 AM
    Friday, January 22, 2016 11:01 AM

All replies

  • Hi Stev,

    Check the below query and see if this helps you. This is copied from the following thread -

    https://social.technet.microsoft.com/Forums/projectserver/en-US/1e9a4282-3275-4ba1-a627-f20faacec7bb/sql-reporting-from-master-projects?forum=projectprofessional2010general

    SELECT   ProjectUserView_Master.ProjectName AS MasterProjectName,
              
    FROM     MSP_EpmProject_UserView AS ProjectUserView_Master INNER JOIN
               MSP_EpmTask_UserView AS TaskUserView_Master ON ProjectUserView_Master.ProjectUID = TaskUserView_Master.ProjectUID INNER JOIN
               MSP_EpmProject_UserView AS ProjectUserView_Sub ON TaskUserView_Master.TaskName = ProjectUserView_Sub.ProjectName INNER JOIN
               MSP_EpmTask_UserView AS TaskUserView_Sub ON ProjectUserView_Sub.ProjectUID = TaskUserView_Sub.ProjectUID
    WHERE   (ProjectUserView_Master.ProjectType = 6)

    If above example query doesn't help then could you let us know your query with result set and desired output?


    Cheers, Badal Ratra MCTS


    • Edited by Badal Ratra Friday, January 22, 2016 11:02 AM
    • Marked as answer by Stev Scott42 Friday, January 22, 2016 11:23 AM
    Friday, January 22, 2016 11:01 AM
  • Thanks Badal, very helpful and should be just what I need.

    Cheers

    Steve

    Friday, January 22, 2016 11:22 AM