FOCUS - Formatting Commands

Refer to your FOCUS documentation for complete information on using the commands below.

 

Command
Syntax

COLUMNS/ROWS

ACROSS fieldname COLUMNS value AND value AND value

BY fieldname ROWS value OVER value OVER value

 

EMBEDDED DATA

e.g., "Data as of <AC:DAO"

 

FOLD-LINE

BY fieldname FOLD-LINE

 

IMPLIED PROMPTING WITH TEXT

e.g., IF AC:AGENCY EQ &AC:AGENCY.ENTER AGENCY CODE.

 

IN-GROUPS-OF

BY/ACROSS fieldname IN-GROUPS-OF value

 

MULTIPLE VERBS

SUM/COUNT fieldname1

BY fieldname2

PRINT/LIST fieldname3

BY fieldname2

BY fieldname4

 

NOPRINT

SORT fieldname NOPRINT

 

NOSPLIT

BY fieldname NOSPLIT

 

NOTOTAL

ON TABLE NOTOTAL

 

ON TABLE SUBHEAD/ SUBFOOT

ON TABLE SUBHEAD/SUBFOOT

"user provided text"

 

PAGE-BREAK REPAGE

BY fieldname PAGE-BREAK REPAGE

 

PREFIX OPERATORS

SUM prefix.fieldname

 

SKIP-LINE

BY fieldname SKIP-LINE

 

SUBHEAD/SUBFOOT

BY fieldname SUBHEAD/SUBFOOT

"user provided text"

 

SUBTOTAL MULTILINES

BY fieldname SUBTOTAL MULTILINES

 

UNDER-LINE

BY fieldname UNDER-LINE

 

 

 

Last Updated: February 1, 2000