SQR Program Structure

SQR for PeopleSoft processes source code from a standard text file and generates a report. The text file containing source code comprises a set of sections that you delimit with BEGIN-section and END-section commands. The following examples show the general structure of SQR:

  • The SETUP section describes overall characteristics of the report.

    BEGIN-SETUP
     {setup commands}...
    END-SETUP
  • The HEADING and FOOTING sections specify what information is printed in the header and footing on each page of the report.

    BEGIN-HEADING {heading_lines}
     {heading commands}...
    END-HEADING
    BEGIN-FOOTING {footing_lines}
     {footing commands}...
    END-FOOTING
  • The PROGRAM section runs the procedures in the report.

    BEGIN-PROGRAM
     {commands}...
    END-PROGRAM
  • The PROCEDURE section performs the tasks to produce the report.

    BEGIN-PROCEDURE {procedure_name}
     {procedure commands}...
    END-PROCEDURE