>>How about this:
>>calculate the "page footer" variable prior to running the report (via SQL or whatever) and then use the calculated variable in the band.
>
>It is a different number for every invoice...

Create the variable for each invoice either by running a program snippet each time a new invoice band is entered or by creating a "lookup" table.