Date: Fri, 29 Mar 2024 02:29:24 -0700 (PDT) Message-ID: <1601749050.487.1711704564195@wiki.srpcs.com> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_486_1311707392.1711704564194" ------=_Part_486_1311707392.1711704564194 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Content-Location: file:///C:/exported.html
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 m= ore than one format modifier is included in the command, they do not need t= o be specified together.
The format modifier keywords are:
Format Modifier Ke= yword | Description |
---|---|
COL-HDR-SUPP | COL-HDR-SUPP suppresses the column headings (col= umn 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 p= rinted 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 b= eing displayed. |
DET-SUPP | Used with Total and Average, DET-SUPP causes a v= alue to be printed at the bottom of the report, and a subtotal or average t= o be printed at each control break. DET-SUPP will cause the report to suppr= ess 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 an= d rows. |
ID-SUPP | Run_Report will always print the key column in t= he leftmost column of the report. ID-SUPP causes this column not to be prin= ted. |
LANDSCAPE | LANDSCAPE will print the report in landscape mod= e. |
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 r= eport directly to the default printer. |
SCREEN | SCREEN will send the report to the preview windo= w. By default all Run_Report commands use this setting. |
T | The T keyword is used to print the total rows pr= ocessed at the bottom of the report. |
(M | Previews the report in a maximized preview windo= w. |
* The following ar= e 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 ro= ws * processed line will also print stmt =3D 'List CUSTOMERS ID-SUPP COMPANY ADDRESS1 CITY T' Run_Report("",Stmt) * This will print with gridlines in landscape mode stmt =3D '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 =3D 'List CUSTOMERS ID-SUPP COMPANY ADDRESS1 ADDRESS2 CITY STATE ZIP ' stmt:=3D '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 =3D "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 wi= ll * be placed into the break-on value. stmt =3D 'LIST CUSTOMERS BREAK-ON STATE "':"'V'":'" AVERAGE INVOICE_TOTAL ' stmt:=3D 'BY STATE DET-SUPP ID-SUPP' Run_Report("",stmt)