Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Inconsistent data loss on VFP report
Message
From
09/10/2002 12:52:27
Cindy Winegarden
Duke University Medical Center
Durham, North Carolina, United States
 
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
00709333
Message ID:
00709368
Views:
22
> Data for the report is collected into 2 temporary files, with the file containing the detail-line data (multiple records per student) related into the 2nd temp file (one record per student).

Nancy, to go a little further with what Sergey said, printing reports from related tables is often the source of hard-to-debug problems. After I learned to print from one denormalized cursor many of my problems went away.

The lesson: select all of the data exactly the way you want it to be on the report into one cursor and print from there. In the report controls refer to the data as MyField only, not MyTable.MyField. If the SELECT runs right before the REPORT the cursor will always be the current work area.
Previous
Reply
Map
View

Click here to load this message in the networking platform