View previous topic :: View next topic
|
Author |
Message |
srinathds83
New User
Joined: 17 Jul 2007 Posts: 41 Location: pune
|
|
|
|
Hi,
I need the report to print header either after 60 lines(Page Break) or if Account type changes(Section Break).
Below sort card is working perfectly when account type changes but not printing the header after 60 lines.
Code: |
SORT FIELDS=COPY
OUTFIL FNAMES=RPT,LINES=60,
SECTIONS=(1,4,SKIP=P,
HEADER3=(1:'DATE : ',9:DATE=(MD4-),31:'ACCOUNTING SYSTEM',
68:'PAGE :',PAGE,/,
21:'REPORT OF THE ACCOUNTS',2/,
30:'ACCOUNT TYPE : ',1,4,2/,
05:'ACCOUNT NUMBER',
25:'ACCOUNT HOLDER NAME ',/),
TRAILER3=(/,
2:'TOTAL : ',
29:COUNT=(EDIT=(IIIT)),2/)),
OUTREC=(05:10,10,
25:26,30) |
Please provide a solution where after 60 lines report header also prints.
Thanks,
Srinath |
|
Back to top |
|
|
Bill Woodger
Moderator Emeritus
Joined: 09 Mar 2011 Posts: 7309 Location: Inside the Matrix
|
|
|
|
Can you try with HEADER1 instead of HEADER3? |
|
Back to top |
|
|
srinathds83
New User
Joined: 17 Jul 2007 Posts: 41 Location: pune
|
|
|
|
Hi,
Bill Woodger wrote: |
Can you try with HEADER1 instead of HEADER3? |
I tried using HEADER1 instead of HEADER 3. It shows Syntax error.
Code: |
JCP0482E WER268A OUTFIL STATEMENT : SYNTAX ERROR |
Thanks
Srinath |
|
Back to top |
|
|
Bill Woodger
Moderator Emeritus
Joined: 09 Mar 2011 Posts: 7309 Location: Inside the Matrix
|
|
|
|
In HEADER1 you put the stuff which can never change.
In HEADER3 you put the stuff which changes in your SECTIONS. |
|
Back to top |
|
|
srinathds83
New User
Joined: 17 Jul 2007 Posts: 41 Location: pune
|
|
|
|
Bill Woodger wrote: |
In HEADER1 you put the stuff which can never change.
In HEADER3 you put the stuff which changes in your SECTIONS. |
'ACCOUNT TYPE :' is the part of header and it keeps on changing. my requirement is to get it on every page.
Page break should happen if ACCOUNT TYPE changes or 60 lines for the same ACCOUNT TYPE crosses. |
|
Back to top |
|
|
Bill Woodger
Moderator Emeritus
Joined: 09 Mar 2011 Posts: 7309 Location: Inside the Matrix
|
|
|
|
Should be HEADER2, not HEADER1 :-)
Have a look at your SyncSort manual. There's a PAGEHEAD on SECTIONS. You may need HEADER2 for it to work, but if so perhaps try HEADER2 with just a blank, so the actual header is from HEADER3. |
|
Back to top |
|
|
srinathds83
New User
Joined: 17 Jul 2007 Posts: 41 Location: pune
|
|
|
|
Bill Woodger wrote: |
Should be HEADER2, not HEADER1 :-)
Have a look at your SyncSort manual. There's a PAGEHEAD on SECTIONS. You may need HEADER2 for it to work, but if so perhaps try HEADER2 with just a blank, so the actual header is from HEADER3. |
Thanks Bill.... Just by adding PAGEHEAD keyword, i got the desired result. |
|
Back to top |
|
|
Bill Woodger
Moderator Emeritus
Joined: 09 Mar 2011 Posts: 7309 Location: Inside the Matrix
|
|
|
|
Thanks for letting us know.
Next time, manual first, then colleagues, then forum... |
|
Back to top |
|
|
|