How to export PeopleSoft Project Compare Report Results into excel file

1.

Execute following SQL Query in Source Database to get the peoplesoft compare report results for the specified project.

----------------------------------------------------------------------
SELECT distinct objecttype, objectvalue1, objectvalue2, sourcestatus, targetstatus, upgradeaction
FROM psprojectitem
WHERE projectname = 'Replace COMPARE_PROJECT_NAME here'
AND sourcestatus in (4,5)
ORDER BY objecttype, objectvalue1;
----------------------------------------------------------------------

Results of the above query can be exported into an excel sheet for further analysis.

2.

First, you open the reports in App Designer: 
File > Report from File > View Report > then navigate and open the report file. 


Then after opening, save the file as CSV or tab delimited: 


File > Save Report As > then enter filename and format. 


You can open these files on Excel.