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:
- Choose Calculations
Calculated Field. Because this is the first calculated field for this report, the New Calculation dialog box appears:
![]()
- Type City–State–PC in the Calculated Field Name fill-in field.
- Type the following expression in the Expression fill-in field:
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.
- Choose Verify to check the expression syntax.
- Choose OK to create the field. The Calculated Fields dialog box appears.
- Choose Close to return to the report layout.
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |