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:
00667999
Views:
24
>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,
Thanks, it works like a charm. You're the best!
Winn Pauley
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform