>Give this a try and see if it solves your problem:
>
>1. Create a report variable called rnTotal, set the calculation to SUM, and reset it at the Data Group on Invoice Number.
>
>2. Create a report variable called rlPrintTotal, set it to .f.
>
>3. In the OnExit Expression of the Data Group Footer, use the following expression: _VFP.SetVar(rlPrintTotal, .t.)
>
>4. In the Page Footer, use rnTotal for printing the Total. Set the Print When logic to: rlPrintTotal
>
>
>I hope this helps,
>Cathy
I've kind of already tried that approach by calling a function to
SCATTER NAME goRpt.oData
in the Group Footer OnEntry function (goRpt is my custom report object). I store the invoice header data already in the cursor, so then in the Page Footer, I just used the goRpt.oData.TaxableSls + goRpt.oData.NonTxblSls + .oData.Freight, etc.
This solves the problem for the first invoice (which is a hack to cover the RW skipping on me), but then the second invoice (third printed page) never processes the Page Footer band objects (see the LOG.TXT output). So, Page 3 will always show the Page 2 output no matter what I put in the Page Footer band.
Scott McDaniel
MCP VFP Desktop