Synopsis
Have a HTML UI with different report columns selection, based on selected columns the drilldown instruction is generated dynamically and sent to fex via &VAR variable. In FOCUS the correct Syntax is for each DRILLDOWN is separated by "$" followed by drilldown starting at new line (if DRILLDOWN is on same line as "$" WF comments it out) I had to get creative by using "@" as spot marker for newline wherein in the FEX it would screen the &VAR for any "@" and substitute for CR by using CTRAN. In below example the incoming &VAR is &TEST. If you run this example only COUNTRY column shows the DRILLDOWN but not CAR. However if you view copy and paste the "view source" the DRILLDOWN shows up for both column. Need help please.

I am using WF 7610

  
-SET &ECHO='ALL';
-DEFAULT &BYPHRASE = 'BY DEPTNAME BY JIBNAME';
-DEFAULT &ACROSSPHRASE = 'NEWACCDT2 AS ''';
-DEFAULT &WHEREPHRASE = 'WHERE TxnBilled EQ 1';
-DEFAULT &ST = 'ON DEPTNAME SUBTOTAL MULTILINES AS ''TOTAL''';
-SET &TEST = ' TYPE=DATA, COLUMN=COUNTRY , DRILLMENUITEM=''View Detail by DEPARTMENT'' , FOCEXEC=app/rpt_acct_admin5(COL1 = ''DEPTNAME''  COL1VAL=''DEPTNAME'' WHEREPHRASE= '' WHERE AcctDate GE DT (^09/01/2012^); WHERE AcctDate LE DT(^09/30/2012^); WHERE TxnBilled EQ 1;'' ), TARGET=''_blank'',  $ @  TYPE=DATA, COLUMN=CAR , DRILLMENUITEM=''View Detail by JIB'' , FOCEXEC=app/rpt_acct_admin5(COL2 = ''JIBNAME''  COL2VAL=''JIBNAME'' WHEREPHRASE= '' WHERE AcctDate GE DT(^09/01/2012^); WHERE AcctDate LE DT(^09/30/2012^); WHERE TxnBilled EQ 1;'' ), TARGET=''_blank'',  $@ ';
-SET &SIZE = 'A' | &TEST.LENGTH;
-SET &DRILLDOWN1 = CTRAN(&TEST.LENGTH, &TEST, 64, 10, '&SIZE.EVAL');
-TYPE &DRILLDOWN1
SET LINES = 99999
TABLE FILE CAR
SUM 
     'CAR.BODY.DEALER_COST'
BY 'CAR.ORIGIN.COUNTRY'
BY 'CAR.COMP.CAR'
HEADING
""
FOOTING
""
ON TABLE SET PAGE-NUM OFF 
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
     UNITS=IN,
     SQUEEZE=ON,
     ORIENTATION=PORTRAIT,
$
TYPE=REPORT,
     GRID=OFF,
     FONT='ARIAL',
     SIZE=9,
$
TYPE=TITLE,
     STYLE=BOLD,
$
TYPE=TABHEADING,
     SIZE=12,
     STYLE=BOLD,
$
TYPE=TABFOOTING,
     SIZE=12,
     STYLE=BOLD,
$
TYPE=HEADING,
     SIZE=12,
     STYLE=BOLD,
$
TYPE=FOOTING,
     SIZE=12,
     STYLE=BOLD,
$
TYPE=SUBHEAD,
     SIZE=10,
     STYLE=BOLD,
$
TYPE=SUBFOOT,
     SIZE=10,
     STYLE=BOLD,
$
TYPE=SUBTOTAL,
     BACKCOLOR=RGB(210 210 210),
$
TYPE=ACROSSVALUE,
     SIZE=9,
$
TYPE=ACROSSTITLE,
     STYLE=BOLD,
$
TYPE=GRANDTOTAL,
     BACKCOLOR=RGB(210 210 210),
     STYLE=BOLD,
$
&DRILLDOWN1
ENDSTYLE
END

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

Why not create multiple variables?

-SET &ECHO='ALL';
-DEFAULT &BYPHRASE = 'BY DEPTNAME BY JIBNAME';
-DEFAULT &ACROSSPHRASE = 'NEWACCDT2 AS ''';
-DEFAULT &WHEREPHRASE = 'WHERE TxnBilled EQ 1';
-DEFAULT &ST = 'ON DEPTNAME SUBTOTAL MULTILINES AS ''TOTAL''';

-SET &DRILLDOWN_1  = ' TYPE=DATA, COLUMN=COUNTRY , ';
-SET &DRILLDOWN_1A = 'DRILLMENUITEM=''View Detail by DEPARTMENT'' , FOCEXEC=app/rpt_acct_admin5(COL1 = ''DEPTNAME''  COL1VAL=''DEPTNAME'' WHEREPHRASE= '' WHERE AcctDate GE DT (^09/01/2012^); WHERE AcctDate LE DT(^09/30/2012^); WHERE TxnBilled EQ 1;'' ), TARGET=''_blank'',';
-SET &DRILLDOWN_1B = 'DRILLMENUITEM=''View Detail by DEPARTMENT'' , FOCEXEC=app/rpt_acct_admin5(COL1 = ''DEPTNAME''  COL1VAL=''DEPTNAME'' WHEREPHRASE= '' WHERE AcctDate GE DT (^09/01/2012^); WHERE AcctDate LE DT(^09/30/2012^); WHERE TxnBilled EQ 1;'' ), TARGET=''_blank'', $';

-SET &DRILLDOWN_2 = 'TYPE=DATA, COLUMN=CAR , ';
-SET &DRILLDOWN_2A = 'DRILLMENUITEM=''View Detail by JIB'' , FOCEXEC=app/rpt_acct_admin5(COL2 = ''JIBNAME''  COL2VAL=''JIBNAME'' WHEREPHRASE= '' WHERE AcctDate GE DT(^09/01/2012^); WHERE AcctDate LE DT(^09/30/2012^); WHERE TxnBilled EQ 1;'' ), TARGET=''_blank'',';
-SET &DRILLDOWN_2B = 'DRILLMENUITEM=''View Detail by JIB'' , FOCEXEC=app/rpt_acct_admin5(COL2 = ''JIBNAME''  COL2VAL=''JIBNAME'' WHEREPHRASE= '' WHERE AcctDate GE DT(^09/01/2012^); WHERE AcctDate LE DT(^09/30/2012^); WHERE TxnBilled EQ 1;'' ), TARGET=''_blank'', $';

SET LINES = 99999
TABLE FILE CAR
SUM
'CAR.BODY.DEALER_COST'
BY 'CAR.ORIGIN.COUNTRY'
BY 'CAR.COMP.CAR'
HEADING
""
FOOTING
""
ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *

&DRILLDOWN_1
&DRILLDOWN_1A
&DRILLDOWN_1B

&DRILLDOWN_2
&DRILLDOWN_2A
&DRILLDOWN_2B

ENDSTYLE
END

yes that is my last resort but still there should be an explanation to my issue. Why is WF ignoring the second drill down instruction even when clearly "view source" shows the line break. I thought of posting this on focalpoint to get thoughts from all the WF gurus such as yourself :-)

That carriage-return is probably only visual and ignored by the parser.

Is there different approach to inserting a carriage return??!

I don't think you can insert a carriage return into code, point final.