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:
00709826
Views:
25
Thanks to all for your helpful replies. My report is now working! I used the approach described in the mskb article Sergey mentioned (REPORT FORM ...NEXT RECNO() <= nTotRecs, which is set to value of RECCOUNT()) because the data I'm working with isn't conducive to one denormalized cursor. I'm actually collecting data from about 10 tables to create this report, so I use one temp file with memo fields to collect most of it into one record per student. Then I create a second temp file to collect the detail for the "many" side. (A bit difficult to explain due to the complexity of the data!)

Anyway, I'm glad I finally posted my question so I could stop pounding my head!!

Nancy

>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform