This query generates a report using a heading of three lines:
>SORT CUSTOMERS BY LAST-NAME LAST-NAME STREET CITY STATE HEADING "CUSTOMER LIST 'CLTL' PAGE 'P' " |
||||
|
|
|
|
|
|
|
CUSTOMER LIST |
|
|
11:01:17 MMM YYYY |
|
|
|
|
PAGE 1 |
|
|
|
|
CUSTOMERS |
Last Name.... |
Street.......... |
City......... |
State |
|
|
|
|
|
MASHX5777 |
ASH |
912A E. OAK STREET |
INDIANAPOLIS |
IN |
JBOHA5422 |
BOHANNON |
126 TREMONT STREET |
BOSTON |
MA |
JBROW6749 |
BROWN |
129 BOYLSTON STREET |
BOSTON |
MA |
JBUCK6488 |
BUCKLER |
26 STONE AVENUE |
LINCOLN |
IN |
DEDGE6635 |
EDGECOMB |
338 BROADWAY |
MIAMI |
FL |
AEDWA5224 |
EDWARDS |
51 BLAIR AVENUE |
SUDBURY |
MA |
HHIGG6849 |
HIGGINS |
54 25TH STREET |
OMAHA |
NB |
HJENK7129 |
JENKINS |
1222 MAIN STREET |
INDIANAPOLIS |
IN |
AJOHN5396 |
JOHNSON |
760 JEFFERSON STREET |
LOUISVILLE |
|
HJOHN7265 |
JOHNSON |
45 5OTH STREET |
OMAHA |
NB |
BLAMP6196 |
LAMPSON |
344 TREMAIN ROAD |
BOSTON |
MA |
BLEAR6803 |
LEARY |
34 TREMONT STREET |
BOSTON |
MA |
JMASO6378 |
MASON |
226 ROCK ROAD |
LINCOLN |
KY |
AMEAD5619 |
MEADE |
251 BLOWNEY AVENUE |
SUDBURY |
MA |
AORLA5993 |
ORLANDO |
55 VENTURA HIGHWAY |
VENICE |
CA |
JPEER5993 |
PEERCE |
89 RIALTO WAY |
LOS ALTOS |
CA |
RPIER5539 |
PIERCE |
123 W RIDGEWOOD AVE |
RIDGEWOOD |
NJ |
SPIRS5289 |
PIRS |
112 APPLEBEE ROAD |
WINSTON |
NC |
The first line is centered and reads CUSTOMER LIST, the second line contains the current time and date, and the third line contains the page number of the report, preceded by the word PAGE. Note that when a heading is defined, the usual end-of-list message is automatically suppressed.
The L option causes a new line to begin in the heading after:
The first (centered) line
The time and date
The page number
See Also