Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Page Footer - Last Page Only
Message
From
03/10/2005 05:10:31
 
 
To
03/10/2005 04:50:43
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
01055422
Message ID:
01055433
Views:
14
There is no need to run the report twice in VFP8 and 9. _pagetotal gives you the total number of pages for report (VFP8 runs the report twice for you :-).

I don't know how the report is organized. If you GROUPing the detail band by customer and want to print the totals at the end of the customer's records you can print them in Group footer band. if you want to print them in Page footer where the customer's records end you can do:
Put a variable in report named i.e. PrintCustomerTotal, initalise it to .f., Calculation = None, Reset AT Customer's change
In OnExit event of GroupFooter put: _VFP.SETVAR(PrintCustomerTotal,PrintCustomerTotal=.t.), then in Page footer make all PrintWhe to be PrintCustomerTotal.
(not tested at all)




>Hi Borislav,
>
>Thanks for the idea. Unfortunately, it does not quite work for me because I am printing statements for more than one customer at a time and the totals now print only on the last page of the last statement. But you have pointed me in the right direction. I think I have to do something similar to page x of xx, where I run the report twice. The first time to set page markers beginning with 1 for each customer. Then send the first report to a file and print the second run.
>
>Thanks,
>
>Ken
>
>>>Hi,
>>>
>>>How would one go about having items in a page footer print only on the last page? I am printing statements on a preprinted form and, in those cases where the detail items fill more than one page, I would like the page footer (totals and ageing data) to print on the last page only. Even better, on all pages but the last, I would like to print "continued". VFP8.
>>>
>>>Thanks,
>>>
>>>Ken
>>
>>Put _pageno == _pagetotal in Print When in all controls in the Footer, and _pageno # _pagetotal for label with "Continued...".
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Previous
Reply
Map
View

Click here to load this message in the networking platform