Progress
Report Builder
User’s Guide


FILL

Repeats a character expression a specified number of times. The maximum number of characters allowed in the function result is 8,000.

SYNTAX

FILL ( expression , repeats ) 

expression

A constant, field name, or expression that evaluates to a character value.

repeats

A constant, field name, or expression with an integer value up to 512. The FILL function uses this value to repeat the expression you specify. If the value of repeats is less than or equal to 0, FILL produces a null string.

EXAMPLE

To print a line of asterisks after each record in a report, create a calculated field containing the expression:

FILL(’*’, 50) 

Include it in a record line after a line of fields, such as in the following report layout:

Name                  Order-date      Amount
xxxxxxxxxxxxxxxxxxxxxxmm/dd/yy        ($999.99)
xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx 

Sample report output:

Name                   Order-date     Amount
ABC Mountain Bikes     01/10/94       $216.00
******************************************
MAtch Point Tennis     01/10/94       $96.00
******************************************
Jazz Futis Kauppa      01/10/94       $144.00 


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