Report Generator (REPGEN)

The Report Generator utility provides a mechanism for defining and producing ad-hoc reports, which can be run on-line or within the Close of Business Batch process.

Creating the Report steps :
ex: creating ACCT.LIST.DAUS
1. REPGEN.CREATE
REPORT.NAME……. ACCT.LIST.DAUS
——————————————————————————
1. 1 REPORT.TITLE… LIST OF ACCOUNT
3 USING.132.COLUMNS. Y
4. 1 LANGUAGE.CODE.. 1 English
5. 1 READ.FILE…… ACCOUNT
11. 1 DEFINE.MNEMONIC ACC.NUM
13. 1. 1 MNEMON.FIELD 1 CUSTOMER
14. 1. 1 MODIFICATION REPLACE
15. 1. 1 MODIF.FILE.. CUSTOMER CUSTOMER
16. 1. 1 MODIF.FIELD. 2 XX.LL.SHORT.NAME
19. 1 NUMBER.OF.CHAR. 35
23. 1 DISPLAY.TYPE… 2 LINE
11. 2 DEFINE.MNEMONIC CUS.NUM
13. 2. 1 MNEMON.FIELD 1 CUSTOMER
19. 2 NUMBER.OF.CHAR. 6
20. 2 SPECIAL.MASK… R######
21. 2 MASK……….. R######
22. 2 KEY.TYPE……. 1 SEQUENCE CONTROL
23. 2 DISPLAY.TYPE… 2 LINE
11. 3 DEFINE.MNEMONIC CUS.NAME
13. 3. 1 MNEMON.FIELD 3 ACCOUNT.TITLE.1
19. 3 NUMBER.OF.CHAR. 35
23. 3 DISPLAY.TYPE… 2 LINE
11. 4 DEFINE.MNEMONIC ACCT.BALANCE
13. 4. 1 MNEMON.FIELD 27 WORKING.BALANCE
19. 4 NUMBER.OF.CHAR. 8
20. 4 SPECIAL.MASK… R########
21. 4 MASK……….. R########
23. 4 DISPLAY.TYPE… 2 LINE
76 SORT.FILE.TYPE…. 2
77 SORT.FILE.MODULO.. 11
83 SPECIAL.HEADING… STANDARD
86 DATE.TIME.COMPILER 27 JUN 08 14:44
87. 1 CO.CODE.SORT… GB-001-0001
88. 1 DATE.TIME.SORT. 27 JUN 08 14:59
95 CURR.NO……….. 2
96. 1 INPUTTER……. 32_USER,___OFS_BROWSERTC
97. 1 DATE.TIME…… 27 JUN 08 14:38
98 AUTHORISER…….. 34_ATIDAUS2
99 CO.CODE……….. GB-001-0001 R8 MODEL BANK
100 DEPT.CODE……… 1
After commit it, then authorize.

2. REPGEN.SORT
KEY…………… ACCT.LIST.DAUS
——————————————————————————
1. 1 DESCRIPTION…. Account List by Daus
2 REPORT.NAME……. ACCT.LIST.DAUS LIST OF ACCOUNT
3 DATE.TIME.COMPILER 27 JUN 08 14:44
4 DATE.TIME.SORT…. 27 JUN 08 14:59
10. 1 DATE.TIME…… 27 JUN 08 14:59
11 AUTHORISER…….. 37_ATIDAUS2
12 CO.CODE……….. GB-001-0001 R8 MODEL BANK
Commit it.

3. REPGEN.OUTPUT
KEY…………… ACCT.LIST.DAUS
——————————————————————————
1. 1 DESCRIPTION…. Account List by Daus
2 DISPLAY.OR.PRINT.. DISPLAY
3 REPORT.NAME……. ACCT.LIST.DAUS LIST OF ACCOUNT
4 DATE.TIME.COMPILER 27 JUN 08 14:44
5 DATE.TIME.SORT…. 27 JUN 08 14:59
13. 1 DATE.TIME…… 27 JUN 08 15:00
14 AUTHORISER…….. 37_ATIDAUS2
15 CO.CODE……….. GB-001-0001 R8 MODEL BANK
Commit it.

4. Logout and login again

5. REPGEN.SOURCE

6. Verify ACCT.LIST.DAUS record of REPGEN.SORT and REPGEN.OUTPUT (at Classic)

7. The output result will show

For more detail see on Report Generator.pdf