Kbase 15715: Report Builder Adding attributes to fields of memo files
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
5/10/1998 |
|
Report Builder Adding attributes to fields of memo files
Report Builder Adding attributes to fields of memo files
Introduction:
=============
Report Builder provides the capability to attach ASCII files
to the reports, in order to include the text of those files
into the reports. These files may contain fields of tables as
well. An example of the use of this is to build personalized
letters. Report Builder reference's this as memo files.
Inside the memo files there are 'special' characters to format
text and fields (font style, font size, bold, italic, etc).
If you want to add an attribute to a field on a memo
file you need to use the existing formatting characters,
fully documented in Report Builder User's Manual, but...
How to add attributes to the fields in those memo files:
========================================================
If you need a specific attribute or format not provided by
the formatting characters you can do it as follows:
1) Create a calculated field on the report and assign to it
the field you need to customize.
2) Include in the expression of this field all the
formatting you need, using the built in functions
available.
3) Create another calculated field and use for it the
built-in function IFF. Assign value "" for true and false
conditions.
This calculated field must be inserted in the report,
(e.g. in the band line where the memo field is)
This is because, if the calculated field is not included
in the report, it is not processed. So the right way is to
create a calculated field that, even included in the report
(and printed) do not modify the output of the report itself
("" will be printed).
Example:
========
Want to print in uppercase the field CUSTOMER.NAME included
in a memo file.
1) Follow the RB documentation to build the ASCII
memo file and to attach it to a report.
2) Create the first calculated field:
Calculated field name: wcname
Expression: CAPS (customer.name)
3) Create the second calculated field:
Calculated field name: wlname
Expression: IFF (wcname = ?, "", "")
Include this second calculated field (wlname) in the
report.
Additional documentation:
=========================
Report Builder User's Guide.
Progress Software Technical Support Note # 15715