Progress
Report Builder
Tutorial


Defining New Fields

To create the invoice, you must create three user-defined fields. Follow these steps to create these fields:

  1. Create a calculated field, City–State–PC, to format the customer’s city, state, and postal code. Use the following expression:
  2. City + ”, ” + State + ” ” + Postal–Code

  3. Create an aggregate field, Order–Total, to compute the total amount of each order. Specify the settings listed in the following table:
  4. Option
    Setting
    Type
    Total
    Field
    Order–Line.Extended–Price
    Reset
    2) Order–num
    Accumulation
    Every Composite
    Processing
    Final Pass

  5. Create an aggregate field, Page–Total, to compute the total amount for each page. Specify the settings listed in the following table:
  6. Option
    Setting
    Type
    Total
    Field
    Order–Line.Extended–Price
    Reset
    Per–page
    Accumulation
    Every Composite
    Processing
    Final Pass


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