Hi!

I have a list in my orders' layout and arised a design problem: I need Trailing Grand Totals at the bottom of the page but FM put it directly at the end of the list.

How can I define TGT to be always at the end of the page?

When list is long last page contains just 1-2 lines somtimes. And the grand totals seems like lines. Customers can't see the total amount and call me at phone...

Untitled.pdf

One problem you're facing is that the found set of records on which the subsummary is narrowed down to the single frontmost quotes itemlines.

You should exploit that the summary field for the quote total, also can be ushered in from a cartesian selfjoin relation away into the footer part of the layout in order to ignore the found set. However isn't the field refreshing accordingly to each of the inputs, unless an event trigger is instated on record commit.

The attached script would need a "Flush Cache to Disk" since Committing the record isn't enough.

Now for what it's worth, could a TGT perhaps not really be what you wish to convey when issuing a quote, but instead what the customer actually have purchased and and actually paid ... seems to me far more relevant ... a grand total for all issued quotes is a fluffy measure since some quotes might not even be used by the customer at all... I'm a little baffled by the lack of purpose and context. Reading your layout doesn't provide particular many clues as to what the real need is?

If you look at the attached template, are 3 event triggers working two are tied to fields, and the last is tied to as a "OnLayoutLoad"...

--sd

TGTing.zip