PeopleSoft Developers will showcase the knowledge and experience required to help developers tweak and program development and configuration of PeopleSoft engines
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 inREPORT2' (,1) END-PROGRAM
PeopleSoft Developers
121 members
Description
PeopleSoft Developers will showcase the knowledge and experience required to help developers tweak and program development and configuration of PeopleSoft engines
Printing Multiple Reports in a SQR Report
by Rhett Sleeper
Feb 19, 2014
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:
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
Read Futher: http://peoplesoftwiki.blogspot.com/2013/02/printing-multiple-report...