The various format modifier keywords can be inserted anywhere into the OpenList command (as long as they are not in the middle of a clause). If more than one format modifier is included in the command, they do not need to be specified together.
The format modifier keywords are:
| Format Modifier Keyword | Description |
|---|---|
| COL-HDR-SUPP | COL-HDR-SUPP suppresses the column headings (column titles) that are automatically printed at the top of each page for each column being displayed. It also suppresses the default heading and "rows processed" message (refer to HDR-SUPP, below). |
| DBL-SPC | The modifier DBL-SPC causes a blank line to be printed between each row on the report. Double spacing a report can make it easier to read, especially if there are many multi-valued or text columns being displayed. |
| DET-SUPP | Used with Total and Average, DET-SUPP causes a value to be printed at the bottom of the report, and a subtotal or average to be printed at each control break. DET-SUPP will cause the report to suppress printing the detail about each row used to calculate a total or average, and print only the total or average and subtotal and sub-average. |
| HDR-SUPP or SUPP | If no heading has been specified, OpenList reports will include a default heading of the date, time, and page number, and will include the message "xxx row(s) processed" at the bottom of the report. HDR-SUPP and SUPP suppress the default heading and row count. |
| ID-SUPP | List and Sort will always print the key column in the leftmost column of the report. ID-SUPP causes this column not to be printed. |
| LPTR | The keyword LPTR causes a report to be printed on the current printer device. If PDISK has been executed before the report is run, the output will be routed to an operating system table. |
| NOPAGE | The keyword NOPAGE allows a report displayed on the screen to continue from start to finish without interruption. It suppresses the default break at the end of each screen that ordinarily would prompt the user to "press a key to continue." NOPAGE has no effect on reports sent to the printer. |
The following are examples of format modifier keywords.
List CUSTOMERS ID-SUPP COMPANY ADDRESS CITY LPTR
This command will print to the printer only the company, address and city columns (no key column) of the CUSTOMERS table.
List PHONE_LIST By NAME COL-HDR-SUPP NAME PHONE DBL-SPC
This report will print out names and phone numbers double-spaced, but will include no headings, column headings or "xxx rows processed" message.
Sort INVOICES By INVOICE.DATE Break-On INVOICE.DATE Total INVOICE.AMOUNT DET-SUPP
This report will sort the invoices into date order, then display the invoices with a break at each new invoice date. Only the subtotals and total will be printed; no individual invoice amounts will appear.