| sort-item | Index Level | sreformat |
| Syntax | sort-label file.reference {itemlist} {sellist} {seqlist} {outlist} {modlist} {(options)} |
| Category | Access |
| Type | Verb |
| Description |
produces one or more columns of output in order of the specified sort-key(s).
Outputs formatted labels or reports in columnar format from the specified file.reference, sequenced by one or more sort-key(s). After pressing <return> to submit the Access sentence for processing, a "?" prompt appears. This prompt is to supply the label output parameters: columns The number of labels across page. rows Number of print lines on each label. skip Number of lines (vertically) between labels. indent The number of spaces to indent from left the margin. size The number of print positions per label. space The number of spaces (horizontally) between labels. c Compresses null values. Each parameter must be separated by a comma. If the "indent" parameter is not zero, this command prompts for entry of the "header" text for each print line requested. If any text is entered at any of these prompts, that text will appear before the corresponding print line on the left-most (1st) column only. Pressing <return> at any of these prompts indicates a null header. |
| Options | * see "options: Access". |
| See Also | term modifiers seqlist sellist selection criteria itemlist options: sortc list-label Access verbs |
| Example |
:sort-label entity by zip contact company address csz (cip
?2,4,1,0,30,2,c The label parameters shown define the output as having 2 labels across, 4 lines each (contact, company, address & csz), skip 1 line, indent 0 (zero - assumes labels are mounted at first print position), 30 print positions each (longer strings are truncated to 30, in this case), space over 2 to the right between each label, and "c" for "compress" nulls (don't allow blank lines within the label). |
| Warnings | If problems exist with the formatting of the "sort-label" output, try using the "tcl-hdr-off" command first and a "k" option with the "sort-label" command. |
| Compatibility | D3 7.0 AP R83 |
| sort-item | Index Level | sreformat |