Getting to grips with calculations

rbuser

Since buying Reportbuilder a few years ago now I have never been able to get
to grips with calcs using variables. Just when I think I have the Idea it
bites me again and again.

I have read many times the FAQ section on calculations many times but am
still unable to resolve this simple question.

I have a report with a main form that contains just one sub report, this
subreport conatins an "Group header" a detail and a "Group footer" , each
detail contains a list of quotes to customers and we want to report only the
last quoted value, and then a summary of all the quoted values, as these
cant be obtained using a DBCalc we are having to use a Variable component.
If we let the detail sub report get the last value only then this works fine
and displays ok on screen, We then want the parent form to display the sum
of all the detail variables for the summary, what we cant suss out is what
setting the calcon and reset on should be set to.

Can any one help as the online help does not help us much.

Best regards
Colin C

digitalmetaphors

One question comes to mind. If you only want to display the last quoted
value then why do you need a subreport which traverses all the quoted
values?

To answer your question though: since you want to use the variable to sum to
the end of the report, then set reset on to ReportEnd. CalcOn should
probably be left on OnTraversal. These values tend to be the default. What
is the actualy problem you are having though? Are you not able to calculate
the correct sum?

--
Cheers,

Alexander Kramnik
Digital Metaphors