Calculating and Resetting Variables

rbuser

Iam trying to optomise a report.

i have

Group1
Group2
Group3
detailband if x then V1 is set
footer3 V2 (must sum V1)
Footer2 V3 (must sum V2)
Footer1 V4 (must sum V3)

I cant get the V3 , V4 only to calculate when footer3 and footer2 are
called respectively . The only way i can get them to calculate is if
everyones calc type is traversal and is set to:

value := value + V1.value

but this is very inificient

i want the oncalc of V3 to be fired when the footer2 is reached and
V3.value := V3.Value + V2.Value (and V2 value must not have been
reset yet)

similarly

i want oncalc of V4 to be fired when the footer2 is reached and
V4.value := V4.Value + V3.Value (and V3 value must not have been
reset yet)

what should the respective cacltype and CalcCompnents be, and their
resettype and reset compenents.

Thanks

Ian robinson

digitalmetaphors

You can use DBCalcs to calculate V2-V4 by setting their target to V1.

--
Cheers,

Alexander Kramnik
Digital Metaphors

rbuser

rbuser

It was answered the next morning with a post from Alexander Kramnik of DM.
I've pasted his answer below in case you can't find the original.


------------------------------------
Bruce Roberts
Roberts Browne Limited
RBAddOn Components for Report Builder
http://www.bancoems.com/rbaddon.htm

rbuser

>>>> You can use DBCalcs to calculate V2-V4 by setting their target to V1.

Sorry about my ignorance but

I dont see a property "target" in DBCalc or in Variables, also DBCalcs, only
allow for Datapipelines as source with datafield.

Am I missing something here?

regards

Ian

digitalmetaphors

The variables' values are reset after they print for a group. So, it is too
late to use their values in the next outer group footer band, if they reset
on GroupEnd. Try setting the reset timing of the variables to GroupStart.


Cheers,

Jim Bennett
Digital Metaphors

digitalmetaphors

I'm sorry for not being more clear, by target I meant the reset group. Right
click on the DBCalc and select Calculations. In the Reset Group dropdown
select group V1.

--
Cheers,

Alexander Kramnik
Digital Metaphors