Please enable JavaScript to view this site.

R:BASE 11 Help

Navigation: Command Index > L > LBLPRINT

PRINTER

Scroll Prev Top Next More

The PRINTER output option sends the label to a printer.

 

Syntax:

 

LBLPRINT labelname 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):

LBLPRINT CustShippingLabel OPTION PRINTER

 

--Example 02 (To print Customer List on your network printer):

LBLPRINT CustShippingLabel +

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)

LBLPRINT CustShippingLabel OPTION PRINTER|PAGE_SETTINGS FIRST

 

--Example 05 (To print last page of Customer List Report only)

LBLPRINT CustShippingLabel OPTION PRINTER|PAGE_SETTINGS LAST

 

--Example 06 (To PRINT all pages)

LBLPRINT CustShippingLabel OPTION PRINTER|PAGE_SETTINGS ALL

 

--Example 07 (To print pages 3, 5, and 8 of your big report)

LBLPRINT CustShippingLabel OPTION PRINTER +

|PAGE_SETTINGS PAGE_LIST +

|PAGE_LIST_VALUES 3,5,8

 

--Example 08 (To print pages 3 and 8 of your big report)

LBLPRINT CustShippingLabel OPTION PRINTER +

|PAGE_SETTINGS PAGE_LIST +

|PAGE_LIST_VALUES 3,8

 

--Example 09 (To print page 3 only)

LBLPRINT CustShippingLabel OPTION PRINTER +

|PAGE_SETTINGS PAGE_LIST +

|PAGE_LIST_VALUES 3

 

--Example 10 (To print pages 1 through 3 and 8 of your big report)

LBLPRINT CustShippingLabel 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)

LBLPRINT CustShippingLabel OPTION PRINTER +

|PAGE_SETTINGS PAGE_LIST +

|PAGE_LIST_VALUES 3,5,9-15