View previous topic :: View next topic
|
Author |
Message |
Nethraa
New User
Joined: 02 Feb 2010 Posts: 16 Location: chennai
|
|
|
|
Hi all,
My Requirement is to create the Report in the Following format.
XXX-01 REPROT1
Bank1
Bank Table/Key start Date End Date
A 11 0003 01/01/08 03/01/10
A 22 0004 01/01/08 03/01/10
A 33 0115 12/30/08 01/30/10
B 44 0116 03/06/09 02/04/10
C 55 0117 03/06/09 02/04/10
Summary Total
A 3
B 1
C 1
Total for Corp 5
* END OF REPORT
XXX-01 REPROT1
Bank2
Bank Table/Key Start Date End Date
A 11 0003 01/01/08 03/01/10
A 22 0004 01/01/08 03/01/10
C 44 0116 03/06/09 02/04/10
D 55 0117 03/06/09 02/04/10
E 66 0118 01/01/08 03/01/10
Summary Total
A 3
C 1
D 1
E 1
Total for Corp 6
* END OF REPORT
To create the above report i have coded as follows:
Code: |
REPORT RPT1 LINESIZE(132) +
NOSPREAD NOADJUST NODATE +
PRINTER(RPT1)
SEQUENCE OUT-B1 OUT-TABLE-ID
CONTROL OUT-B1 NOPRINT NEWPAGE RENUM
TITLE 1 COL 1 'XXX-01' +
COL 30 'REPORT1' +
COL 90 'RUN:' SYSDATE
TITLE 2 COL 1 'BANK1:' OUT-B1 +
COL 90 'AS OF: ' W-RUNDATE
HEADING OUT-B1 ('BANK')
HEADING OUT-TABLE-ID ('TABLE' 'IND')
HEADING OUT-START-DT ('START' 'DATE')
HEADING OUT-END-DT ('END' 'DATE')
LINE 01 OUT-B1 +
OUT-TABLE-ID +
OUT-START-DT +
OUT-END-DT
*
BEFORE-BREAK. PROC
IF T-IDENT = 'A'
W-T-IDENT-03 = 'A'
AFTER-BREAK. PROC
IF LEVEL = 1
DISPLAY SKIP 3 ' '
DISPLAY SKIP 4 ' CORP SUMMARY SUMMARY TOTALS'
DISPLAY SKIP 5 ' ------------ --------------'
DISPLAY SKIP 4 W-T-IDENT-03 TALLY
ELSE
END-IF
END-PROC |
Basically it is a Bank break report.
but i am not getting the Summary and Total report properly.
If anyone have any suggestions to resolve this issue please let me know.
Regards,
Nethraa. |
|
Back to top |
|
|
PeterHolland
Global Moderator
Joined: 27 Oct 2009 Posts: 2481 Location: Netherlands, Amstelveen
|
|
|
|
Try SUMMARY SUMCTL(HIAR) on the REPORT statement.
Hope that will work. |
|
Back to top |
|
|
Nethraa
New User
Joined: 02 Feb 2010 Posts: 16 Location: chennai
|
|
|
|
Hi,
Thank you for your reply. But it is not working for the report.
Herewith again i have attached the report.
If anyone have any suggestion please let me know regardng this.
Code: |
1XXX-01 TABLE REPORT
BANK: B1
-
TABLE START END
BANNK IND DATE DATE
0 B1 AAAA B1 000 07/01/00 04/31/10
AAAA B1 001 07/28/03 04/31/10
AAAA B1 002 11/01/01 04/31/10
XXXX B1 003 11/29/00 04/31/10
XXXX B1 029 11/30/11 04/31/10
XXXX B1AAA0005 02/21/02 03/10/10
0
0 BANK SUMMARY SUMMARY TOTALS
0 ------------ --------------
0
0 AAAA 3
0 XXXX 3
0
0
0
0
0TOTAL VALUE : 6
*
1XXX-01 TABLE REPORT
BANK: B2
-
TABLE START END
BANNK IND DATE DATE
0 B2 AAAA B2 000 07/01/00 04/31/10
AAAA B2 001 07/28/03 04/31/10
AAAA B2 002 11/01/01 04/31/10
BBBB B2 003 11/29/00 04/31/10
XXXX B2 029 11/30/11 04/31/10
XXXX B22220005 02/21/02 03/10/10
0 BANK SUMMARY SUMMARY TOTALS
0 ------------ --------------
0
0 AAAA 3
0 BBBB 1
0 XXXX 2
0
0
0
0TOTAL VALUE : 6 |
|
|
Back to top |
|
|
PeterHolland
Global Moderator
Joined: 27 Oct 2009 Posts: 2481 Location: Netherlands, Amstelveen
|
|
|
|
As far as i remember TALLY has to be on the LINE statement so Easytrev
knows to use it for break processing. |
|
Back to top |
|
|
Nethraa
New User
Joined: 02 Feb 2010 Posts: 16 Location: chennai
|
|
|
|
Hi,
When i searched in the manual there is no syntax as TALLY with LINE statement. |
|
Back to top |
|
|
PeterHolland
Global Moderator
Joined: 27 Oct 2009 Posts: 2481 Location: Netherlands, Amstelveen
|
|
|
|
LINE 1 field1 field2 field3 TALLY
Im not sure in which manual you did a search.
All the info is in :
Reference Guide
Application Guide |
|
Back to top |
|
|
|