You are viewing this site as a guest. You can still ask questions and help others! Join our Dev2Dev IT Community to receive your own blog, share your knowledge, and much more.

ANY BODY CAN HELP

1 reply [Last post]
Guest's picture
Guest

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

rahulkhandelw's picture
User offline. Last seen 6 years 36 weeks ago. Offline
Joined: 10/16/2009
Posts: 34
Re: ANY BODY CAN HELP

I couldn't get your question. Nowhere you are selecting date, so why do you expect it to be populated.

Post new comment

CAPTCHA
The question below is to prevent automated spam submissions.
5 + 1 =
Solve this simple math problem and enter the result. E.g. for 1+3, enter 4.