Page History
...
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
Code Block |
---|
* 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) |