>I have created a one page report using the wizrd, then modified for visual pleasure. It is basically a printed version of one record in a table. I need to be able to print this for any record. But I cannot use a for clause, because the table has over 25,000 records in it. I used to use a command REPORT FORM NEXT 1, but it keeps giving me the first record. Any suggestions?
>
Yes, I suspect the wizard generated code is going to the first record in the table before you issue the REPORT FORM ... NEXT 1
Using the good old-fashioned SEEK command you can rapidly locate the record you want to print and THEN do your report command.
Given a table of Assessors, with a primary key AssKey based on iAssID field, I do things like:
SEEK( lnAssessor, "Assessor", "AssKey")
REPORT FORM ... WHILE iAssID = lnAssessor
or
SEEK( lnAssessor, "Assessor", "AssKey")
REPORT FORM ... REST
So that I can determine what is to be reported.