Progress
Report Builder
User’s Guide


LENGTH

Returns the length of a character string.

SYNTAX

LENGTH ( string ) 

string

A character expression (a constant, field name, or expression that results in a character value).

Report Builder counts any trailing spaces. The length of a null string is zero.

EXAMPLE

To produce a list of customers (Name) and phone numbers (Phone) with a dot leader (...) between them, use LENGTH with FILL as follows:

Name + FILL(".", 60 - LENGTH(Name + Phone)) +  Sales-Rep 

To make the data align to the left and right margins, you must used a fixed-pitch font.

Sample report:

Aerobics Valines KY............................(90) 054 6399
Antin Metsastysase.............................(71) 432 1317
Aragon College................................. 714/321-1800 


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095