Description
The various format modifier keywords can be inserted anywhere into a Run_Report statement (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.
Keywords
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. |
| 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. |
| GRID | GRID will print gridlines between the columns and rows. |
| ID-SUPP | Run_Report will always print the key column in the leftmost column of the report. ID-SUPP causes this column not to be printed. |
| LANDSCAPE | LANDSCAPE will print the report in landscape mode. |
| LEGAL | LEGAL will print the report to legal sized paper dimensions. |
| PORTRAIT | PORTRAIT will print the report in portrait mode. |
| PRINTER (P LPTR | The use of any of these keywords will send the report directly to the default printer. |
| SCREEN | SCREEN will send the report to the preview window. By default all Run_Report commands use this setting. |
| T | The T keyword is used to print the total rows processed at the bottom of the report. |
| (M | Previews the report in a maximized preview window. |
Examples
* The following are examples of using format modifier keywords.
* This report will print to the printer only the company, address
* and city columns (no key column) of the CUSTOMERS table. A total rows
* processed line will also print
stmt = 'List CUSTOMERS ID-SUPP COMPANY ADDRESS1 CITY T'
Run_Report("",Stmt)
* This will print with gridlines in landscape mode
stmt = 'List CUSTOMERS ID-SUPP COMPANY ADDRESS1 CITY GRID LANDSCAPE'
Run_Report("",stmt)
* This report will display numerous fields with a grid in landscape mode
* on legal paper
stmt = 'List CUSTOMERS ID-SUPP COMPANY ADDRESS1 ADDRESS2 CITY STATE ZIP '
stmt:= 'PHONE GRID LANDSCAPE LEGAL'
Run_Report("",stmt)
*This report will print out names and phone numbers double-spaced, but will include no column headings.
stmt = "List CUSTOMERS COL-HDR-SUPP CUSTOMER_NAME PHONE DBL-SPC"
Run_Report("",stmt)
* This report will sort by and break on State. Detail and IDs are
* suppressed to display a totals report for State. The State value will
* be placed into the break-on value.
stmt = 'LIST CUSTOMERS BREAK-ON STATE "':"'V'":'" AVERAGE INVOICE_TOTAL '
stmt:= 'BY STATE DET-SUPP ID-SUPP''
Run_Report("",stmt)
