none
How to Create a Report that shows Summary Task Count based on some condition? RRS feed

  • Question

  • hi everyone,

    i need help in a sql query,i know that this question doesn't come under this Forum,but this query is related to project server 2010,that's why i have asked the question

    Scenario is

    There are 4 Summary Task in a Project(A,B,C,D),actually for my client these are Phases

    so what i need  is initially when Percent complete for all summary Task is 0%, i need the output A,when summary Task A gets 100% complete,i need output B,when summary Task B is between 0 and 99,i need output B,as soon as B gets 100% complete,i need output C,and when C is between 0 and 99,i need output C,and as soon as C gets 100% complete,i need output D

    This thing is Fixed that first Summary Task A will be started,then Summary Task B,then C and then D

    if anyone has any ideas,plz let me know,any help will be greatly appreciated

    Thanks

    Anuj

    Wednesday, March 13, 2013 5:16 AM