Reporting Syntax Summary

This topic summarizes the WebFOCUS reporting commands and options that you can type directly into the Text Editor. For detailed information about these commands and options, see the Creating Reports With WebFOCUS Language manual.

TABLE FILE filename 
HEADING [CENTER]
"text"
{display_command} [SEG.]field   [/R|/L|/C] [/format]
{display_command} [prefixop.] [field] [/R|/L|/C] [/format]
  [NOPRINT|AS 'title1,...,title5'] [AND|OVER] [obj2...obj1024]
[WITHIN field] [IN n]
COMPUTE field [/format] = expression; [AS 'title,...,title5'] [IN n]
[AND] ROW-TOTAL [/R|/L|/C] [/format] [AS 'name']
[AND] COLUMN-TOTAL [/R|/L|/C] [AS 'name']
ACROSS [HIGHEST] sortfieldn [IN-GROUPS-OF qty]
  [NOPRINT|AS 'title1,...,title5']
BY [HIGHEST] sortfieldn [IN-GROUPS-OF qty]
  [NOPRINT|AS 'title1,...,title5']
BY [HIGHEST|LOWEST{n}] TOTAL  [prefix_operator]  {field|code_value}
RANKED [AS 'name'] BY {TOP|HIGHEST|LOWEST} [n] field 
  [PLUS OTHERS AS 'othertext'] 
  [IN-GROUPS-OF qty [TILES [TOP m]] [AS 'heading']]
  [NOPRINT|AS 'title1,...,title5']

{BY|ACROSS} sortfield IN-RANGES-OF value [TOP limit]
ON sfld  option1 [AND] option2   [WHEN expression;...]
ON sfld RECAP fld1  [/fmt] = FORECAST (fld2, intvl, npredct,
  '{MOVAVE|EXPAVE}',npnt);

ON sfld RECAP fld1[/fmt] = FORECAST(fld2, interval, npredict, 'DOUBLEXP',
  npoint1, npoint2);

ON sfld RECAP fld1[/fmt] = FORECAST(fld2, interval, npredict, 'SEASONAL',
  nperiod, npoint1, npoint2, npoint3);

ON sfld RECAP fld1  [/fmt] = FORECAST (fld2, intvl, npredct, 
'REGRESS');

ON {sortfield|TABLE} RECAP y[/fmt] = REGRESS(n, x1, [x2, [x3,]] z);
ON sfld RECAP fld1  [/fmt] = FORECAST (infield, interval, npredict,
  'DOUBLEXP',npoint, npoint2);
ON sfld RECAP fld1  [/fmt] = FORECAST (infield, interval, npredict,
  'SEASONAL', nperiod, npoint, npoint2, npoint3);{BY|ON} fieldname 
SUBHEAD
  [NEWPAGE]
"text"

{BY|ON} fieldname SUBFOOT [WITHIN] [MULTILINES][NEWPAGE]
"text" [<prefop.fieldname ... ]"        [WHEN expression;]

WHERE [TOTAL] expression 
WHERE {RECORDLIMIT|READLIMIT} EQ n 
IF [TOTAL] field relation  value [OR value...]
ON TABLE SET parameter value 
ON TABLE HOLD [VIA program][AS name] [FORMAT format] [MISSING {ON|OFF}]
ON TABLE {PCHOLD|SAVE|SAVB} [AS name] [FORMAT format] [MISSING {ON|OFF}]
ON TABLE NOTOTAL
ON TABLE COLUMN-TOTAL [/R|/L|/C] [AS 'name']  fieldname 
ON TABLE {ROW-TOTAL|ACROSS-TOTAL}[/R|/L|/C][format] [AS 'name'] fldname 
{BY|ON} sfld [AS 'text1']   {SUBTOTAL|SUB-TOTAL|SUMMARIZE|RECOMPUTE}
  [MULTILINES] [pref. ] [field1 [pref. ] field2 ...] [AS 'text2']
  [WHEN expression;]
{ACROSS|ON} sfld [AS 'text1'] {SUBTOTAL|SUB-TOTAL|SUMMARIZE|RECOMPUTE}
  [AS 'text2'] [COLUMNS c1 [AND c2 ...]]
ON  TABLE {SUBTOTAL|SUB-TOTAL|SUMMARIZE|RECOMPUTE}
  [pref. ] [field1 [pref. ] field2 ...] [AS 'text2']
FOOTING [CENTER] [BOTTOM]
"text"
MORE
FILE file2 
  [IF field relation value [OR value...]|WHERE expression]
{END|RUN|QUIT}