Duration field data issue in Sql tables in Project server 2013 RRS feed

  • Question

  • Hi All,

    I want to add duration column to the my SSRS report, But the data was showing wrongly in the sql server pwa table.

    when i open project from ms project the duration was showing as 109.88 days but in the MSP_EpmProject_UserView or any other project tables the project duration was showing as 1359.5.

    Can any one please help me which table and column name i need to take for the duration.

    my environment is project server 2013 with latest August 2020 CU.

    Thank You, Kumar KSV

    Thursday, November 26, 2020 1:45 PM

All replies

  • kumar ksv,

    I do not use Project Server so I'm not familiar with the SSRS report or PWA, however understand that all time variables in Project's underlying database are in minutes. The Duration field you see in Project is a display value based on the minutes per day set in Project's options and also on the project calendar. Perhaps that's why you see a difference.

    Hope this helps.


    Thursday, November 26, 2020 3:38 PM