SQR for PeopleSoft Overview

SQR for PeopleSoft is both a language and a set of tools that enables you to create professional reports:

SQR is a programming language for accessing and manipulating data to create custom reports. SQR has many advantages, including portability across multiple platforms and relational database management systems and support of SQL data manipulation capabilities. It is also a fourth-generation language; it is closer to human languages and, therefore, is more intuitive than first-, second-, or third-generation languages. SQR for PeopleSoft enables you to design report layouts, generate a variety of output types—including complex tabular reports, multiple page reports, form letters, mailing labels, and more—and create HTML, PDF, XML, or configured output for laser printers and phototypesetters.
SQR Execute enables you to run previously compiled SQR programs.
SQR Print enables you to configure reports for most printers.
SQR also provides a library of sample programs and output that you can use both as a learning tool and as a basis for creating your own reports. These samples reside in the SQR for PeopleSoft directory <PS_HOME>\bin\sqr\<database_platform>\SAMPLE (or SAMPLEW, for Windows).