Progress
Report Builder
Tutorial


Defining New Fields

To display specific band lines in a different color, you must create two user-defined fields.

Follow these steps to create the user-defined fields for the report:

  1. Create an aggregate field, Record–Count, that counts the number of records in the report using the settings in the following table:
  2. Option
    Setting
    Type
    Count
    Field
    Cust–Num
    Reset
    No–reset
    Accumulation
    Every Composite
    Processing
    Final Pass

  3. Create the Band–Choice calculated field with the following expression:
  4. ((Record–Count - 1) / 3) MODULO 2 = 0

    This expression returns either a 0 or 1 for each band line. The number 3 in the expression causes the value to change after every third record so that Report Builder prints three records with a green bar, then three records without a green bar, and so on.


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