Welcome Guest. Sign in or Signup
PeopleSoft Interview Questions And Answers
Interview » Technical » SQR » Multiple Reports from One SQR
Asked by: Interviewer 2306 views SQR
Is it possible to generate multiple reports from one SQR? How do we do this?
Arkhon on Jan 26, 2018 Reply
Yes, using the command “NEW-REPORT” It closes the current report output file and opens a new one with the specified file name.
new-report $next_report_file
This will also update the reserved variable $sqr-report to reflect the new report’s file name.
0 Votes 0 Votes 0 Votes
bude on Feb 27, 2019 Reply
Hi It is possible by using commands Declare Report & Use Reports in Begin-Setup and Begin-Program Sections.
ex: Begin-Setup Declare-Report Test1 End-Declare —- Declare-Report Test2 End-Declare — End-Setup
Begin-Program Use-Report Test1 Print ”This section is reference to test1 (,1) end-Report Use-Report Test2 Print “This section is reference to test2(,1) end-Report End-Program
I'm Existing User New User? Register Now
User ID * Password *
User ID *
Email *
Password *
Δ
Related Questions