PS Query & SQL

Reporting tools have evolved considerably in PeopleSoft. Each tool has a distinct purpose along with limitations on its use. There is no one simple replacement tool now that Crystal reports has been deprecated and SQRs have fallen out of use.

The new PeopleSoft Reporting Tool suite is powerful enough to replace the cumbersome component-focused tools of the past, but you have to know your way around each one to get the most use out of the entire suite. There are also unwarranted security concerns that prevent these tools from being accessed which reduces the productivity of your institution.

This presentation seeks to eliminate the confusion and fears around the use of these new Reporting Tools. It will not be a deep dive into any one tool but a general review of the suite with handy tips and tricks that optimize your efforts across all the tools in the suite. Tapping the potential of SQL objects and incorporating naming conventions for queries and fields are part of the discussion for this presentation. Also reviewed are the limitations of each tool.

You will have an understanding of each tool in the suite and the best application for the desired reporting outcome.

https://www.heug.org/communities/community-home/librarydocuments/viewdocument?DocumentKey=4769a76c-3d1f-4c0f-829e-5b0d037838ee