Table of Contents

Run_Label subroutine

Description

Runs Report Builder+ labels.

Syntax

Run_Label(LabelName,Select_Statement,Select_Option,Print_Option)

Parameters

The Run_Label subroutine has the following parameters.

ParameterDescription
LabelNameThe label name. Use the entity name of the fully-qualified entity id.
Select_StatementSelection criteria to use for label creation.
Select_OptionValue - Description
0 - The Preselect option. This option will run the embedded select statement in the saved label entity and then run the passed select statement.
1 - The Override option. This option will run the passed select statement only.
Print_OptionValue - Description
0 - Default. When the print option is set to 0 the labels will display in the print preview window.
1 - This value will bypass the preview screen and print directly to the printer.

Note

The Run_Label function is to be used with existing Report Builder Label records only.

Example

* The fully qualified entity id is EXAMPLES*OIREPORT*RBLABEL*CUSTOMER_ADDRESS
Declare Subroutine Run_Label
* Run the Existing Label Report

LabelName = 'CUSTOMER_ADDRESS'
Run_Label(LabelName,'','')

* Run the Existing Label Report

select_statement = "SELECT CUSTOMERS WITH STATE = 'NJ'"

Run_Label(LabelName,Select_Statement,1)