This report option will enable the PMO better track and report project progress of all running projects in their project portfolio.

Layout : Progress Report

Quickgrid : Progress Report

ticket : https://sbs-support.solvay.com/a/tickets/4053973

BRD https://docs.google.com/document/d/1cyRF39y8r1gfWK2dJ4oS0nXEaB_o938Xf-bopSP07yk/edit?usp=sharing
Mockup Progress report https://docs.google.com/spreadsheets/d/1xCADF0bmGh_z_0zBWteN_CFGx8QppkoQ9t5GsKfDrcI/edit?usp=sharing

Script executing custom view via API, See the Accolade API Reference for more information.

List of custom view used in progress report

• CRV_Initiative_V3
• CRV_RTCostUploadedOn
• CRV_ProjectStatusHistory
• CRV_ProjectKFDUpdate

ProgressReport.js

List function

1. bindEvent
   1. binding activities to event pageload/quickgridload
2. setInitial
   1. set initial values or parameters
3. addPrintbutton
   1. add print button into layout
4. executeQueryCost
   1. get data of project cost from CRV_Initiative_V3 via API
   2. write cost data into quickgrid
5. getRefCostLastUploaded
   1. get data of cost reference table, when the last uploaded from CRV_RTCostUploadedOn via API
6. getProjectPhases
   1. get datd of project phases via API
7. getStatusHistory
   1. get project status history (last 6 ) from CRV_ProjectStatusHistory via API
8. executeQueryKFD
   1. get Key Financial Datasheet from CRV_ProjectKFDUpdate via API
9. setKFDColor
   1. set color of KFD updated
10. setKPIColor
    1. set color of Ontime KPI and Onbudget KPI
11. setTableLine
    1. format table lines
12. setProgressBar
    
    1. set progress bar, completion percentage of each phase
13. PrintDiv
    
    1. Open report in new windows, including html, style-sheet and call print function.
14. getStringDateShortMonth
    
    1. format date to MMM dd, yyyy - example Mar 18, 2020
15. getStringDateFullMonth
    
    1. format date to MMMM dd, yyyy - example March 18, 2020