Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to print a report on one record of a table?
Message
From
16/01/1997 09:03:02
 
 
To
15/01/1997 23:30:14
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
00017497
Message ID:
00017510
Views:
57
>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.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform