How to export PeopleSoft Project Compare Report Results into excel file

最新推荐文章于 2017-06-05 16:15:00 发布

转载最新推荐文章于 2017-06-05 16:15:00 发布 · 144 阅读

Application Designer 专栏收录该内容

9 篇文章

订阅专栏

本文介绍如何通过执行特定SQL查询从源数据库获取PeopleSoft比较报告结果，并将结果导出到Excel进行进一步分析。此外，还介绍了如何在App Designer中打开报告文件并将其保存为CSV或制表符分隔格式。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

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.

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.