Browse Total will reset if got few pages, any new solutions?

[skyong38]

Hi,

I embeded the following code at Set Queue Record :-
        CASE T:DrCr
        OF 'D'
            LocDrAmt = T:Amount
            LocBalance += T:Amount
        OF 'C'
            LocCrAmt = T:Amount
            LocBalance -= T:Amount
        END
The LocBalance will reset every new page.

I search thru previous post on June 25, 2012, it can be solved by using File Load, but it will be very slow when records huge.

Just wonder, any new solution for this after so many years?

Thank you.

Regards,
Nelson

[Robert Iliuta]

Hallo Nelson,

Just an idea, did you try to play with sessions?

CASE T:DrCr
        OF 'D'
            LocDrAmt = T:Amount
            LocBalance += T:Amount
            p_web.SSV('sv-LocBalance',LocBalance + p_web.GSV('sv-LocBalance'))
            LocBalance = p_web.GSV('sv-LocBalance')
        OF 'C'
            LocCrAmt = T:Amount
            LocBalance -= T:Amount
            p_web.SSV('sv-LocBalance',p_web.GSV('sv-LocBalance') - LocBalance)
            LocBalance = p_web.GSV('sv-LocBalance')
END

You need to reset the session variable when you open the form/browse.
I did not test but maybe will work/help you.

Robert

[Bruce]

Hello Nelson,

What backend are you using? If SQL you could make a custom SQL statement to get the total.
If TPS you have to read all the records to calc the total, which as you noted could be slow.

cheers
Bruce

[skyong38]

Hi Robert,
 
Thanks for advice. Tried, doesn't works.


Hi Bruce,

I am using SQL, I will try on method you suggested.

Thank you.

Nelson

[DonRidley]

Hello Nelson,

I'm also working with totals.  I'm doing some work with running balances as well.

The only thing I have found so far that consistently works, with decent speed, is using Views with very focused filters and keys.

I create my own local procedures, call the procedure, and get a return value.

I can honestly say, and you'll probably agree, totals and running balances are a pain the....well you know. 

Don