Totalling on browse

[kristofv]

Dear,

1. My browse is over different pages.  How can I give the overall total in every page?

2. We are using the search function.  By changing a row it is switching to this field.  To avoid this I changed the Edit-> refresh whole browse.  Now the browse is going to the next row by using 'tab' or the arrow-keys.
This is working but now the totalling is not refreshed untill I refresh or change the webpage.  How can I make the totalling working?

Thanks,
Kristof Vanderhaeghen
Jumbo Computers
Belgium

[Bruce]

Hi Kristof,

>> 1. My browse is over different pages.  How can I give the overall total in every page?

at this stage it's not supported directly. One option is to make the browse "file loaded". I do this when there will be a reasonable number of rows - for example for the line items in an invoice.

another option is to create your own function for calculating the total (of the whole result set) and then use this function to present the total, (ie "custom" totaling).

I'll have a longer answer for your (2) later today.

cheers
Bruce

[Bruce]

<< How can I make the totaling working?

You're stuck in a catch 22 here, and I'm not sure of the way out.
If you refresh the whole browse you lose the focus, which is understandable.
However if you don't refresh the whole browse, then it's not gonna re-calculate the totals anyway.
(sending the totals is not so hard, but you'd need to re-calc them.)

the first solution is if I convince it to restore the focus (if possible) to the field that had it when the browse was refreshed. (this I've done in build 6.36).

The second part of the equation is to make it possible to call the "totals" routine while in EIP mode. In other words it is now possible to "change" the browse total cells during the whole EIP process. There is however, a catch.

The catch is that the old values in the browse totals are not available at this point, and indeed the correct values are not calculated at this point. so in order for this to be useful you _must_ calculate the correct browse totals yourself, from scratch. This however (at the moment) needs to be done anyway if you want "file loaded totals" on a "page loaded browse" so may be of use to some.

cheers
Bruce