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


Appendix A Sample Report Definitions and Rules : Body Report Table Definitions

Body Report Table Definitions
DEPT_EXPENSE_SUM Report Table
The following illustration shows the definition for the DEPT_EXPENSE_SUM report table:

 
COMMAND ==> Scroll: P
....+....1....+....2....+....3....+....4....+....5....+....6....+....7....
_ 1 Employee Expenses by Department ¬AAA
_ 2 Month/Dept ¬999 Total
_ 3 ---------- --------- ---------
_ 4 ¬AA ¬99999.99 ¬99999.99
_ 5
_ 6
_ 7
_ 8
_ 9
Table: DEPT_EXPENSE_SUM Unit: USR40
Field Name Row Col Type Syntax Len Dec Just Blank Derived Display Mask
---------------- --- --- - - ---- --- - - - ------------
_ PAGENO 1 68 S C 4 0 L N Y
_ DEPTNO 2 16 I B 4 0 L N N Z9
_ MONTH_OF 4 1 S C 3 0 L N Y
_ DEPT_MON_EXP 4 13 Q P 9 2 R N Y
_ TOTAL_EXP 4 25 Q P 9 2 R N Y
_ EMPNO 0 0 I P 6 0 L N N
_ MONTH_NUMBER 0 0 S C 2 0 L N N
_ MONTHLY_EXP 0 0 Q P 9 2 R N N
PFKEYS: 6=+FLD 18=-FLD 5=CUT 17=PASTE 16=CNTL 15=EXPAND 4=TITLE/HEAD 19=SHIFT

 
Control Fields Screen for the DEPT_EXPENSE_SUM Report Table
The following illustration shows the Control Fields screen for the DEPT_EXPENSE_SUM report table:

 
COMMAND ==> Scroll: P
....+....1....+....2....+....3....+....4....+....5....+....6....+....7....
_ 1 Employee Expenses by Department ¬AAA
_ 2 Month/Dept ¬999 Total
_ 3 ---------- --------- ---------
_ 4 ¬AA ¬99999.99 ¬99999.99
-----------------------------------------------------------------------------
Sort_by A/D Break_by New Page Sort_Across_By Summary_By
---------------- - ----------------- - ---------------- ----------------
1 MONTH_NUMBER MONTH_NUMBER DEPTNO MONTH_NUMBER
2
3
Selection Criteria for Report DEPT_EXPENSE_SUM
1
2
-----------------------------------------------------------------------------
Field Name Row Col Type Syntax Len Dec Just Blank Derived Display Mask
---------------- --- --- - - ---- --- - - - ------------
_ PAGENO 1 68 S C 4 0 L N Y
_ DEPTNO 2 16 I B 4 0 L N N Z9
_ MONTH_OF 4 1 S C 3 0 L N Y
_ DEPT_MON_EXP 4 13 Q P 9 2 R N Y
PFKEYS: 3=SAVE 12=CANCEL 6=+FLD 18=-FLD 4=TITLE/HEAD 15=DERIVE 19=SHIFT

 
Expand Screens for the DEPT_EXPENSE_SUM Report Table
The following sections illustrate the expand screens for the fields MONTH_OF, DEPT_MON_EXP, and TOTAL_EXP.
Expand Screen for the MONTH_OF Field
The following illustration shows the expand screen for the MONTH_OF field:

 
COMMAND ==> Scroll:
-----------------------------------------------------------------------------
Literal: N Definition for FIELD: MONTH_OF
Row : 4 Col: 1
Type: S Syntax: C Length: 3 Decimal Places: 0 Justify: L
Display Mask:
Globalfield Name :
LITERAL/DERIVED Field Definition MONTH_OF
FUNCTION: Total: _ Count: _ Average: _ Max: _ Min: _ Std Dev: _ Variance: _
OF Field:
BY Field:
WHERE :
OR Source rule/field/text: CONVERTDATE(MONTH_NUMBER)
-----------------------------------------------------------------------------
Field Name Row Col Type Syntax Len Dec Just Blank Derived Display Mask
---------------- --- --- - - ---- --- - - - ------------
_ PAGENO 1 68 S C 4 0 L N Y
PFKEYS: 3=SAVE 12=CANCEL
Enter/change FIELD DEFINITION for "MONTH_OF"

 
Expand Screen for the DEPT_MON_EXP Field
The following illustration shows the expand screen for the DEPT_MON_EXP field:

 
COMMAND ==> Scroll:
-----------------------------------------------------------------------------
Literal: N Definition for FIELD: DEPT_MON_EXP
Row : 4 Col: 13
Type: Q Syntax: P Length: 9 Decimal Places: 2 Justify: R
Display Mask:
Globalfield Name :
LITERAL/DERIVED Field Definition DEPT_MON_EXP
FUNCTION: Total: S Count: _ Average: _ Max: _ Min: _ Std Dev: _ Variance: _
OF Field: MONTHLY_EXP
BY Field: DEPTNO MONTH_NUMBER
WHERE :
OR Source rule/field/text:
-----------------------------------------------------------------------------
Field Name Row Col Type Syntax Len Dec Just Blank Derived Display Mask
---------------- --- --- - - ---- --- - - - ------------
_ PAGENO 1 68 S C 4 0 L N Y
PFKEYS: 3=SAVE 12=CANCEL
Enter/change FIELD DEFINITION for "DEPT_MON_EXP"

 
Expand Screen for the TOTAL_EXP Field
The following illustration shows the expand screen for the TOTAL_EXP field:

 
COMMAND ==> Scroll:
-----------------------------------------------------------------------------
Literal: N Definition for FIELD: TOTAL_EXP
Row : 4 Col: 25
Type: Q Syntax: P Length: 9 Decimal Places: 2 Justify: R
Display Mask:
Globalfield Name :
LITERAL/DERIVED Field Definition TOTAL_EXP
FUNCTION: Total: S Count: _ Average: _ Max: _ Min: _ Std Dev: _ Variance: _
OF Field: MONTHLY_EXP
BY Field: MONTH_OF
WHERE :
OR Source rule/field/text:
-----------------------------------------------------------------------------
Field Name Row Col Type Syntax Len Dec Just Blank Derived Display Mask
---------------- --- --- - - ---- --- - - - ------------
_ PAGENO 1 68 S C 4 0 L N Y
PFKEYS: 3=SAVE 12=CANCEL
Enter/change FIELD DEFINITION for "TOTAL_EXP"

 
Titles/Headings Screen for the DEPT_EXPENSE_SUM Report Table
The following illustration shows the Titles/Headings screen for the DEPT_EXPENSE_SUM report table:

 
Titles/Headings
COMMAND ==> Scroll: P
TTTTTTTTTTT____________FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF
T 1 Employee Expenses by Department ¬AAA
H 2 Month/Dept ¬999 Total
H 3 ---------- --------- ---------
_ 4 ¬AA ¬99999.99 ¬99999.99
_ 5
_ 6
-----------------------------------------------------------------------------
Page Width: 132 Justify
Title(s)
-------------------------------------------------------- -
’Employee’ _
’Expenses’ _
Link Headings to Fields : N
Field Heading(s) Justify
---------------- ------------------------------------------------------ -
_
_
PFKEYS: 3=SAVE 12=CANCEL ENTER=UPDATE

 

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