Hello,

I have created a launch page which allows users to pass multiple values (institutions) to a focexec.

Captioned below is the listing I created with "-? &" to verify that the expected & variables are being passed from the launch page to the focexec.

My question concerns the variables &INSTITUTIONS AND &INSTITUTIONS> which contain an INSTITUTION code and INSTITUTION name, respectively.

Can anyone suggest a way I could (perhaps) instantaneously capture these values in new variable names to more clearly use them in the focexec report?

Here is the "-? &" to show the & variables.

 CURRENTLY DEFINED & VARIABLES:
 &&DUDE_URL    = http://s30atrrsbuild-d.devatrrs.local/DUDE/Upload/
 &&GLOBAL_SERV>= 172.30.30.107
 &&GLOBAL_WEBF>= DEV
 &&WEB_APP_DOM>= http://s30atrrsbuild-d.devatrrs.local
 &ACCEPTS      =        0
 &APPROOT      = D:\ibi\apps
 &APP_BANNER_T>= DAU Transcript Reports
 &AUTOINDEX    = NO
 &BASEIO       =        0
 &CHNGD        =        0
 &DATE         = 04/17/17
 &DBMSERR      =        0
 &DELTD        =        0
 &DMY          = 170417
 &DMYY         = 17042017
 &DUPLS        =        0
 &Date         = 03-31-2017
 &ECHO         = ALL
 &ENDDATE      = Mar 31 2017
 &ENV_AUTO_DEF>= Y
 &ENV_AUTO_DEF>= 30000
 &ENV_CLT_ERR_>= N
 &FOCEXURL     = /ibi_apps8105M/WFServlet?IBIF_webapp=/ibi_apps8105M&IBIC_serv
 &FOCFEXNAME   = prc_institution_usage_rpt
 &FOCFOCEXEC   = _prc_institution_usage_rpt
 &FOCGRAPHCNT  =        0
 &FOCHTMLURL   = /ibi_apps8105M/ibi_html/S14924822965892F
 &FOCINCLUDE   = prc_institution_usage_rpt
 &FOCNEXTPAGE  =        0
 &FOCSECGROUP  = Administrators
 &FORMAT       =        0
 &GOOGLEMAPSAP>=
 &IBIMR_domain = DAU_Transcript/
 &IBIMR_folder = Administration
 &IBIMR_user   = tom.fitzsimmons
 &INDEXIO      =        0
 &INPUT        =        0
 &INSTITUTIONS = 4271,10,13
 &INSTITUTIONS>= ABC University (TEST RECORD),ACADIA UNIVERSITY,ADELPHI UNIVER
 &INVALID      =        0
 &LINES        =        0
 &MDY          = 041717
 &MDYY         = 04172017
 &MRE_BASE_DIR =
 &MR_FULL_FEXN>= prc_institution_usage_rpt
 &MR_ITEM_HAND>= prc_institution_usage_rpt
 &NOMATCH      =        0
 &OUTPUTFMT    = AHTML
 &QUERY_STRING = IBIMR_fex=%2FWFC%2FRepository%2Fdau_transcript%2Favailable_Re
 &READS        =        0
 &RECORDS      =        0
 &REJECTS      =        0
 &SETFILE      =
 &SORTIO       =        0
 &STARTDATE    = Jan 01 2017
 &TOD          = 22.30.37
 &TRANS        =        0
 &WFDESCRIBE   = XMLPROMPT
 &WF_TITLE     = prc_institution_usage_rpt
 &YMD          = 170417
 &YYMD         = 20170417
 -? &
 -RUN
 -EXIT

Thank you,

This message has been edited. Last edited by: FP Mod Chuck,

Tom,
I'm afraid that the caret '>' is not permissable in a &variable name.
As for separating the values and names in differetn &variables, here is a suggestion;

  
-SET &ECHO=ALL;
-SET &INSTITUTIONS = '4271,10,13';
-SET &INSTITUTIONSNAME = 'ABC University (TEST RECORD),ACADIA UNIVERSITY,ADELPHI UNIVER';
-SET &I=0;
-SET &ILEN=&INSTITUTIONS.LENGTH;
-SET &INLEN=&INSTITUTIONSNAME.LENGTH;
-#L SET &I=&I + 1;
-SET &GET=GETTOK(&INSTITUTIONS, &ILEN, &I, ',', &ILEN, 'A&ILEN.EVAL'); 
-IF &GET EQ ' ' GOTO #DONE;
-SET &INSTITUTIONS.&I = &GET;
-SET &INSTITUTIONSNAME.&I=GETTOK(&INSTITUTIONSNAME, &INLEN, &I, ',', &INLEN, 'A&INLEN.EVAL'); 
-GOTO #L
-#DONE
-SET &M = &I - 1;
-REPEAT #SHOW FOR &I FROM 1 TO &M;
-TYPE INSTITUTION&I = &INSTITUTIONS.&I
-TYPE INSTITUTION NAME&I = &INSTITUTIONSNAME.&I
-#SHOW

Thank you Daniel

I did something like that once, and you have to be sure there are no commas in your list of institutions or it will choke.

Try the following:

-? &INS

That should show all variables which start with &INS, or,

-TYPE **** &|INSTITUTION_CODE ...... &|INSTITUTION_CODE ***
-TYPE **** &|INSTITUTION_NAME ...... &|INSTITUTION_NAME ***

. I use this format often.

This message has been edited. Last edited by: Doug,

In FOCUS Since 1983 ~ from FOCUS to WebFOCUS.    Current: WebFOCUS Administrator at FIS Worldpay | 8204, 8206