Aggregation of Variable values...

rbuser

Hi,
In my detail section I have several usual fields and several Variables that
are calculated using other database fields. Each of the variables requires
10-15 fields to calculate. I need to show summary in the end of the report
for each detail field.
For usual fields I can just use DBCalc component that takes care of
everything. But how do I use aggregate functions for my variable
componenets? Isn't there a simple way?
I know that I can just aggregate each of the field I use in the variables
calculations and then I need to make the same calculations in the summary
with the aggregated values for each variables. But having to aggregate like
30-40 fields for just 3 Variables is going way overboard. Especially
considering 4-5 groups that must show subtotal values. (Meaning that
aggregate fileds amount must be multiplied by the 4-5).

Thanks,
MB.

P.S.: I'm very grateful to Jim Bennet for the detailed replies on the last 2
questions. Thank you very much ^_^.

digitalmetaphors

Once you calculate the 3 variable values in the detail, use another 3
variables in the detail to store the running totals. Use the
Variable.CalcOrder to ensure that the first three variables calculate before
the 3 total variables. This way they can reference the first 3 variables
values to calculate their running totals. Make these total variables
invisible. Then when the summary goes to print, you can perform other
calculations using visible variables in the summary which reference the
values stored in the running total variables. That should be easier than
trying to aggregate 30-40 fields in the summary.


Cheers,

Jim Bennett
Digital Metaphors

rbuser

Thank you, it is really much easier to do it this way.