Always the optimist, I was hoping to display the physical name of the fex I am running in the heading of a report. So I have tried this code:

TABLE FILE MMDB1
HEADING CENTER
" COUNT OF UNIT COORDINATORS "
" &FOCFEXNAME ROUTINE "
"REPORT: &FOCFOCEXEC -- EMPLOYEE SALARIES"
" &DATEMtrDYY "  

The documentation states that if I am working in Devstudio MRE, these are the results I should expect:

&FOCFEXNAME (returns ADHOCRQ when open in editor, focexecname when not open)
&FOCFOCEXEC (returns _ADHOCRQ when open in editor, _focexecname when not open)
&FOCINCLUDE (returns ADHOCRQ when open in editor, focexecname when not open)

True to form, I see this result:

COUNT OF UNIT COORDINATORS  
ADHOCRQ ROUTINE  
REPORT: _ADHOCRQ -- EMPLOYEE SALARIES 
October 19, 2012  
 

ASSIGNEE ASSIGNEE
COUNT  
II08 207 
II09 549 
MS52 77 
MS53 43 
SL8C 43 
SL8V 36 
SL8W 43 
SM02 29 
SM04 23 
SM11 75 
SR2A 59 
SR2B 69 
TV14 154 

Other than handcoding the fex's name in the heading, has anyone found a more difficult way around this ?

Forever the optimist!

Thanks.

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

This is a sample of the standard heading code we use via a -INCLUDE after the report HEADING statement in our non-MRE report environment:

-DEFAULTS &IBIAPP_app = 'unknown'
-DEFAULTS &DSTJOBNAME = 'unknown'
-*
-SET &BEG_PGMNAME = IF (EDIT(&FOCFOCEXEC,'9$') EQ '_') THEN 2 ELSE 1 ;
-SET &END_PRGNAME = IF (&FOCFOCEXEC CONTAINS '.fex')
-                   THEN (POSIT(&FOCFOCEXEC,&FOCFOCEXEC.LENGTH,'.fex',4,'I3') - 1)
-                   ELSE &FOCFOCEXEC.LENGTH ;
-SET &PRGNAME_LEN = IF (EDIT(&FOCFOCEXEC,'9$') EQ '_') THEN (&END_PRGNAME - 1) ELSE &END_PRGNAME ;
-SET &RPT_PROGRAM = IF (&FOCFOCEXEC EQ 'RCASTER') THEN (&DSTJOBNAME || '.fex')
-                   ELSE &IBIAPP_app || '\' ||
-   SUBSTR(&FOCFOCEXEC.LENGTH,&FOCFOCEXEC,&BEG_PGMNAME,&END_PRGNAME,&PRGNAME_LEN,'A&PRGNAME_LEN.EVAL') || '.fex';
-*
-SET &RPT_DATE_TEXT = 'Report Date: ' | &DATEMDYY ;
-SET &RPT_ID_TEXT   = 'Program='|| &RPT_PROGRAM || ', Department=<hard-coded name of support department for report>';
-*
"&RPT_DATE_TEXT.EVAL"
"&RPT_ID_TEXT.EVAL"

Variables like &FOCFOCEXEC are sometimes not exposed to the report server, so when you used them you don't get squat. You can access the administrative console under application settings and custom settings and expose any system variable you want.