>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...
This is how it always was.
If you want to show totals beside those that come as result of detail records, they hv to be precalculated and shown as such.
Aldough UDFs and/or report variables might do the trick,
[not to even mention pubvars because they are bad, bad, bad! :) ]
- it is better to hv this fields ready in header record and just
show them as such.
Hence, header record of an invoice should hv them naturally.
If you are normalisation freak, and they are not already there,
then you can prepare tmp cursor which hv all (sub)totals you need to
show your report.
>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.
>