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 wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Report Question

Status
Not open for further replies.

asm338s

Programmer
Jul 16, 2001
135
US
I am using the 'REPORT FOR' command to send the output to a file. I want it to print only the first 19 record on the first page and the rest on the second page. Following is the coding that I am using:
ON PAGE AT LINE 20 EJECT
REPORT FORM ABC.FRX FOR nName NEXT 19 TO ....FILE
Now, if i say
REPORT FOR ABC1.FRX FOR nName REST TO....FILE, it prints all the records. for some reason it is moving the record pointer to the top. I tried GOTO RECORD 20 IN tableused, between the 2 reports, but it still prints all record for the name specified.
 
Instead NEXT , REST try recno() < 20 , recno() > 19
 
I would do it a little different

use dbf order tag from cdx
set filter to whatever
goto top
report form xxx next 20 to file xxx
goto top
skip 20
report form xxx rest to file xxx
set filter to David W. Grewe
Dave@internationalbid.com
ICQ VFP ActiveList #46145644
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top