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

%3CLINGO-SUB%20id%3D%22lingo-sub-1879692%22%20slang%3D%22en-US%22%3EDuration%20field%20data%20issue%20in%20Sql%20tables%20in%20Project%20server%202013.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1879692%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20All%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20want%20to%20add%20duration%20column%20to%20the%20my%20SSRS%20report%2C%20But%20the%20data%20was%20showing%20wrongly%20in%20the%20sql%26nbsp%3B%20server%20pwa%20table.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ewhen%20i%20open%20project%20from%20ms%20project%20the%20duration%20was%20showing%20as%20109.88%20days%20but%20in%20the%26nbsp%3BMSP_EpmProject_UserView%20or%20any%20other%20project%20tables%20the%20project%20duration%20was%20showing%20as%201359.5.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20any%20one%20please%20help%20me%20which%20table%20and%20column%20name%20i%20need%20to%20take%20for%20the%20duration.%3C%2FP%3E%3CP%3Emy%20environment%20is%20project%20server%202013%20with%20latest%20August%202020%20CU.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22duration1.JPG%22%20style%3D%22width%3A%2085px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F233121i4746282568749FED%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22duration1.JPG%22%20alt%3D%22duration1.JPG%22%20%2F%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22duration2.JPG%22%20style%3D%22width%3A%2087px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F233120i3B6E753312DEF4A2%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22duration2.JPG%22%20alt%3D%22duration2.JPG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%20class%3D%22%22%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CDIV%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%20class%3D%22%22%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

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