In the form is right becuase you directly display the value. How you calculate Tot in Report? What is Formula? I suspect something like:
(qty_select*unit_price+misc_chg+sales_tax+frt_chg)
Am I right?
If so this formula is evaluated at each record and you will have frt_chg*RecCount() (and other fields if the logic for them is the same)



>frt_chg is a field from the cursor. Each line of the cursor contains this field, and the value is the same in each line (in this example, $100).
>
>The value is appearing correctly on the form (showing $100), but when I calculate my grand totals, it's adding once for each detail line.
>
>
>>frt_chg? What is it? A field from your cursor or report variable? If this is a field from your cursor what is the value in it for each record? If it is the total value for the group that just porint the value, do not put any calculations on it.
>>(I suspect that you have 100 in frt_chg in both records, that's why you get 600 as Grand total)
>>
>>>Hi all,
>>>
>>>If I had any hair, I'd be pulling it out over this one.
>>>
>>>On my Invoice form, I have the following fields:
>>>
>>>(in the Detail band)
>>>qty_select unit_price qty_select*unit_price (for the extended line total)
>>>
>>>In the Group Footer band, I have the extended line total summed. It's perfectly fine. I also have three other fields there:
>>>
>>>misc_chg
>>>sales_tax
>>>frt_chg
>>>
>>>And a fourth field that adds those three fields to the subtotal for a grand invoice total.
>>>
>>>The problem: it doesn't just add the above three fields one time. It adds them one time for each line of detail on the invoice. For example, for an invoice with two detail lines, I get this:
>>>
>>>Sub : $400
>>>Misc: 0
>>>Tax : 0
>>>Frt : 100
>>>Tot : $600
>>>
>>>If I display the misc_chg, sales_tax and frt_chg fields on the form for testing purposes, they're correct (just $100 for frt). But why is it adding those lines once for each line of detail, even though it's displaying correctly on the form? I want to add my subtotal, then each of the other three displayed items (misc, tax, frt) to get my grand total.
>>>
>>>This oughta be simple. In fact, it probably is. But I'm just not seeing it.
>>>
>>>Thanks!
>>>
>>>John