Help me out with GetSummary

[uemtux]

Hi Everyone,

I've got a pretty standard setup of an order table and an orderlineitems table. I'm doing a print report which shows each order and the associated line items by finding a set of these line items, sorting by the orderid field, and then putting certain fields from the order (like order total, and customer name) into the subsummary.

The order total is basically the dollar amounts of the line items added up plus taxes, shipping, and other fees. How can I do a grand summary of Order::Total when my report layout table is OrderLineItems ?

I tried a calculation in the order lineitems table: GetSummary(Order::SumTotal ; OrderLineItems::OrderID)

SumTotal is a Summary of Order::Total. But this doesn't appear to work!

Can anyone educate me?

Thanks!

[comment]

What exactly do you mean by "grand summary of Order::Total"?

[uemtux]

The report layout is an OrderLineItems table layout. I sort the OrderLineItems by OrderID which shows a leading-subsummary where I put fields from the ORDER table. One of the fields in the Order table is "Total" this field is a calculation that adds taxes and other fees to the total of the dollar amounts of the line items. What I want to do is have a total of Order::Total at the top of the report layout, either in a "Leading Grand Summary" layout part or in the header layout part.

[comment]

See if this helps:

http://fmforums.com/forum/topic/76482-sub-summary-problem/page__view__findpost__p__360007