Progress
Report Builder
User’s Guide
Removing Aggregate Fields
There are three different ways to remove aggregate fields:
When you cut an aggregate field from the report layout, you remove it from the layout, but it remains defined for the report. 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 or insert it back into the report layout.
There are two differences between deleting and purging aggregate field definitions. The first difference is that while you can delete individual field definitions, purging removes all the unused aggregate field definitions not currently in the layout for the report definition. The second difference is that you cannot purge a field definition for an aggregate field that is in use on the report layout—you must delete it. You cannot purge an aggregate field definition if it is in use either on the layout or in another user-defined field.
Therefore, before you attempt to remove an aggregate 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 aggregate fields are not in use in a report layout, choose Calculations
Purge Calculations, choose Aggregate Fields, then choose OK. The Purge Calculations dialog box appears listing all the aggregate fields not in use.
NOTE: Report Builder cannot detect whether an aggregate 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 aggregate fields.
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |