Im trying to pass a couple of variables to a drill down report, using an older version of the MRE - which limits me to about 70 chars per line.

My drill statement
FOCEXEC=app/thtyp.fex(USD=&SD UED=&ED TT=N1 LOB=COMPANY_LINE_OF_BUSINESS), $
is too long, resulting in the error:
(FOC3209) UNKNOWN KEYWORD IN STYLESHEET FILE AT LINE: 3

is there any way to reference the across column data like N1 for the BY data?

focexec below:
TABLE FILE RES
ON TABLE SET PAGE-NUM OFF
ON TABLE SET HTMLCSS ON
ON TABLE SET ONLINE-FMT HTML
SUM
CNT.SR_ID AS 'No.,Tickets'
CNT AS 'No.,Duplicates'
BY
TICKET_TYPE AS 'Ticket Type'
ACROSS
COMPANY_LINE_OF_BUSINESS AS 'Line Of Business'


ON TABLE SET STYLE *
TYPE=DATA, COLUMN=N2,
FOCEXEC=app/thtyp.fex(USD=&SD UED=&ED TT=N1 LOB=COMPANY_LINE_OF_BUSINESS), $
ENDSTYLE
END

You need to use \ to break the line up. Hope the code below helps.


ON TABLE SET STYLE *
TYPE=DATA, COLUMN=N2,
FOCEXEC=app/thtyp.fex(USD=&SD \
UED=&ED \
TT=N1 \
LOB=COMPANY_LINE_OF_BUSINESS), $
ENDSTYLE
END