Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     AcrossColumn Shorthand
Go
New
Search
Notify
Tools
Reply
  
AcrossColumn Shorthand
 Login/Join
 
<Pooch>
posted
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
 
Reply With QuoteReport This Post
Guru
posted Hide Post
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
 
Posts: 406 | Location: Canada | Registered: May 31, 2004Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     AcrossColumn Shorthand

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.