Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Conditional printing
Message
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
00667045
Message ID:
00667904
Views:
32
Okay .. I think we need to start over <g>. Here's what I think you are saying. You have a table with a bunch of records .. let's say invoice headers for customers. Therefore, you could have the following:
Customer#   Invoice#   Description
---------   --------   -----------
ABC         100        Blah blah blah
ABC         104        alsdkjf alkjfda;
DEF         101        a;ldksf jaldfj
DEF         102        alkdj jlal;sdjf
XYZ         105        ljkad;flkasjd;fl
XYZ         107        a;lkdj f;alkjf
What you want to ensure on the report is that if Customer "ABC" starts near the bottom of the page and happens to have enough invoices to force it to overflow to the next page, you want to print "continued" at the bottom of the page.

So .. assuming I've diagnosed your situation correctly .. here's how to do this!

1. Create a data group on Customer#.
2. Create a report variable, nLines. Set it to count and tell it to reset at the end of the Customer# data group.
3. In the OnExit expression of the Group Footer band, enter this: _VFP.SetVar('nLines', 0)
4. Place the "continued" text in the Page Footer and change the Print When expression to "nLines > 0"

Hopefully .. I got it right this time <g>.

Cathy
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