Progress
Report Builder
Tutorial


Defining New Fields

Because the address line that contains the city, state, and postal code requires spacing and punctuation between its components, you create a calculated field to automatically format the fields.

Follow these steps to create the City–State–PC calculated field:

  1. Choose Calculations Calculated Field. Because this is the first calculated field for this report, the New Calculation dialog box appears:
  2. Type City–State–PC in the Calculated Field Name fill-in field.
  3. Type the following expression in the Expression fill-in field:
  4. City + ”, ” + State + ” ” + Postal–Code

    The quotation marks between the City and State fields contain a comma and a space. The State and Postal–Code fields contain two blank spaces.

  5. Choose Verify to check the expression syntax.
  6. Choose OK to create the field. The Calculated Fields dialog box appears.
  7. Choose Close to return to the report layout.

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