none
Display Task Duration in Reports RRS feed

  • Question

  • Hello,

    Is there a way to see what logic the project Server 2010 client displays duration and mimic that in a report that pulls data from the Reporting Database? The client will show the task duration in days, months and sometimes hours.

    I understand the TaskDuration field in the Reporting Database MSP_EpmTask_UserView displays the value in hours. I want to convert that to display it in the same format as the client does, whether it is hours, days or months so that end users of the report see the same numbers.

    Any help is appreciated!

    Tuesday, December 8, 2015 10:23 PM

All replies

  • Hi BananaQuaalude,

    Do you mean you want to have a report that draws a Gantt Chart? If so, I've never really come across anything that does that


    Ben Howard [MVP] | web | blog | book | P2O

    Tuesday, December 8, 2015 10:41 PM
    Moderator
  • Hi,

    Yes it's quite easy.

    Duration is stored in the Reporting DB in the following format: 600.0M

    So, when you devide the field TaskDuration with 600, you will have the duration in hours. Multiply it by your working hours per day and you have the value in days, ...

    Regards,

    Philip


    Verlinden Philip | Twitter: @VerlindenPhilip | LinkedIn

    Friday, December 11, 2015 10:07 AM