LBLPRINT (Short Name: LBL)
Top  Previous  Next

Use the LBLPRINT command to send a set of labels to a screen, printer, file, or any combination of destinations.

lblprint

Options

labelname
Specifies a 1 to 18 character label name.

ORDER BY clause

Sorts rows of data. For more information, see the "ORDER BY" entry.

WHERE clause

Limits rows of data. For more information, see the "WHERE" entry.

OPTION
Specifies output options of the label.

PRINTING TO SCREEN  
 
LBLPRINT labelname WHERE whereclause OPTION SCREEN|WINDOW_STATE MAXIMIZED  
 
WINDOW_STATE MAXIMIZED  
Specifies that the preview window is maximized. By default, the window state is normalized.  


PRINTING TO PRINTER WITH PARAMETERS  
 
LBLPRINT labelname WHERE whereclause OPTION PRINTER|TRAY <value>| COLLATION ON/OFF|COPIES <value>|DOCUMENT_NAME <value>|DUPLEX <value>| ORIENTATION <value>|PAPER_NAME <value>|PAPER_WIDTH <value>| PAPER_HEIGHT <value>|PRINTER_NAME <value>  
 
TRAY  
The name of the bin (paper tray) containing the paper on which the label 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  
This property indicates whether multiple copies will print in presorted order.  
 
·ON  
·OFF  
 
COPIES  
This property indicates the number of copies to print. If the Collation property is set to ON, the copies will print in sorted order.  
 
DOCUMENT_NAME  
When a label 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 SystemVariable component.  
 
DUPLEX  
This property indicates what type of two-sided printing should occur. Not all printers support duplex printing.  
 
·NONE - Duplex printing is disabled.  
·HORIZONTAL - Duplex printing should be performed across the page, from left to right, so the text will read as in a book  
·VERTICAL - Duplex printing should be performed down the page, from top to bottom, so the text will read as in tablet  
 
ORIENTATION  
The value of the Orientation property determines whether a label prints vertically or horizontally on a page.  
 
·PORTRAIT - The print job prints vertically on the page.  
·LANDSCAPE - The print job prints horizontally on the page.  
 
PAPER_NAME  
The name of the paper on which the label will be printed. When you specify a value for the PAPER_NAME property, the PaperWidth and PaperHeight are automatically set to the proper values. For example, if Legal is specified, the PAPER_WIDTH will be set to 8.5" and the PAPER_HEIGHT will be set to 14" when ORIENTATION is PORTRAIT (if the ORIENTATION is LANDSCAPE, the values will be reversed).  
 
PAPER_WIDTH  
The value of the PAPER_WIDTH are always expressed in the units specified by the Label.  
 
 
PAPER_HEIGHT  
The value of the PAPER_HEIGHT are always expressed in the units specified by the Label.  
 
PRINTER_NAME  
The name of the printer that will be used to print the label.  
 
 
PRINTING TO BITMAP  
 
LBLPRINT labelname WHERE … OPTION BMP|FILENAME <value>|PIXELFORMAT <value>|BACKGROUND_COLOR <value>|BACKGROUND_FILE <value>|BACKGROUND_TYPE <value>|MONOCHROME <value>|SCALEX <value>|SCALEY <value>|OPEN <value>|  
 
FILENAME  
filename of bmp-file  
 
PIXELFORMAT  
Specifies the pixel format of the bmp-file (bits/pixel)  
 
·1 : 1bit  
·4 : 4bit  
·8 : 8bit  
·15 : 15bit  
·16 : 16bit  
·24 : 24bit  
·32 : 32bit  
 
BACKGROUND_COLOR  
Indicates the color to be used as background color of all pages of label (default : White)  
 
·AQUA  
·BLACK  
·BLUE  
·CREAM  
·DARK GRAY  
·FUCHSIA  
·GRAY  
·GREEN  
·LIME  
·LIGHT GRAY  
·MAROON  
·MEDIUM GRAY  
·MINT GREEN  
·NAVY  
·OLIVE  
·PURPLE  
·RED  
·SILVER  
·SKY BLUE  
·TEAL  
·WHITE  
·YELLOW  
 
BACKGROUND_FILE  
Stores the image file name that is to be used as background image of all pages of label.  
 
 
BACKGROUND_TYPE  
Specifies the way background image has to be displayed in the bmp-file.  
 
·TILE  
·TOPLEFT  
·TOPCENTER  
·TOPRIGHT  
·CENTERLEFT  
·CENTER  
·CENTERRIGHT  
·BOTTOMLEFT  
·BOTTOMCENTER  
·BOTTOMRIGHT  
 
MONOCHROME  
Specifies whether bmp-file produced are color or monochrome images  
 
·ON  
·OFF  
 
SCALEX  
double; Scaling factor for the width of the exported page  
 
SCALEY  
double; Scaling factor for the height of the exported page  
 
OPEN  
Specifies whether the label should be opened after it is generated  
 
·ON  
·OFF  
 
Example:  
 
LBLPRINT CustomerLabels option bmp|filename d:\testbmp.bmp|BACKGROUND_COLOR WHITE|BACKGROUND_TYPE TILE|BACKGROUND_FILE d:\tema.gif|OPEN ON  
 
 
PRINTING TO GIF-File  
 
LBLPRINT labelname WHERE … OPTION GIF|FILENAME <value> |PIXELFORMAT <value>|BACKGROUND_COLOR <value>|BACKGROUND_FILE <value>|BACKGROUND_TYPE <value>|MONOCHROME <value>|SCALEX <value>|SCALEY <value>|OPEN <value>|  
 
FILENAME  
filename of GIF-file  
 
PIXELFORMAT  
Specifies the pixel format of the GIF-file (bits/pixel)  
 
·1 : 1bit  
·4 : 4bit  
·8 : 8bit  
·15 : 15bit  
·16 : 16bit  
·24 : 24bit  
·32 : 32bit  
 
BACKGROUND_COLOR  
Indicates the color to be used as background color of all pages of label (default : White)  
 
·AQUA  
·BLACK  
·BLUE  
·CREAM  
·DARK GRAY  
·FUCHSIA  
·GRAY  
·GREEN  
·LIME  
·LIGHT GRAY  
·MAROON  
·MEDIUM GRAY  
·MINT GREEN  
·NAVY  
·OLIVE  
·PURPLE  
·RED  
·SILVER  
·SKY BLUE  
·TEAL  
·WHITE  
·YELLOW  
 
BACKGROUND_FILE  
Stores the image file name that is to be used as background image of all pages of label.  
 
BACKGROUND_TYPE  
Specifies the way background image has to be displayed in the GIF-file.  
 
·TILE  
·TOPLEFT  
·TOPCENTER  
·TOPRIGHT  
·CENTERLEFT  
·CENTER  
·CENTERRIGHT  
·BOTTOMLEFT  
·BOTTOMCENTER  
·BOTTOMRIGHT  
 
MONOCHROME  
Specifies whether GIF-file produced are color or monochrome images  
 
·ON  
·OFF  
 
SCALEX  
double; Scaling factor for the width of the exported page  
 
SCALEY  
double; Scaling factor for the height of the exported page  
 
OPEN  
Specifies whether the label should be opened after it is generated  
 
·ON  
·OFF  
 
Example:  
 
LBLPRINT CustomerLabels option GIF|filename d:\testGIF.GIF|BACKGROUND_COLOR WHITE|BACKGROUND_TYPE TILE|BACKGROUND_FILE d:\tema.gif|OPEN ON  
 
 
PRINTING TO JPEG-File  
 
LBLPRINT labelname WHERE … OPTION JPG|FILENAME <value> |PIXELFORMAT <value>|BACKGROUND_COLOR <value>|BACKGROUND_FILE <value>|BACKGROUND_TYPE <value>|MONOCHROME <value>|SCALEX <value>|SCALEY <value>|GRAYSCALE <value>|PROGRESSIVE_ENCODING <value>|OPEN <value>|  
 
FILENAME  
filename of JPEG-file  
 
PIXELFORMAT  
Specifies the pixel format of the JPEG-file (bits/pixel)  
 
·1 : 1bit  
·4 : 4bit  
·8 : 8bit  
·15 : 15bit  
·16 : 16bit  
·24 : 24bit  
·32 : 32bit  
 
BACKGROUND_COLOR  
Indicates the color to be used as background color of all pages of label (default : White)  
 
·AQUA  
·BLACK  
·BLUE  
·CREAM  
·DARK GRAY  
·FUCHSIA  
·GRAY  
·GREEN  
·LIME  
·LIGHT GRAY  
·MAROON  
·MEDIUM GRAY  
·MINT GREEN  
·NAVY  
·OLIVE  
·PURPLE  
·RED  
·SILVER  
·SKY BLUE  
·TEAL  
·WHITE  
·YELLOW  
 
BACKGROUND_FILE  
Stores the image file name that is to be used as background image of all pages of label.  
 
BACKGROUND_TYPE  
Specifies the way background image has to be displayed in the JPEG-file.  
 
·TILE  
·TOPLEFT  
·TOPCENTER  
·TOPRIGHT  
·CENTERLEFT  
·CENTER  
·CENTERRIGHT  
·BOTTOMLEFT  
·BOTTOMCENTER  
·BOTTOMRIGHT  
 
MONOCHROME  
Specifies whether JPEG-file produced are color or monochrome images  
 
·ON  
·OFF  
 
SCALEX  
double; Scaling factor for the width of the exported page  
 
SCALEY  
double; Scaling factor for the height of the exported page  
 
GRAYSCALE  
Determines whether the image output of a JPEG image is black and white, or color. Use GrayScale for reading in and writing out, that is, for decompressing and compressing, a jpeg image. This property affects how the image is displayed.  
 
GrayScale is used for speed in output optimization. When GrayScale is set to ON, the color is separated from luminosity. Color takes the most time to decompress, so for previewing the image, GrayScale can be set to True for speed. The output then contains 255 shades of gray.  
 
·ON  
·OFF  
 
PROGRESSIVE_ENCODING  
Determines whether an image can be progressively displayed when it is decompressed.  
 
·ON  
·OFF  
 
QUALITY  
Determines the closeness of the saved, JPEG image to the original.  
 
Quality determines the closeness of the saved, JPEG image to the original. As a side effect it also matter to the size of the saved file. Setting a larger value improves image quality but also increases file size; a smaller value decreases image quality and also reduces file size. Alter it according to the need.  
 
·1-100  
 
OPEN  
Specifies whether the label should be opened after it is generated  
 
·ON  
·OFF  
 
Example:  
 
LBLPRINT CustomerLabels option JPG|filename d:\testJPEG.JPEG|BACKGROUND_COLOR WHITE|BACKGROUND_TYPE TILE|BACKGROUND_FILE d:\tema.gif|OPEN ON  
 
 
PRINTING TO ADOBE ACROBAT DOCUMENT  
 
LBLPRINT labelname WHERE … OPTION PDF|FILENAME filespec |AUTHOR authorname |BACKGROUND_COLOR value|BACKGROUND_FILE filespec|BACKGROUND_TYPE value|COMPRESSION_METHOD value|FONT_ENCODING value|IMAGE_FORMAT value|IMAGE_DPI value|PIXELFORMAT value|INCLUDE_IMAGES|INCLUDE_LINES|INCLUDE_RICHTEXT|INCLUDE_SHAPES| JPEG_QUALITY value|RICHTEXT_ENCODING_TYPE value|SUBJECT <value>|TITLE <value>|USE_COMPRESSION|  
 
FILENAME  
filename of PDF-file  
 
AUTHOR  
Stores the name of the author of the label.  
 
BACKGROUND_COLOR  
Indicates the color to be used as background color of all pages of label (default : White)  
 
·AQUA  
·BLACK  
·BLUE  
·CREAM  
·DARK GRAY  
·FUCHSIA  
·GRAY  
·GREEN  
·LIME  
·LIGHT GRAY  
·MAROON  
·MEDIUM GRAY  
·MINT GREEN  
·NAVY  
·OLIVE  
·PURPLE  
·RED  
·SILVER  
·SKY BLUE  
·TEAL  
·WHITE  
·YELLOW  
 
BACKGROUND_FILE  
Stores the image file name that is to be used as background image of all pages of label.  
 
BACKGROUND_TYPE  
Specifies the way background image has to be displayed in the bmp-file.  
 
·TILE  
·TOPLEFT  
·TOPCENTER  
·TOPRIGHT  
·CENTERLEFT  
·CENTER  
·CENTERRIGHT  
·BOTTOMLEFT  
·BOTTOMCENTER  
·BOTTOMRIGHT  
 
COMPRESSION_METHOD  
Specifies the type of compression to be used to compress text and Image.  
 
·FASTEST  
·NORMAL  
·MAXCOMPRESS  
 
FONT_ENCODING  
Specifies the type of font encoding to be used to encode font.  
 
·WIN_ANSI  
·MAC_ROMAN  
·MAC_EXPERT  
·STANDART  
·PDF_DOC  
 
IMAGE_FORMAT  
Specifies the Linked image file format for image controls used in the label  
 
·GIF  
·JPG  
·BMP  
 
IMAGE_DPI  
Indicates the DPI value to be used while encoding images.  
 
PIXELFORMAT  
Specifies the pixel format of the bmp-file (bits/pixel)  
 
·1 : 1bit  
·4 : 4bit  
·8 : 8bit  
·15 : 15bit  
·16 : 16bit  
·24 : 24bit  
·32 : 32bit  
 
INCLUDE_IMAGES  
Specifies whether Images on the label should be included in the exported file.  
 
·ON  
·OFF  
 
INCLUDE_LINES  
Specifies whether lines on the label should be included in the exported file.  
 
·ON  
·OFF  
 
INCLUDE_RICHTEXT  
Specifies whether contents of the RichText objects on the label should be included in the exported file  
 
·ON  
·OFF  
 
INCLUDE_SHAPES  
Specifies whether shapes on the label should be included in the exported file.  
 
·ON  
·OFF  
 
JPEG_QUALITY  
Specifies the Quality of the JPEG Image. Used when IMAGE_FORMAT = JPG.  
 
RICHTEXT_ENCODING_TYPE  
Specify the way in which RichText contents should be encoded in exported PDF document. Set RICHTEXT_ENCODING_TYPE to IMAGE to encode RichText contents as exact graphical representations. Set RICHTEXT_ENCODING_TYPE to PLAINTEXT to encode RichText contents as unformatted text. The font used when encoding RichText as plain text is the one set in the Font property of the RichText object.  
 
·IMAGE  
·PLAINTEXT  
 
SUBJECT  
Stores the subject of the label.  
 
TITLE  
Stores the title of the label.  
 
USE_COMPRESSION  
Specifies whether compression should be used.  
 
·ON  
·OFF  
 
OPEN  
Specifies whether the label should be opened after it is generated  
 
·ON  
·OFF  
 
Example:  
LBLPRINT CustomerLabels option pdf|filename d:\testbmp.bmp|BACKGROUND_COLOR WHITE|AUTHOR LYOLIK|OPEN ON  
 
 
PRINTING TO HTML DOCUMENT  
 
LBLPRINT labelname WHERE … OPTION HTML|FILENAME filespec |AUTHOR authorname |BACKGROUND_COLOR value|BACKGROUND_FILE filespec| BACKGROUND_TYPE value| CSSFILE filespec| IMAGE_FORMAT value| IMAGE_FOLDER value|IMAGE_DPI value|PIXELFORMAT value|INCLUDE_IMAGES value|INCLUDE_LINES value |INCLUDE_RICHTEXT value |INCLUDE_SHAPES value |JPEG_QUALITY value|KEYWORDS value|LINK_BACK_COLOR value| LINK_H_BACK_COLOR value|LINK_H_FORE_COLOR value|LINK_IMG_FILE_FIRST filespec|LINK_IMG_FILE_LAST filespec|LINK_IMG_FILE_NEXT filespec| LINK_IMG_FILE_PREV filespec|LINK_TEXT_FIRST value|LINK_TEXT_LAST value| LINK_TEXT_NEXT value|LINK_TEXT_PREV value|NAV_ORIENT value|NAV_POS value|NAV_TYPE value|PAGE_END_LINES value|RICHTEXT_ENCODING_TYPE value| SEP_FILE_PER_PAGE value|NAV_SHOW value|SUBJECT value|TITLE value| USE_TEXT_LINKS value|OPEN value|  
 
FILENAME  
filename of HTML-file  
 
AUTHOR  
Stores the name of the author of the label.  
 
BACKGROUND_COLOR  
Indicates the color to be used as background color of all pages of label (default : White)  
 
·AQUA  
·BLACK  
·BLUE  
·CREAM  
·DARK GRAY  
·FUCHSIA  
·GRAY  
·GREEN  
·LIME  
·LIGHT GRAY  
·MAROON  
·MEDIUM GRAY  
·MINT GREEN  
·NAVY  
·OLIVE  
·PURPLE  
·RED  
·SILVER  
·SKY BLUE  
·TEAL  
·WHITE  
·YELLOW  
 
BACKGROUND_FILE  
Stores the image file name that is to be used as background image of all pages of label.  
 
BACKGROUND_TYPE  
Specifies the way background image has to be displayed in the bmp-file.  
 
·TILE  
·TOPLEFT  
·TOPCENTER  
·TOPRIGHT  
·CENTERLEFT  
·CENTER  
·CENTERRIGHT  
·BOTTOMLEFT  
·BOTTOMCENTER  
·BOTTOMRIGHT  
 
CSSFILE  
Stores the name of the CSS file.  
 
·<filespec>  
 
IMAGE_FORMAT  
Specifies the Linked image file format for image controls used in the label  
 
·GIF  
·JPG  
·BMP  
 
IMAGE_DPI  
Indicates the DPI value to be used while encoding images.  
 
PIXELFORMAT  
Specifies the pixel format of the bmp-file (bits/pixel)  
 
·1 : 1bit  
·4 : 4bit  
·8 : 8bit  
·15 : 15bit  
·16 : 16bit  
·24 : 24bit  
·32 : 32bit  
 
INCLUDE_IMAGES  
Specifies whether Images on the label should be included in the exported file.  
 
·ON  
·OFF  
 
INCLUDE_LINES  
Specifies whether lines on the label should be included in the exported file.  
 
·ON  
·OFF  
 
INCLUDE_RICHTEXT  
Specifies whether contents of the RichText objects on the label should be included in the exported file  
 
·ON  
·OFF  
 
INCLUDE_SHAPES  
Specifies whether shapes on the label should be included in the exported file.  
 
·ON  
·OFF  
 
JPEG_QUALITY  
Specifies the Quality of the JPEG Image. Used when IMAGE_FORMAT = JPG.  
 
·1-100  
 
KEYWORDS  
Stores the list of keywords used in the label. Specify a list of keywords for the document that should be encoded as the Keywords Meta content.  
 
LINK_BACK_COLOR  
Indicates the background color of navigator. It will be used only if SEP_FILE_PER_PAGE ON and NAV_SHOW ON.  
 
·AQUA  
·BLACK  
·BLUE  
·CREAM  
·DARK GRAY  
·FUCHSIA  
·GRAY  
·GREEN  
·LIME  
·LIGHT GRAY  
·MAROON  
·MEDIUM GRAY  
·MINT GREEN  
·NAVY  
·OLIVE  
·PURPLE  
·RED  
·SILVER  
·SKY BLUE  
·TEAL  
·WHITE  
·YELLOW  
 
LINK_H_BACK_COLOR  
Indicates the background color of navigator when the mouse is hovered over it. It will be used only if SEP_FILE_PER_PAGE ON and NAV_SHOW ON.  
 
·AQUA  
·BLACK  
·BLUE  
·CREAM  
·DARK GRAY  
·FUCHSIA  
·GRAY  
·GREEN  
·LIME  
·LIGHT GRAY  
·MAROON  
·MEDIUM GRAY  
·MINT GREEN  
·NAVY  
·OLIVE  
·PURPLE  
·RED  
·SILVER  
·SKY BLUE  
·TEAL  
·WHITE  
·YELLOW  
 
LINK_H_FORE_COLOR  
Indicates the color of navigator when the mouse is hovered over it. It will be used only if SEP_FILE_PER_PAGE ON and NAV_SHOW ON.  
 
·AQUA  
·BLACK  
·BLUE  
·CREAM  
·DARK GRAY  
·FUCHSIA  
·GRAY  
·GREEN  
·LIME  
·LIGHT GRAY  
·MAROON  
·MEDIUM GRAY  
·MINT GREEN  
·NAVY  
·OLIVE  
·PURPLE  
·RED  
·SILVER  
·SKY BLUE  
·TEAL  
·WHITE  
·YELLOW  
 
 
LINK_IMG_FILE_FIRST  
Indicates the filename of the image to be used as navigator image linking to first page. It will be used only if SEP_FILE_PER_PAGE ON and NAV_SHOW ON and USE_TEXT_LINKS OFF.  
 
·<filespec>  
 
LINK_IMG_FILE_LAST  
Indicates the filename of the image to be used as navigator image linking to last page. It will be used only if SEP_FILE_PER_PAGE ON and NAV_SHOW ON and USE_TEXT_LINKS OFF.  
 
·<filespec>  
 
LINK_IMG_FILE_NEXT  
Indicates the filename of the image to be used as navigator image linking to last page. It will be used only if SEP_FILE_PER_PAGE ON and NAV_SHOW ON and USE_TEXT_LINKS OFF.  
 
·<filespec>  
 
LINK_IMG_FILE_PREV  
Indicates the filename of the image to be used as navigator image linking to previous page. It will be used only if SEP_FILE_PER_PAGE ON and NAV_SHOW ON and USE_TEXT_LINKS OFF.  
 
·<filespec>  
 
LINK_TEXT_FIRST  
Indicate the text that should be used as the caption for the first page navigator link that appear at the bottom of the produced HTML. SEP_FILE_PER_PAGE ON and NAV_SHOW ON and USE_TEXT_LINKS ON.  
 
·<value>  
 
LINK_TEXT_LAST  
Indicate the text that should be used as the caption for the last page navigator link that appear at the bottom of the produced HTML. SEP_FILE_PER_PAGE ON and NAV_SHOW ON and USE_TEXT_LINKS ON.  
 
·<value>  
 
LINK_TEXT_NEXT  
Indicate the text that should be used as the caption for the next page navigator link that appear at the bottom of the produced HTML. SEP_FILE_PER_PAGE ON and NAV_SHOW ON and USE_TEXT_LINKS ON.  
 
·<value>  
 
LINK_TEXT_PREV  
Indicate the text that should be used as the caption for the previous page navigator link that appear at the bottom of the produced HTML. SEP_FILE_PER_PAGE ON and NAV_SHOW ON and USE_TEXT_LINKS ON.  
 
·<value>  
 
NAV_ORIENT  
Specifies the orientation of the navigator. if NAV_ORIENT HOR then, a Horizontal navigator is encoded, else a Vertical navigator is encoded. NAV_ORIENT will be considered only when SEP_FILE_PER_PAGE ON and NAV_SHOW ON.  
 
·VERT  
·HOR  
 
NAV_POS  
Specifies the position of the navigator. NAV_POS will be considered only when SEP_FILE_PER_PAGE ON and NAV_SHOW ON.  
 
·TOPLEFT  
·TOPCENTER  
·TOPRIGHT  
·CENTERLEFT  
·CENTER  
·CENTERRIGHT  
·BOTTOMLEFT  
·BOTTOMCENTER  
·BOTTOMRIGHT  
 
NAV_TYPE  
Specifies the type of the navigator. If NAV_TYPE SCREEN then the navigator will be fixed to screen, else the navigator will be fixed to page. NAV_TYPE will be considered only when SEP_FILE_PER_PAGE ON and NAV_SHOW ON.  
 
·PAGE  
·SCREEN  
 
PAGE_END_LINES  
Indicates whether a line should be drawn at the end of each page. Setting PAGE_END_LINES to ON draws a line after each page. PAGE_END_LINES is considered only when SEP_FILE_PER_PAGE OFF.  
 
·ON  
·OFF  
 
RICHTEXT_ENCODING_TYPE  
Specify the way in which RichText contents should be encoded in exported PDF document. Set RICHTEXT_ENCODING_TYPE to IMAGE to encode RichText contents as exact graphical representations. Set RICHTEXT_ENCODING_TYPE to PLAINTEXT to encode RichText contents as unformatted text. The font used when encoding RichText as plain text is the one set in the Font property of the RichText object.  
 
·IMAGE  
·PLAINTEXT  
 
NAV_SHOW  
Set to ON to show a collection of links that enable easy navigation between pages of the exported HTML. The links function much like the navigator buttons in the standard preview of Label Preview: one link to jump to the first page; one to the last page; one to the next page and another to get back to the previous page. NAV_SHOW is only effective when SEP_FILE_PER_PAGE ON.  
 
·ON  
·OFF  
 
SUBJECT  
Stores the subject of the label.  
 
TITLE  
Stores the title of the label.  
 
USE_TEXT_LINKS  
Indicate the type of the navigator links that should be encoded for a multi-file HTML output. Setting USE_TEXT_LINKS to ON uses the text provided in LINK_TEXT_FIRST, LINK_TEXT_LAST, LINK_TEXT_NEXT and LINK_TEXT_PREV as the hyperlink's caption. Setting to OFF uses Images specified by LINK_IMG_FILE_FIRST, LINK_IMG_FILE_LAST, LINK_IMG_FILE_NEXT, LINK_IMG_FILE_PREV. The property is effective only when SEP_FILE_PER_PAGE ON and NAV_SHOW ON.  
 
·ON  
·OFF  
 
OPEN  
Specifies whether the label should be opened after it is generated  
 
·ON  
·OFF  
 
Example:  
LBLPRINT CustomerLabels option HTML|filename d:\testhtml.html|BACKGROUND_COLOR WHITE|AUTHOR LYOLIK|OPEN ON  
 
 
PRINTING TO WMF(Windows Metafile)  
 
LBLPRINT labelname WHERE … OPTION WMF|FILENAME <value>|BACKGROUND_COLOR <value>|BACKGROUND_FILE <value>| BACKGROUND_TYPE <value>|SCALEX <value>|SCALEY <value>|OPEN <value>|  
 
FILENAME  
filename of wmf-file  
 
BACKGROUND_COLOR  
Indicates the color to be used as background color of all pages of label (default : White)  
 
·AQUA  
·BLACK  
·BLUE  
·CREAM  
·DARK GRAY  
·FUCHSIA  
·GRAY  
·GREEN  
·LIME  
·LIGHT GRAY  
·MAROON  
·MEDIUM GRAY  
·MINT GREEN  
·NAVY  
·OLIVE  
·PURPLE  
·RED  
·SILVER  
·SKY BLUE  
·TEAL  
·WHITE  
·YELLOW  
 
BACKGROUND_FILE  
Stores the image file name that is to be used as background image of all pages of label.  
 
BACKGROUND_TYPE  
Specifies the way background image has to be displayed in the wmf-file.  
 
·TILE  
·TOPLEFT  
·TOPCENTER  
·TOPRIGHT  
·CENTERLEFT  
·CENTER  
·CENTERRIGHT  
·BOTTOMLEFT  
·BOTTOMCENTER  
·BOTTOMRIGHT  
 
SCALEX  
double; Scaling factor for the width of the exported page  
 
SCALEY  
double; Scaling factor for the height of the exported page  
 
OPEN  
Specifies whether the label should be opened after it is generated  
 
·ON  
·OFF  
 
Example:  
 
LBLPRINT CustomerLabels option wmf|filename d:\testbmp.wmf|BACKGROUND_COLOR WHITE|BACKGROUND_TYPE TILE|BACKGROUND_FILE d:\tema.gif|OPEN ON  
 
 
PRINTING TO EMF(Enhanced Metafile)  
 
LBLPRINT labelname WHERE … OPTION EMF|FILENAME <value>|BACKGROUND_COLOR <value>|BACKGROUND_FILE <value>| BACKGROUND_TYPE <value>|SCALEX <value>|SCALEY <value>|OPEN <value>|  
 
FILENAME  
filename of emf-file  
 
BACKGROUND_COLOR  
Indicates the color to be used as background color of all pages of label (default : White)  
 
·AQUA  
·BLACK  
·BLUE  
·CREAM  
·DARK GRAY  
·FUCHSIA  
·GRAY  
·GREEN  
·LIME  
·LIGHT GRAY  
·MAROON  
·MEDIUM GRAY  
·MINT GREEN  
·NAVY  
·OLIVE  
·PURPLE  
·RED  
·SILVER  
·SKY BLUE  
·TEAL  
·WHITE  
·YELLOW  
 
BACKGROUND_FILE  
Stores the image file name that is to be used as background image of all pages of label.  
 
BACKGROUND_TYPE  
Specifies the way background image has to be displayed in the emf-file.  
 
·TILE  
·TOPLEFT  
·TOPCENTER  
·TOPRIGHT  
·CENTERLEFT  
·CENTER  
·CENTERRIGHT  
·BOTTOMLEFT  
·BOTTOMCENTER  
·BOTTOMRIGHT  
 
SCALEX  
double; Scaling factor for the width of the exported page  
 
SCALEY  
double; Scaling factor for the height of the exported page  
 
OPEN  
Specifies whether the label should be opened after it is generated  
 
·ON  
·OFF  
 
Example:  
 
LBLPRINT CustomerLabels option emf|filename d:\testbmp.emf|BACKGROUND_COLOR WHITE|BACKGROUND_TYPE TILE|BACKGROUND_FILE d:\tema.gif|OPEN ON  
 
 
PRINTING TO TXT-File  
 
LBLPRINT labelname WHERE … OPTION TXT|FILENAME <value>|OPEN <value>  
 
FILENAME  
filename of txt-file  
 
OPEN  
Specifies whether the label should be opened after it is generated  
 
·ON  
·OFF  
 
Example:  
 
LBLPRINT CustomerLabels option txt|filename d:\test.txt|OPEN ON  
 
 
PRINTING TO Label Emulation Text File  
 
LBLPRINT labelname WHERE … OPTION ETXT|FILENAME <value>|OPEN <value>  
 
FILENAME  
filename of Label Emulation Text File  
 
OPEN  
Specifies whether the label should be opened after it is generated  
 
·ON  
·OFF  
 
LBLPRINT CustomerLabels option etxt|filename d:\test.txt|OPEN ON  
 
 
PRINTING TO RTF File  
 
LBLPRINT labelname WHERE … OPTION RTF | FILENAME <filespec> | AUTHOR <value>| BACKGROUND_COLOR <value> | BACKGROUND_TYPE <value> | BACKGROUND_FILE <filespec> | IMAGE_FORMAT <value> |IMAGE_DPI <value>| INCLUDE_SHAPES <value> | INCLUDE_IMAGES <value> | INCLUDE_IMAGES <value> |INCLUDE_LINES <value> | INCLUDE_RICHTEXT <value> |JPEG_QUALITY <value>|KEYWORDS <value>|SUBJECT <value>|TITLE <value>|OPEN <value>|  
 
FILENAME  
filename of RTF File  
 
AUTHOR  
Stores the name of the author of the label.  
 
BACKGROUND_COLOR  
Indicates the color to be used as background color of all pages of label (default : White)  
 
·AQUA  
·BLACK  
·BLUE  
·CREAM  
·DARK GRAY  
·FUCHSIA  
·GRAY  
·GREEN  
·LIME  
·LIGHT GRAY  
·MAROON  
·MEDIUM GRAY  
·MINT GREEN  
·NAVY  
·OLIVE  
·PURPLE  
·RED  
·SILVER  
·SKY BLUE  
·TEAL  
·WHITE  
·YELLOW  
 
BACKGROUND_FILE  
Stores the image file name that is to be used as background image of all pages of label.  
 
BACKGROUND_TYPE  
Specifies the way background image has to be displayed in the rtf-file.  
 
·TILE  
·TOPLEFT  
·TOPCENTER  
·TOPRIGHT  
·CENTERLEFT  
·CENTER  
·CENTERRIGHT  
·BOTTOMLEFT  
·BOTTOMCENTER  
·BOTTOMRIGHT  
 
IMAGE_FORMAT  
Specifies the Linked image file format for image controls used in the label  
 
·GIF  
·JPG  
·BMP  
 
IMAGE_DPI  
Indicates the DPI value to be used while encoding images.  
 
INCLUDE_IMAGES  
Specifies whether Images on the label should be included in the exported file.  
 
·ON  
·OFF  
 
INCLUDE_LINES  
Specifies whether lines on the label should be included in the exported file.  
 
·ON  
·OFF  
 
INCLUDE_RICHTEXT  
Specifies whether contents of the RichText objects on the label should be included in the exported file  
 
·ON  
·OFF  
 
INCLUDE_SHAPES  
Specifies whether shapes on the label should be included in the exported file.  
 
·ON  
·OFF  
 
JPEG_QUALITY  
Specifies the Quality of the JPEG Image. Used when IMAGE_FORMAT = JPG.  
 
KEYWORDS  
Stores the list of keywords used in the label. Specify a list of keywords for the document that should be encoded as the Keywords Meta content.  
 
SUBJECT  
Stores the subject of the label.  
 
TITLE  
Stores the title of the label.  
 
OPEN  
Specifies whether the label should be opened after it is generated  
 
·ON  
·OFF  
 
 
PRINTING TO Excel File  
 
LBLPRINT labelname WHERE … OPTION XLS | FILENAME <filespec> | INCLUDE_RICH_TEXT <value>| LINE_SPACE <value>| CELL_ATTR <value>|OPEN <value>|  
 
FILENAME  
filename of Excel File  
 
INCLUDE_RICHTEXT  
Specifies whether contents of the RichText objects on the label should be included in the exported file  
 
·ON  
·OFF  
 
LINE_SPACE  
Indicate the amount of spacing between lines  
 
·ACTUAL  
·0  
·1  
·2  
·3  
·4  
·5  
 
CELL_ATTR  
Cell attributes include shading of the cell whose color is not WHITE  
 
OPEN  
Specifies whether the label should be opened after it is generated  
 
·ON  
·OFF  
 
LBLPRINT CustomerLabels option XLS|filename d:\test.xls|OPEN ON  
 
 
PRINTING TO TIFF-File  
 
LBLPRINT labelname WHERE … OPTION TIFF|FILENAME <value> |PIXELFORMAT <value>|BACKGROUND_COLOR <value>|BACKGROUND_FILE <value>|BACKGROUND_TYPE <value>|MONOCHROME <value>|COMPRESSION <value> |MULTIPAGE <value>|SCALEX <value>|SCALEY <value>|OPEN <value>|  
 
FILENAME  
filename of TIFF-file  
 
PIXELFORMAT  
Specifies the pixel format of the GIF-file (bits/pixel)  
 
·1 : 1bit  
·4 : 4bit  
·8 : 8bit  
·15 : 15bit  
·16 : 16bit  
·24 : 24bit  
·32 : 32bit  
 
BACKGROUND_COLOR  
Indicates the color to be used as background color of all pages of label (default : White)  
 
·AQUA  
·BLACK  
·BLUE  
·CREAM  
·DARK GRAY  
·FUCHSIA  
·GRAY  
·GREEN  
·LIME  
·LIGHT GRAY  
·MAROON  
·MEDIUM GRAY  
·MINT GREEN  
·NAVY  
·OLIVE  
·PURPLE  
·RED  
·SILVER  
·SKY BLUE  
·TEAL  
·WHITE  
·YELLOW  
 
BACKGROUND_FILE  
Stores the image file name that is to be used as background image of all pages of label.  
 
BACKGROUND_TYPE  
Specifies the way background image has to be displayed in the TIFF-file.  
 
·TILE  
·TOPLEFT  
·TOPCENTER  
·TOPRIGHT  
·CENTERLEFT  
·CENTER  
·CENTERRIGHT  
·BOTTOMLEFT  
·BOTTOMCENTER  
·BOTTOMRIGHT  
 
MONOCHROME  
Specifies whether TIFF-file produced are color or monochrome images  
 
·ON  
·OFF  
 
COMPRESSION  
When an image is loaded, this parameter indicates the compression used by the image. When saving in image, the parameter may be set to specify which compression method to use.  
 
·NONE - None  
·PACKBITS - Packbits  
·GROUP3_1D - CCITT Group 3, 1D  
·GROUP3_2D - CCITT Group 3, 2D  
·GROUP4 - CCITT Group 4  
·ZLIB - Zlib(Default)  
·JPEG - JPEG  
 
MULTIPAGE  
Output label to one multipage file or one file per page.  
 
·ON  
·OFF  
 
SCALEX  
double; Scaling factor for the width of the exported page  
 
SCALEY  
double; Scaling factor for the height of the exported page  
 
OPEN  
Specifies whether the label should be opened after it is generated  
 
·ON  
·OFF  
 
Example:  
 
LBLPRINT CustomerLabels option TIFF|filename d:\test.tiff|OPEN ON  
 

About the LBLPRINT Command

To send labels to a file or a printer, use the OUTPUT command to designate the output device before the LBLPRINT command. (The default output device is the screen.) After printing the labels, be sure to return the output to the screen. When you send labels to a file, R:BASE only writes the last buffer of information to the file after the OUTPUT SCREEN command is run.

Examples

The following command lines print labels using the employee table. The labels are printed in the order that the names are stored in the table. After the labels are printed, R:BASE directs output back to the screen.

OUTPUT PRINTER
LBLPRINT emplabel
OUTPUT SCREEN

The following command lines print labels in ascending zip code order, from the smallest to the largest zip code. After the labels are printed, R:BASE directs output back to the screen.

OUTPUT PRINTER
LBLPRINT emplabel ORDER BY empzip
OUTPUT SCREEN


The following command lines print a row of test labels to check the alignment of the label stock in your printer.

OUTPUT PRINTER
LBLPRINT emplabel CHECK ORDER BY empzip
OUTPUT SCREEN

The following command displays the mailing labels on screen in ascending zip code order, up to and including zip code 98100. Any labels with zip codes greater than 98100 are not displayed.

LBLPRINT emplabel WHERE empzip <= 98100 ORDER BY empzip