The PRINTER output option sends the report to a printer.
Syntax:
PRINT reportname ARRANGE clause WHERE clause .. ORDER BY clause .. OPTION PRINTER
The following OPTION parameters are available to customize the output:
Parameter |
Value |
Description |
SHOW_CANCEL_DIALOG |
ON (default) OFF |
Specifies whether to suppress cancel dialog box during the print process. |
TRAY |
Specifies the name of the bin (paper tray) containing the paper on which the report will be printed. A common use of this property is to set it to Manual Feed on mailing label reports. That way, you can provide a means to load the special label paper without manually setting the printer. |
|
COLLATION |
ON OFF |
Indicates whether multiple copies will print in pre-sorted order |
COPIES |
value |
Specifies the number of copies to print. If the COLLATION property is set to ON, the copies will print in sorted order.
|
DOCUMENT_NAME |
value |
When a report is printing, this is the name of the document as it should appear when listed in the Print Manager and on network header pages. This value can also be displayed in reports using the DocumentName type of the System Variable control. |
DUPLEX |
NONE HORIZONTAL VERTICAL |
Indicates what type of two-sided printing should occur. Not all printers support duplex printing. Horizontal duplex printing is performed across the page, from left to right, so the text will read as in a book. Vertical duplex printing is performed down the page, from top to bottom, so the text will read as a tablet. |
ORIENTATION |
PORTRAIT LANDSCAPE |
Determines whether a report prints vertically (PORTRAIT) or horizontally (LANDSCAPE) on a page. |
PAPER_NAME |
value |
The name of the paper on which the report will be printed. When you specify a value for the PAPER_NAME, the width and height are automatically set to the proper values. For example, if "Legal" is specified, the width will be set to 8.5" and the height will be set to 14". |
PAPER_WIDTH |
The value of the PAPER_WIDTH is always expressed in the units specified by the report. |
|
PAPER_HEIGHT |
The value of the PAPER_HEIGHT is always expressed in the units specified by the report. |
|
PRINTER_NAME |
The name of the printer that will be used to print the report. |
|
PAGE_SETTINGS |
ALL FIRST LAST PAGE_LIST |
Specifies the option to print All, First, Last or a given number of pages. When PAGE_LIST is set as the value for PAGE_SETTINGS, the PAGE_LIST_VALUES parameter must be used with option in order to specify the page list. |
PAGE_LIST_VALUES |
value |
Specifies the values for number of pages, such as, 3,5,8 or 3,8 or 3, or 1-3,8 or 3,5,9-15. This option must be used with the PAGE_SETTINGS parameter when PAGE_LIST is specified. |
PAGE_STYLE_SETTINGS |
ALL FIRST LAST Page List e.g. 1,4-6,10-12,20 |
Determines the pages in which the Page Style will appear on. |
MARGIN_LEFT |
value |
Specifies the horizontal position on the page where printing should begin. All report component positions are relative to the margin. In other words, if the MARGIN_LEFT parameter is set to 0.25 inches and you place a report component in a band and set the component's "left" parameter to 0, then that component will print 0.25 inches from the edge of page (or at the left margin). |
MARGIN_TOP |
value |
Specifies the vertical position on the page where printing should begin. All report component positions are relative to the margin. In other words, if the MARGIN_TOP parameter is set to 0.25 inches and you place a report component in a band and set the component's "top" parameter to 0, then that component will print 0.25 inches from the edge of page (or at the top margin). |
MARGIN_RIGHT |
value |
Specifies the horizontal position on the page where printing should stop. All report component positions are relative to the margin. |
MARGIN_BOTTOM |
value |
Specifies the vertical position on the page where printing should stop. All report component positions are relative to the margin. |
Note: Each additional OPTION parameter must be separated by the pipe | symbol.
Examples:
--Example 01 (To print Customer List on your default Windows printer):
PRINT CustomerList OPTION PRINTER
--Example 02 (To print Customer List on your network printer):
PRINT CustomerList +
OPTION PRINTER +
|COPIES 1 +
|ORIENTATION PORTRAIT +
|PRINTER_NAME \\MyServer\hp LaserJet 1320 PCL 6
--Example 03 (To print Customer Shipping Labels on your label printer):
LBLPRINT CustShippingLabel WHERE CustID = 127 OPTION PRINTER +
|COPIES 2 +
|PRINTER_NAME DYMO LabelWriter 2 +
|ORIENTATION LANDSCAPE
--Example 04 (To print first page of Customer List report only)
PRINT CustomerList OPTION PRINTER|PAGE_SETTINGS FIRST
--Example 05 (To print last page of Customer List Report only)
PRINT CustomerList OPTION PRINTER|PAGE_SETTINGS LAST
--Example 06 (To PRINT all pages)
PRINT ReportName OPTION PRINTER|PAGE_SETTINGS ALL
--Example 07 (To print pages 3, 5, and 8 of your big report)
PRINT ReportName OPTION PRINTER +
|PAGE_SETTINGS PAGE_LIST +
|PAGE_LIST_VALUES 3,5,8
--Example 08 (To print pages 3 and 8 of your big report)
PRINT ReportName OPTION PRINTER +
|PAGE_SETTINGS PAGE_LIST +
|PAGE_LIST_VALUES 3,8
--Example 09 (To print page 3 only)
PRINT ReportName OPTION PRINTER +
|PAGE_SETTINGS PAGE_LIST +
|PAGE_LIST_VALUES 3
--Example 10 (To print pages 1 through 3 and 8 of your big report)
PRINT ReportName OPTION PRINTER +
|PAGE_SETTINGS PAGE_LIST +
|PAGE_LIST_VALUES 1-3,8
--Example 11 (To print pages 3, 5, and 9 through 15 of your big report)
PRINT ReportName OPTION PRINTER +
|PAGE_SETTINGS PAGE_LIST +
|PAGE_LIST_VALUES 3,5,9-15
