Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Reports not showing all records
Message
From
17/08/1998 08:47:30
 
 
To
15/08/1998 15:04:12
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
00127162
Message ID:
00127350
Views:
29
>I'm having a problem with reports in VFP5 sp3 - These reports are invoices or order drafts, etc..
>
>When I'm in preview mode everything works fine - The invoice number is there, the customer is there, and all items in the invoice appear But, when I want to print the report, only the first item in the invoice appears in the preview..
>
>Here's the command I use for printing:
>
>
REPORT FORM Invoice RECORD nRecNo NOCONSOLE PREVIEW
>
>where nRecNo = RecNo() (The invoice number)
>
>My data environment has Invoice (the main header file), linked (one to many) to InvItem (all the items in the invoice) na customer table, and inventory.. Initial Selected Alias is Invoice
>
>This problem effects all reports similar to this (arrival reports, orde drafts, etc..)
>
>I am not too familiar with Visual FoxPro.. Am I missing something?


The same problem existed with previous versions of FP, and it has to do with the SET SKIP TO sentence. The only cure I found was resetting the environment before printing, for example, with a GOTO TOP or (in your case) GOTO (nRECNO). It seems to me like FP "forgets" to reset its relations to the first record when there are SET SKIPs involved.

HTH!
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform