Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Reports not showing all records
Message
 
À
15/08/1998 15:04:12
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire de rapports & Rapports
Divers
Thread ID:
00127162
Message ID:
00127171
Vues:
25
Jonathan,
Are you printing from inside the preview? If so, there are some anomalies which do not seem to be consistent.

Also, during the preview your SELECTed table may switch from INVOICE to InvItem, which would cause the nRecNo to pick an incorrect record.

Try printing your report with:
SELECT INVOICE
go nRecNo
REPORT FORM Invoice NEXT 1 NOCONSOLE
You might find it simpler to do a cursor with SQL-Select or a View for just the records you want. Then you do not have to be concerned with linking tables or selecting specific records. If this is placed in the Report Init method, then it is re-run for preview and printing.

HTH
Barbara

>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?
Barbara Paltiel, Paltiel Inc.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform