|Format Modifier Keyword
|COL-HDR-SUPP suppresses the column headings (column titles) that are automatically printed at the top of each page for each column being displayed.
|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.
|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 will print gridlines between the columns and rows.
|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 will print the report in landscape mode.
|LEGAL will print the report to legal sized paper dimensions.
|PORTRAIT will print the report in portrait mode.
|The use of any of these keywords will send the report directly to the default printer.
|SCREEN will send the report to the preview window. By default all Run_Report commands use this setting.
|The T keyword is used to print the total rows processed at the bottom of the report.
|Previews the report in a maximized preview window.
* 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)