Record pointer is changed when Report Form command executes

[diem]

Hi everyone,

I'm trying to do a report for each record in the table and the record pointer keeps pointing to the beginning of the table when the Report Form command executes. For example, if the table has 5 records, then it will loop through each record and print out a report for that record. The first record seems ok and data for the first record are correct. But when the next record is pointed to and ready for the report, the record pointer is pointed back to the beginning of the table and it gets data from the first record. It seems to happen on the Report Form command line. When I browse the table before this Report Form command line, the record pointer is still pointing to correct record. Does anyone know how to fix this problem? Do I have to Set something to fix it? Thank you very much

 

[tesar]

You probably have no condition FOR by report.
You may try e.g. FOR recno() = 1 ,etc.

 

[weedz]

tesar is right,
if you issue a report form, it will report from the beginning to the end of the table/cursor.

It is the same as an SCAN ENDSCAN statement as well as with more VFP statements.

You will have to issue a FOR clause to tell the report what to print.

HTH,
Weedz (Wietze Veld)
My private project:

http://www.crowncap.demon.nl\info\crwnbase

And especially for VFP rookies:

http://fox.wikis.com/wc.dll?Wiki~VFPRookieMistakes~VFP

 

[mallee]

try report form xxx next 1

 

[diem]

Hi everyone,

Thank you for all your help. The tips really helped fixing my report problem. I appreciate it.

Thanks

 

[geralyn]

I don't know if this is a visual foxpro report, but if it is you may want to edit the report and be certain that you don't have the table opened in the data environment.