myPeopleSoft

PeopleSoft Community Network

Printing Multiple Reports in a SQR Report

One of my team had a requirement to create 2 reports from one SQR and faced couple of minor issues. Sharing the issues and the solution we used in this post.

Mutliple reports from one SQR:
To generate multiple report from SQR two things should be done:

Declaring the reports using DECLARE-REPORT
Updating the Parameters in Process Definition

Step 1: In the BEGIN-SETUP section declare report layouts as below:

BEGIN-SETUP

DECLARE-REPORT REPORT1

END-DECLARE

DECLARE-REPORT REPORT2

END-DECLARE

END-SETUP

Step 2: In the BEGIN-PROGRAM section or from the required procedure use the reports declared in Step 1.

BEGIN-PROGRAM
USE-REPORT REPORT1
PRINT 'Text to print in REPORT1' (,1)
!Once REPORT1 is completed switch to REPORT2 as below:
USE-REPORT REPORT2
PRINT 'Text to print in REPORT2' (,1)
END-PROGRAM