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:
- Create an aggregate field, Record–Count, that counts the number of records in the report using the settings in the following table:
Option Setting Type Count Field Cust–Num Reset No–reset Accumulation Every Composite Processing Final Pass- Create the Band–Choice calculated field with the following expression:
((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 |