Duration field data issue in Sql tables in Project server 2013.

Copper Contributor

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.

 

duration1.JPGduration2.JPG

   

 

 

 

0 Replies