In my report, there is a normal invoice....

The outlook will be:

Inv_no: XXX Inv_date: MMM DD, YYYY.
Cust_name: XXX
Item Descript UnitPrice Qty RowTotal
-----------------------------------------------------
ABC .........
....
-----------------------------------------------------
SumTotal: [RowTotal] && with Sum Option
[99]% off: [CalValue]
Additional Charge: [Charges] && Orders.Charges
------------------------------
Grand Total: [???? ] && <= How to do!?


I can't make it partial sum and partial not!!
It already worth 1-2 min. to generate this report for LOCAL VIEW...
if I need to make an additional SQL to get that result and save to Public Variable... the time will be double... ~>_<~

I also can't put the Additional Charge As a Item in Orditems because it will be above the SumTotal Line and will also get in Discounted sum...

Besides this, since U.S. need to calculate tax base on Face Price of
per Item.

The Invoice report will take each discounted Unit Price to show and
there will NOT give the [99]% Off:... Line....
So, in order to make both report final value equal.
I take the view report in Invoice part and put to Above Sales Orders
Grand Total Field... (last one) and then back calculate the [calValue]
But subtract Total before discount and final discounted total!!

Now... I really donno how to handle it... My boss claim none of report
will be void! ~~>_<~~