General information
Category:
Reports & Report designer
>(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.
Add a report variable, Order_Total, and have it calculate the total of the extended line totals. That is, Initial Value = 0, Value to Store = qty_Select*Unit_Price, Calculate-Sum.
In the Group Footer, use:
Misc_Chg + Sales_Tax + Frt_Chg + Order_Total
with no calculation set.
Tamar
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only