Can't get total to work

[Tracy]

I have a report that is sorted by Customer. In the detail
of the report I have work order cost information. I also
have a sub report that brings in invoice information.

At the detail level I perform a calculation that looks
like this, I have named this text box Real1. This
calculation tells me how much money we made/lost on each
work order.
=IIf([tah_invoice_for_real].[Report]![Orig_invoice_Amt] Is
Null,0,[tah_invoice_for_real].[Report]![Orig_Invoice_Amt]-
[job_total])

In the Customer footer, I am trying to take the total for
all the jobs the customer has and perform the same
calculation at the footer level. I have tried using =sum
([Real1]), but when I run the report, I then get asked for
the parameter of Real1.

Any ideas?

 

[Fons Ponsioen]

If you had created the real1 variable in the undrerlying
query it would havve worked.
if in the reoport footer you now make the source Sum(=IIf
([tah_invoice_for_real].[Report]![Orig_invoice_Amt] Is
Null,0,[tah_invoice_for_real].[Report]![Orig_Invoice_Amt]-
[job_total]))
You'll get what you want.
FOns