Management Overview report for Program Projects

Nivesh_Sharma_(geplas01user2_-_(deleted))

Hi,I am trying to replicate the Management Overview report screen for Program Projects as a LiveReport, including some addtional columns. I could find the name, Manager and Status columns in the database by following SQL------------------select D.dataid, D.name, U.FIRSTNAME||' '||U.LASTNAME Manager, D.STATUS, D.SUBTYPE from dtree D, kuaf K, kuaf U where K.type = D.dataidand K.name = 'Project Team'and D.userid = U.ID------------------But Please help me find the data columns OR SQL for "Current" and "Scheduled" columns in the report. Attached is the screenshot of the report I am talking about.Thanx