Copyright © TIBCO Software Inc. All Rights Reserved
Copyright © TIBCO Software Inc. All Rights Reserved


Chapter 8 Painting the Report Tables : Using Predefined Fields

Using Predefined Fields
You can use predefined fields to create definitions for your report fields, unless these fields have a syntax of RD (raw data) or UN (Unicode). There are two types of predefined fields:
Using Table Field Definitions
You can use fields and their definitions from any type of predefined table to simplify the assignment of data and promote the shareability of data definitions. For example, when creating a monthly expense report, you can import employee field definitions from the employee table. To use a fields in a table, use one of the following primary commands:
You can copy all the fields of a table, some fields from a table, or individual fields from a table. Both the COPY and APPEND commands copy only complete fields and they copy only as many fields as can fit within the defined page width.
Information is entered into both the image and field definition areas of the Report Table Painter screen when you use these commands. The length information is converted into a display length, so the value entered into the length specification could be different from the stored value. Copied report fields can be changed in all the same ways as any other existing report fields.
Copying Fields from an Existing Table Definition
To copy fields and their definitions from a predefined table, use the COPY command. The fields are copied into the current report table (the image area is cleared when you invoke the command). If there is not sufficient room, only the fields that fit on the screen are copied. In the case of a report table, the Row and Column specifications and control information (SORT, BREAK, and so on) are also copied and they are positioned according to their existing Row and Column specifications. Specify one of the following in conjunction with the COPY command:
A listing of fields appears. Place an alphanumeric character in the line command field next to the fields that you require. The selected fields are copied into the image area in the order 0-9, A-Z when you press PF3.
From this table, all fields that do not have a syntax of RD (raw data) or UN (Unicode) are copied into the current report table.
You can also specify the NONAMES option. If NONAMES is not used, the field name is copied as a literal with the field added beside it. If the NONAMES option is specified, the field name is not copied as a literal.
Appending Fields from an Existing Table Definition
To append fields and their definitions from a predefined table into the current report table, use the APPEND command. The fields are added at the line below the cursor position, if there is sufficient room. If there is insufficient room, only the fields that fit in the report table are appended. If the cursor is not positioned in the image area, the fields are added after the existing fields. Specify one of the following:
A listing of fields appears. Place an alphanumeric character in the line command field next to the fields that you require. The selected fields are appended into the image area in the order 0-9, A-Z when you press PF3.
From this table, all fields that do not have a syntax of RD (raw data) or UN (Unicode) are appended into the current table.
You can also specify the option NONAMES. If NONAMES is not used, the field name is appended as a literal with the field added beside it. If the NONAMES option is specified, the field name is not appended as a literal.
Considerations When Appending Fields
The following points should be noted about appending fields:
The field of a non-report table that is overlapping an existing report field cannot be appended. If you are appending a report table, the row and column specifications are also copied. Because of this, the report fields are positioned according to their existing definition and not at the cursor position.
Pressing PF3 causes all the fields to be copied; the position of the overlapping field is set to 0,0.
PF4=COPY/NO OVERLAP
Pressing PF4 all the fields to be copied, except the field that is overlapping. A message appears stating that not all requested fields are copied.
If an appended field is defined as a control field in its source table and control fields exist in the report table, the following list of options appears:
Pressing PF3 causes the field to be copied and defined as a control field; the field is positioned after the control fields already defined for the report table.

Copyright © TIBCO Software Inc. All Rights Reserved
Copyright © TIBCO Software Inc. All Rights Reserved