|
View previous topic :: View next topic
|
| Author |
Message |
sureshbabu.jv
New User
Joined: 11 Apr 2006
Posts: 41
Location: Chennai
|
|
|
|
I have written a new easytrieve program to create the summary report with ',' delimiter .The data is coming fine and getting the ',' delimiter for the line/header records but not coming for the Last summary record.Due to this summary record was not correctly formatted in the excel.
Please let me know if we can implement delimiter for the summary record also else I have to use SORT card to put the delimiter that I do not want.
Thanks,
Suresh |
|
| Back to top |
|
 |
Ramsee
New User
.jpg)
Joined: 06 Jan 2011
Posts: 53
Location: Chennai
|
|
|
|
Hi Sureshbabu,
Could you please provide an easy example with the current input file and output file and your expected output for better understanding of your issue. |
|
| Back to top |
|
|
sureshbabu.jv
New User
Joined: 11 Apr 2006
Posts: 41
Location: Chennai
|
|
|
|
Input file have the below date. Last record is detail copy/summary record.It will be created by easytreive SEQUENCE.CONTROL statements.
| Code: |
DLR Number ,Principal ,Shares ,Trans Code ,
",="0111 ",100 ", "5 ",="ABC",
",="0111 ",200 ", "10 ",="cDF",
0111 300 15 |
I have used the delimter to get the data in CSV format and it's coming fine for header and line records but not for last summary record as it was created by easytreive prgoram. Not sure how we can add the delimter within the program instead using extertnal sort insert the delimter.
Code'd |
|
| Back to top |
|
|
Bill Woodger
Moderator Emeritus
Joined: 09 Mar 2011
Posts: 7309
Location: Inside the Matrix
|
|
|
|
Having not shown the code for the REPORT:
Have a look at CONTROL .. NOPRINT. That will stop Easytrieve Plus printing the total.
Then you need a report procedure. BEFORE-BREAK or AFTER-BREAK will do, since you've turned off the printing. In that PROC you put a DISPLAY statement naming the fields you want to print, and any other literals.
You'll probably need your manual if you have not used report procedures before, but they are simple to use. |
|
| Back to top |
|
|
|
|
