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 KeywordDescription
COL-HDR-SUPPCOL-HDR-SUPP suppresses the column headings (column titles) that are automatically printed at the top of each page for each column being displayed.
DBL-SPCThe 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-SUPPUsed 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.
GRIDGRID will print gridlines between the columns and rows.
ID-SUPPRun_Report will always print the key column in the leftmost column of the report. ID-SUPP causes this column not to be printed.
LANDSCAPELANDSCAPE will print the report in landscape mode.
LEGALLEGAL will print the report to legal sized paper dimensions.
PORTRAITPORTRAIT 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.
SCREENSCREEN will send the report to the preview window. By default all Run_Report commands use this setting.
TThe T keyword is used to print the total rows processed at the bottom of the report.
(MPreviews 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)
  • No labels