Thanks. So after the first time i use the 'Report for' then i should say 'on page at line' and then 'report for' the remaining records. If not, then is there another way because i am using the report fields to access data from 2 different tables, and put them in text file.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
jimstarr - page break
- Thread starter asm338s
- Start date
Hi
1. You give the commands as given below...
ON PAGE AT LINE nLineNumber EJECT
REPORT for ... command only once.
where nLineNumber is the Line in which you want to eject.
SO you dont have to set the report command again for next page.
2. Alternative way...
If you are [rocessing the records within a loop and sending the output to printer.. then within the loop... put the code..
IF prow() > 60
EJECT
ENDIF
Hope this helps ramani :-9
(Subramanian.G)
FoxAcc
ramani_g@yahoo.com
LET KNOW IF THIS HELPED. ENOUGH EXPERTS ARE HERE TO HELP YOU OUT! BEST OF LUCK
1. You give the commands as given below...
ON PAGE AT LINE nLineNumber EJECT
REPORT for ... command only once.
where nLineNumber is the Line in which you want to eject.
SO you dont have to set the report command again for next page.
2. Alternative way...
If you are [rocessing the records within a loop and sending the output to printer.. then within the loop... put the code..
IF prow() > 60
EJECT
ENDIF
Hope this helps ramani :-9
(Subramanian.G)
FoxAcc
ramani_g@yahoo.com
LET KNOW IF THIS HELPED. ENOUGH EXPERTS ARE HERE TO HELP YOU OUT! BEST OF LUCK
- Thread starter
- #4
It doesn't seem to wanna work. This is what I am doing:
on page at line 19 EJECT PAGE
Report FORM abc.frx for name1 next 19 NOCONSOLE TO FILE original.txt ASCII
theform = FILETOSTR('original.txt')
Fputs(gnErrFile, CHR(27) + '*p8Y' + CHR(27) + '*p4X')
Fputs(gnErrFile,CHR(27)+ '&f3X') && This calls the overlay for the form to be printed
Fputs(gnErrFile, theform)
on page at line 19 EJECT PAGE
Report FORM abc.frx for name1 next 19 NOCONSOLE TO FILE original.txt ASCII
theform = FILETOSTR('original.txt')
Fputs(gnErrFile, CHR(27) + '*p8Y' + CHR(27) + '*p4X')
Fputs(gnErrFile,CHR(27)+ '&f3X') && This calls the overlay for the form to be printed
Fputs(gnErrFile, theform)
- Thread starter
- #5
Adding to what I wrote earlier:
'report for' && for the first set of records
theform = FILETOSTR('original.txt')
Fputs(gnErrFile, CHR(27) + '*p8Y' + CHR(27) + '*p4X')
Fputs(gnErrFile,CHR(27)+ '&f3X')
Fputs(gnErrFile, theform)
Now if i say:
'report for' rest for the remaining records to be printed on the next page, it prints all the records as somehow how the record pointer is at the begining. I tried using 'goto record 20 in table1', but still it is at the begining.
'report for' && for the first set of records
theform = FILETOSTR('original.txt')
Fputs(gnErrFile, CHR(27) + '*p8Y' + CHR(27) + '*p4X')
Fputs(gnErrFile,CHR(27)+ '&f3X')
Fputs(gnErrFile, theform)
Now if i say:
'report for' rest for the remaining records to be printed on the next page, it prints all the records as somehow how the record pointer is at the begining. I tried using 'goto record 20 in table1', but still it is at the begining.
- Status
Similar threads
- Locked
- Question