Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Set Skip problem
Message
 
À
29/03/2006 14:12:41
Bruce Gilmour
Cal-Mour Consultants
Calgary, Alberta, Canada
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire de rapports & Rapports
Versions des environnements
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Database:
Visual FoxPro
Divers
Thread ID:
01108916
Message ID:
01108966
Vues:
24
You don't need the SET SKIP statement. The SET RELATION To is all you need.

Cathy


>Futher to the problem, I wanted to eliminate the detail bands as a source of the problem. I created two reports bothe having identical layouts as far as groups and header fields and the same total band in the group footer (although in the second report it totals the class totals). Then I ran them twice - the first time I set it up like this:-
>
>
>SELECT invoicehdr
>
>SET RELATION TO invkey_pk INTO invoicelines, ;
>                invkey_pk INTO invoiceclass ADDITIVE
>
>SET SKIP TO invoicelines, invoiceclass
>
>REPORT FORM linesreport PREVIEW
>
>WAIT WINDOW "quick pause"
>
>REPORT FORM classreport PREVIEW
>
>
>This printed the extra lines on the second report the same as in the second detail band. I then made a quick change as follows:-
>
>
>SET SKIP TO invoicelines
>
>REPORT FORM linesreport PREVIEW
>
>WAIT WINDOW "quick pause"
>
>SET SKIP TO invoiceclass
>
>REPORT FORM classreport PREVIEW
>
>
>and this time the second report did NOT have any extra lines.
>
>I still feel like I am missing something cause this couldn't be a bug in SKIP TO that has been hanging around all this time could it?
Cathy Pountney, Microsoft Visual FoxPro MVP
Memorial Business Systems, Inc. (www.mbs-intl.com)

My Website: (www.frontier2000.com)
My Blog: (www.cathypountney.blogspot.com)
My Book: The Visual FoxPro Report Writer - Pushing it to the Limit and Beyond
Free MSDN Article: What's New in the VFP 9.0 Report Writer
Free MSDN Article: The VFP 9.0 Report Writer In Action
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform