Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Set Skip problem
Message
 
To
29/03/2006 14:12:41
Bruce Gilmour
Cal-Mour Consultants
Calgary, Alberta, Canada
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01108916
Message ID:
01108966
Views:
25
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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform