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


Appendix A Sample Report Definitions and Rules : Break Table Definitions

Break Table Definitions
DEPT_EXPENSE_SUM Break Table
The following illustration shows the definition for the DEPT_EXPENSE_SUM break 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

 
Expand Screens for the DEPT_EXPENSE_SUM Break Table
The following sections illustrate the expand screens for the fields TOT_DEP_EXP, TOTAL_EXP, MAX_EXP, and MAX_TOTAL_EXP.
Expand Screen for the TOT_DEP_EXP Field
The following illustration shows the expand screen for the TOT_DEP_EXP field:

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

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

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

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

 
COMMAND ==> Scroll:
-----------------------------------------------------------------------------
Literal: N Definition for FIELD: MAX_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 MAX_TOTAL_EXP
FUNCTION: Total: _ Count: _ Average: _ Max: S Min: _ Std Dev: _ Variance: _
OF Field: DEPT_MON_EXP
BY Field:
WHERE :
OR Source rule/field/text:
-----------------------------------------------------------------------------
Field Name Row Col Type Syntax Len Dec Just Blank Derived Display Mask
---------------- --- --- - - ---- --- - - - ------------
_ TOT_DEP_EXP 1 13 Q P 9 2 R N Y
PFKEYS: 3=SAVE 12=CANCEL
Enter/change FIELD DEFINITION for "MAX_TOTAL_EXP"

 
Titles/Headings Screen for the DEPT_EXPENSE_SUM Break Table
The following illustration shows the Titles/Headings screen for the DEPT_EXPENSE_SUM break table:

 
Titles/Headings
COMMAND ==> Scroll: P
TTTTTTTTTTT____________FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF
_ 1 Total Exp ¬99999.99 ¬99999.99
_ 2
_ 3 Max Monthly
_ 4 Expense ¬99999.99 ¬99999.99
_ 5
_ 6
-----------------------------------------------------------------------------
Page Width: 132 Justify
Title(s)
-------------------------------------------------------- -
_
_
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