Progress
Report Builder
Tutorial


Defining New Fields

For this form letter, you must create two calculated fields. The first field is the City–State–PC field that you created in Mailing Labels." When you use City–State–PC in conjunction with the appropriate fields from the Newsport database, you personalize the form letter for each customer. The second calculated field displays the current system date. Follow these steps:

  1. Create a calculated field called City–State–PC that has the following expression:
  2. City + ”, ” + State + ” ” + Postal–Code

    This expression formats the fields with the standard spacing and punctuation used in addresses.

  3. Create a calculated field called Today–Date that has the following expression:
  4. TODAY()

    TODAY() is a Report Builder function that displays the current system date in the default date format (99/99/99). See the “Report Builder Functions” appendix in the Progress Report Builder User’s Guide for complete descriptions of the built-in Report Builder functions.


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