who has programmed with the instruction totaling Variables (group by)

Hi Everyone,

ScriptCase’s manual in the section macros says:

During the break down process, Scriptcase generates total variables to each break level.
The routines are defined in event ?onGroupBy? determining the break levels. Totals
special variables are then referenced substituting the break name for the key word
?break?, as in:
Variable Description
{count_ger} Records total amount.
{sum_parcel} Field ?parcels? total .
{sum_balance} Field ?Balance? total .
{count_break} Current break level records total.
{sum_break_parcel} Current break level field ?parcels? total .
{sum_break_balance} Current break level field ?Balance? total .

Ex. 1: In an application with a break by state and city and that totalizes a balance
field, in the break totals, is possible to display the average (avg) instead of the
balance as follows.
{sum_break_balance} = {sum_break_balance} / {count_break};

this is in the scriptcas manula, the instruction “break” does not work in calculating subtotals in an operation such as in the areas and sub-totals, but if I work with the grand total.

specifically attached what I mean.


groupby.docx (66.9 KB)

Re: who has programmed with the instruction totaling Variables (group by)

Hello Marce,

Please contact our support regarding this issue. They will be able to run tests on your application and database to diagnose what might be wrong. Our chat is active on workdays from 8:00am to 6:00pm (GMT -3), and our ticket system is always available.

Bernhard Bernsmann

Hi there,

Can you share the solution ?


Podrian compartir la solución