Kbase 15562: How to prevent RB from using format for BREAKs and AGGREGATE
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/05/1998 |
|
How to prevent RB from using format for BREAKs and AGGREGATE
Until version 8.0A, Report Builder used the formats defined in a
report to perform BREAKs and evaluate AGGREGATE FIELDs, contrary to
the 4GL and what is said in the documentation. Normally the formats
should only be useful for the displays.
For example, consider sports database, table customer, field name.
If that field is defined format "x(1)", Report Builder will assume
that all names beginning with the same letter belong to the same
BREAK group.
The workarounds are:
1) - to define the field with a large format, as large as the
field can contain data.
- then to reduce the width so that there are as many characters
as one wants the report to contain.
2) Before the report is saved, insert the same field with a large
format and delete it. Report builder will take the last format for the
last format for calculations.
3) Place the field on the report with the format as large as
necessary, then copy and paste it. Edit the pasted copy so that it has
the display format you want, then delete the original field from the
layout. Report Builder will use the format of the original when
evaluating the aggregate fields.
Progress Software Technical Support Note # 15562