Copyright © Cloud Software Group, Inc. All Rights Reserved
Copyright © Cloud Software Group, Inc. All Rights Reserved


Chapter 9 Extending Report Table Attributes : Task C: Add Titles and Headings

Task C: Add Titles and Headings
This task is used to:
The values you enter in the Titles/Headings screen are updated in the Report Definer screen and Report Painter screen, and vice versa.
Invoking the Titles/Headings Screen
To invoke the Titles/Headings screen, use PF4 from within the Report Table Painter.
Titles/Headings Screen

 
Titles/Headings
COMMAND ==> Scroll: P
__________________________________________________________________________
T 1 Employee Expense Report by Month
T 2
H 3 Employee Last Name ID # Monthly Exp
H 4 ---------------------- ------ -----------
_ 5 ¬AAAAAAAAAAAAAAAAAAAAA ¬99999 ¬99999.99
_ 6
-----------------------------------------------------------------------------
Page Width: 80 Justify
Title(s)
-------------------------------------------------------- -
’Employee’ _
’Expense’ _
Link Headings to Fields : Y
Field Heading(s) Justify
---------------- ------------------------------------------------------ -
LNAME ’Employee’ ’Last’ ’Name’ _
LNAME ’----------------------’ _
PFKEYS: 3=SAVE 12=CANCEL ENTER=UPDATE
ROW MARKERS: H = HEADING T = TITLE COL MARKERS: F = FINAL T = TITLE

 
Defining Rows and Columns
To define the rows and columns of the report use the Titles/Headings segment as illustrated below:

 
Titles/Headings
COMMAND ==> Scroll: P
__________________________________________________________________________
T 1 ¬99999999 Employee Expense Report by Month
T 2
H 3 Employee Last Name ID # Monthly Exp
H 4 ---------------------- ------ -----------
5 ¬AAAAAAAAAAAAAAAAAAAAA ¬99999 ¬99999.99

 
Titles/Headings Segment Fields
The following table lists the placement and markers of the fields on the Titles/Headings segment. These entries are optional:
Rows selected must come immediately after the title rows and be consecutive. If title rows are not defined, heading rows must start in row 1.
Title Columns
Title columns must start at column 1, be consecutive, and precede the final columns.
Final Columns
Final columns must end in column -1 (the last column in the report) and be consecutive. You can use blanks or the underscore symbol as separators between the title columns and final columns.
The markers for rows are typed into the line command fields of the appropriate lines. The markers for columns are typed in a line bar that is provided across the top of the report.
Modifying the Width of the Report
To modify the width of the report, you can use the Page Width field. Changes to the page width are carried over to the Report Definition screen. The maximum width you can have for a report is 255 columns. The value given for page width is also used to justify the title rows.
Defining the Position of the Titles and Headings
You can also justify titles and headings using the Titles/Headings segment. This segment, as illustrated below, contains a display of the information currently in the rows defined as title and heading rows.

 
__________________________________________________________________________
T 1 ¬99999999 Employee Expense Report by Month
T 2
H 3 Employee Last Name ID # Monthly Exp
H 4 ---------------------- ------ -----------
5 ¬AAAAAAAAAAAAAAAAAAAAA ¬99999 ¬99999.99
_ 6
-----------------------------------------------------------------------------

 
Column Headings
The heading elements that appear are determined from the report fields on the first row directly below the last defined heading row. For example, the following headings are assigned to the fields directly below them:

 
Employee Last Name ID# Monthly Exp
--------------------- ------ ------------

 
Column Range
The column range is used to find headings for the report fields, on all heading rows. The range for the first report field on a row begins with the first column of a field on the row and ends with the position immediately before the next field. This range determination is repeated across the report for each report field, using the position immediately after the last report field as the starting point.
Justifying Titles and Headings
Each sub-section of the Titles/Headings screen can be scrolled vertically. You can justify your titles and headings using the Justify fields by entering the following values:
Blank (a null value) causes the text or fields to be positioned as they appear in the image area, that is, no justification is performed.
Linking the Heading to a Field
Using the Link Headings To Fields field, you can determine whether your headings are always aligned with the fields associated with them. The default is Y (yes) for non-across reports and N (no) for across reports. For a particular Report Table Painter session, you can change this value, and at the end of the session it reverts to the default. If the heading is also a field and it is above two or more fields, the value is automatically set to N.
The following sections illustrate the behavior displayed when the Link Headings to Fields field is set to Y and the field ID# is shifted right five spaces.
Position of Headings and Fields Before Shifting
The following illustration shows the position of headings and fields before shifting:

 
Employee Last Name ID# Monthly Exp
--------------------- ------ ------------
¬AAAAAAAAAAAAAAAAAAAA ¬99999 ¬999999.99

 
Position of Headings and Fields After Shifting
The following illustration shows the position of linked headings and fields after shifting right five spaces:

 
Employee Last Name ID# Monthly Exp
--------------------- ------ ------------
¬AAAAAAAAAAAAAAAAAAAA ¬99999 ¬999999.99

 
Position of Headings When Not Linked to Fields
The following illustration shows the position of headings when not linked to fields:

 
Employee Last Name ID# Monthly Exp
--------------------- ------ ------------
¬AAAAAAAAAAAAAAAAAAAA ¬99999 ¬999999.99

 

Copyright © Cloud Software Group, Inc. All Rights Reserved
Copyright © Cloud Software Group, Inc. All Rights Reserved