Progress
Report Builder
User’s Guide


Removing a Calculated Field

There are three different ways to remove calculated fields:

When you cut a calculated field from the report layout, you remove it from the layout but it remains defined for the report definition. That means that it is a valid selection in the Insert Fields dialog box. However, once you delete or purge a field, you cannot paste it back into the report layout.

There are two differences between deleting and purging calculated field definitions. The first difference is that while you can delete individual field definitions, purging removes all the unused calculated field definitions not currently in the layout for the report definition. The second difference is that you cannot purge a field definition for a calculated field that is in use on the report layout—you must delete it. You cannot purge a calculated field definition if it is in use either on the layout or in another user-defined field.

Therefore, before you attempt to remove a calculated field from a report definition, consider whether it is in use in the report layout or if it is part of the expression of an aggregate or calculated field that is in use in the report layout. To see what calculated fields are not in use in a report layout, choose Calculations Purge Calculations, choose Calculated Fields, then choose OK. The Purge Calculations dialog box appears listing all the calculated fields not in use.

NOTE: Report Builder cannot detect whether a calculated field is embedded in a memo file. Therefore, if the report definition has a memo file attached that contains embedded fields, use caution when purging calculated fields.


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