Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Inconsistent data loss on VFP report
Message
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
00709333
Message ID:
00709358
Views:
27
This message has been marked as the solution to the initial question of the thread.
Hi Nancy,

Sound like a problem described in PRB: One-to-Many Report Prints First Child If Scope Is One mskb #Q140489. To fix it I would combine two cursors into one.

>Hi,
>
>I'm struggling with a somewhat inconsistent problem in a VFP 6.0 report. The report (a student transcript) has a page header, 2 columns, and 2 groups - each with its own header and footer. Detail lines contain the data on the courses the student has taken. Almost every object on the report has some "print when" condition, and much of the data is programmatically formatted within memo fields before calling the report. Detail lines do not use memo fields, however. The report prints in landscape mode on 8.5 x 11 paper. 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).
>
>Here's the catch: When printing certain student transcripts individually or as the first to print in a group of transcripts (i.e., that student's transcript is either the only one to print or should print first in the group), only one detail line is printed (the first course taken). Everything else on the transcript is handled appropriately. If there were other transcripts to print after this one, they don't appear. BUT if that same student's transcript is included in a print group where it will not be printed first, all detail lines are printed!
>
>I'm at a loss here. I've checked the temporary files to verify that the data is being collected appropriately. I've recreated the report from scratch to rule out report file corruption. And I've reinstalled VFP. I've searched Microsoft knowledgebase. I don't know where to go from here. Help!
>
>TIA,
>Nancy Price
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform