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
Step 3: After performing the above two steps and running the SQR, one will
find only one report(usually the first one) is displayed in Process Monitor
though the other one also got generated. This is because the Process Scheduler
is unaware that we are printing two reports in a single report. To make the
process scheduler aware of multiple reports in the Parameter section of Process
Scheduler specify "-MR n" without quotes. Here, MR indicates
Multiple Reports and 'n' is a number between 2 to 99 indicating to the Process
Scheduler the number of reports generated by the SQR report.
Step 4: Providing custom file names for multiple reports generated by SQR
While the above three steps
will generate multiple reports and display in Process Scheduler, the file names
would be a combination of process name, process instance and the file number.
To provide custom file names, modify the contents of Step 2 as below:
BEGIN-PROGRAM
Let $Filename_of_Report1 = Requiredpath/1.pdf
Let $Filename_of_Report2 = Requiredpath/2.pdf
USE-REPORT REPORT1
NEW-REPORT $Filename_of_Report1
PRINT 'Text to print in REPORT1' (,1)
!Once REPORT1 is completed switch to REPORT2 as
below:
USE-REPORT REPORT2
NEW-REPORT $Filename_of_Report2
PRINT 'Text to print in REPORT2'
(,1)
END-PROGRAM
How to read long and short
values (XLAT) values from a SQR:-
‘READXLAT.sqc’ is the SQC that can be used to
read data from the PeopleSoft Translate Table(PSXLATITEM). How to access the
values from this SQC?
1. Include READXLAT.SQC in the SQR
2. Populate $fieldname and $fieldvalue with the required fieldname
and values for which Translate values are to be retrieved.
3. Call the procedure Read-Translate-Table to retrieve the values
from PSXLATITEM.
4. Get either $XLATLongName or $XLATShortName to get Long or Short
values respectively.
