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


Appendix A Sample Report Definitions and Rules : Basic Report and Rule Definition

Basic Report and Rule Definition
MAN_DEP_SAL Report
The following illustration shows the definition for the MAN_DEP_SAL report generated from the Report Generator:

 
DEFINE REPORT: MAN_DEP_SAL Unit: USR40
Command ===>
Page Length: 60 Page Width : 132 Fill Missing Data : .
REPORTTABLES: Origin Max Max Title Blank Title Heading Title Final
Name Row Col Occ Acr Only Overlap Rows Rows Cols Cols
---------------- --- --- ---- ---- - - -- -- --- ---
_ MAN_DEP_SAL 1 1 * 0 N 1 2 0 0
_
_
_
_
CONTROL BREAKS: Max Repeat Title Body Control
Name Acr Head Rows Reporttable Break Field
---------------- ---- - -- ---------------- ---------------
_ MAN_DEP_SAL$$$$1 0 1 MAN_DEP_SAL MANAGER_NAME
_ MAN_DEP_SAL$$$$2 0 1 MAN_DEP_SAL DEPTNAME
_ MAN_DEP_SAL$$$$3 0 0 MAN_DEP_SAL
_ 0

 
MAN_DEP_SAL_R Rule
The following illustration shows the definition for the MAN_DEP_SAL_R rule generated from the Report Generator:

 
MAN_DEP_SAL_R;
_
_ ---------------------------------------------------------------------------
_ ------------------------------------------------------------+--------------
_ FORALL EMPLOYEE(’MIDWEST’) WHERE MGR# = 79912 | MGR# = | 1
_ 80002 : |
_ FORALL DEPARTMENT(’BAYVILLE’) WHERE DEPTNO = |
_ EMPLOYEE.DEPTNO : |
_ FORALL MANAGER WHERE MANAGER_NUM = EMPLOYEE.MGR# : |
_ MAN_DEP_SAL.* = MANAGER.*; |
_ MAN_DEP_SAL.* = DEPARTMENT.*; |
_ MAN_DEP_SAL.* = EMPLOYEE.*; |
_ INSERT MAN_DEP_SAL(’MAN_DEP_SAL’); |
_ END; |
_ END; |
_ END; |
_ CALL $SETRPTMEDIUM(’MAN_DEP_SAL’,’VISUAL’, ’SCR’); | 2
_ PRINT MAN_DEP_SAL; | 3
_ CALL ENDMSG(MESSAGE(’@RPTGEN’, 602, ’MAN_DEP_SAL ’’SCR’’’) | 4
_ ); |
_ ---------------------------------------------------------------------------
_ ON LOGLIMIT :
_ CALL ENDMSG(MESSAGE(’@RPTGEN’, 698, ’’));

 
Depending on the selection specified, the selection criteria is allocated to the rule or it is allocated to the report definition. You can use this rule as a template and modify it as you require, or you can execute it to query your report.

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