IN RUNCONTROL PAGE THER IS BUSINESS UNIT GRID IS THER ...VALUES ARE AA,BB,CC,DD,EE
FOR THAT MY REQUIRMENT IS I WANT A REPORT AS 'AA','BB','CC','DD','EE'
FROM DIS CODE
BEGIN-PROCEDURE Init-Report
LET $STR1 = ''
DO Select-Parameters
END-PROCEDURE
BEGIN-PROCEDURE Select-Parameters
BEGIN-SELECT
RC3.BUSINESS_UNIT &BUSINESS_UNIT
LET $BUSINESS_UNIT = &BUSINESS_UNIT
LET $STR1 = $STR1 || ''' ||$BUSINESS_UNIT|| '','
FROM PS_PES_MAC_SAT_BU RC3
WHERE RC3.OPRID = $prcs_oprid
AND RC3.RUN_CNTL_ID = $prcs_run_cntl_id
END-SELECT
SHOW 'STR1 ' $STR1
END-PROCEDURE
...........................................BUT THE VALUES ARE FETCHED SIMPLY REPORT DISPLAYED'BUSINESS_UNIT','BUSINESS_UNIT',;BUSINESS_UNIT '
ANY BODY CAN HELP ME TO POPULATE DATE
Title | Under | Posted on |
---|---|---|
Component interface Error: no rows exist for the specified keys | PeopleSoft Technical | 03/15/2019 - 3:54am |
ADD 24 months starting from current month.(peoplesoft) | PeopleSoft Functional | 07/29/2018 - 8:44pm |
TRC values dropdown | PeopleSoft Technical | 04/04/2018 - 12:54am |
how to find missing sequence in GRID and print the mising sequence number while saving through peoplecode | PeopleSoft Technical | 09/11/2017 - 4:49am |
I couldn't get your question. Nowhere you are selecting date, so why do you expect it to be populated.