Use the LABEL subcommand in a SELECT command or a SETTING command to re-position a column legend (heading). By default, the column legend prints at the top of a column. The LABEL subcommand enables you to change the heading default by electing to place the legend to the left of the column (for every record), or not to print a legend at all.
Note To use the Report Editor to specify a LABEL subcommand in the SETTING command statement, use the Default Label Placement section in the Page Setup dialog.
The label position for an individual field can be specified in the Report Editor using the Property Layout section of the Select <class> Properties to Print dialog.
LABEL subcommand structure
The structure of the LABEL subcommand is similar regardless of the command keyword you are using. However, the SETTING command requires a { (BEGIN) statement before and an } (END) statement after its subcommands.
SETTING { [ LABEL LEFT | TOP | NONE ] } SELECTLABEL [ LABEL LEFT | TOP | NONE ]
Note The square brackets [ ] are not part of the syntax. They merely enclose the subcommand-qualifiers to delineate them from the subcommand itself.
Examples – SELECT LABEL subcommand
These three examples demonstrate how you can use the full potential of the LABEL subcommand to exactly place the column legends in your reports.
Shows how to code a SETTING command statement to place the column legends at the top of each report column, and a sample of the result.
Note This subcommand may be used in the global or local definition blocks. If used in the global definition block, the instructions apply to every report in the Report Definition file. If used in the local definition block, the instructions apply only to that report. Any instructions indicated in a SETTING LABEL command statement can be overridden by a SELECT LABEL command statement.
Example 1 – SETTING LABEL LEFT subcommand
SETTING Name { LABEL LEFT }
The label instructions in this example print the legend to the left of each name value extracted from the database.
Sample output The report statements above produces this output where each value of the Name field is at the left margin with the legend to the left of the field value. Colons are automatically placed after the heading when the label is placed to the left.
Name : Book Reservation Name : Form Letter Processing Name : Inventory Tracking Name : Library System
Example 2 – SETTING LABEL subcommand
SETTING Name { LABEL NONE } SETTING Type { LABEL LEFT } SETTING Class { LABEL TOP }
Sample output The report statements above produce this output where the Name fields have no label, the Type fields are at the left margin with the legend to the left of each field value, and the Class column is labeled at the top. Colons are automatically placed after the heading when the label is placed to the left. You may need to use the WIDTH command to position the columns exactly like this.