>>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.
it could also be the data environment for the report. i usually don't use this because of this kind of behavior (also i usually use sql cursors to run reports)