General information
Category:
Reports & Report designer
So simple, and yet so elusive. :) I SWEAR I had it this way somewhere along the way. In fact, I think this is what I did initially. But after following what you said to the letter, all is well.
Thanks very much to all who helped!
>>(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
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