Please enable JavaScript to view this site.

R:BASE 11 Help

Navigation: Command Index > L > LBLPRINT

TXT

Scroll Prev Top Next More

The TXT output option displays the label in a text file format.

 

Caution:

This text file option requires the bands to be defined within the Label Designer. From the main menu bar, select "File" > "Print to Text File Setup..."

 

If a user attempts to print the label as a text file using the OPTION TXT parameter without first having defined the "Text File Setup" within the Label Designer, an error message will be displayed and a zero length file will be created. The same rule applies when printing a label to a text file from the Database Explorer.  

 

For step-by-step instructions on how to set up a label to print as Text File, please see Printing Report as Text File.

 

Syntax:

 

LBLPRINT labelname ARRANGE clause WHERE clause .. ORDER BY clause .. OPTION TXT

 

 

The following OPTION parameters are available to customize the output:

 

Parameter

Value

Description

FILENAME

value

Specifies the full path and filename. If no path is defined, output will be saved in the current working directory.

SHOW_CANCEL_DIALOG

ON (default)

OFF

Specifies whether to suppress cancel dialog box during the print process.  

OPEN

ON

OFF

Specifies whether the report should be opened after it is generated.

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.

EMAIL

ON

OFF

Specifies the report output (defined as FILENAME filename.ext ) to be sent via e-mail as an attachment. See additional options when EMAIL value is set to ON. EMAIL SET ON

 

Notes:

 

Each additional OPTION parameter must be separated by the pipe | symbol.

 

The TXT "Text File" option allows you to define a particular band to print the data as Comma Delimited, Tab Delimited or Fixed Length file. This is the perfect option to export selective and/or summarized data used in a label band.

 

 

Example:

 

--To print a label as a Text file

LBLPRINT CustomerLabels WHERE CustID = 128 +

OPTION TXT +

|FILENAME CustLab128.TXT +

|SHOW_CANCEL_DIALOG OFF +

|OPEN ON