Doug:  Here's what I have in a report in my consulting business.  I'm
totalling up my travel expenses.  One total is adding together the total
for tolls and the total for train fare.   The control where you want to 
show
your calculated total must be a regular Label object (at least that's what
I've found).

1.    I have 2 DBCalcs in my report footer.   The componentids of them are
SumTolls and SumTrain.

2.    I have a regular Label object located in the report footer, with a 
compid
of TotalOther.

3.    In the "on before generate eep" of the report footer band, I have 
this code.
I know I did a no-no and changed the datatype in the middle of it, so you 
probably
don't want to do that ...

SET VAR vtolls TEXT, vtrain TEXT

GETPROPERTY sumTolls VALUE vTolls
GETPROPERTY sumTrain VALUE vTrain

SET VAR vtolls DOUBLE, vtrain DOUBLE
SET VAR vsum = (.vtolls + .vtrain)

PROPERTY TotalOther CAPTION .vsum

RETURN


Karen

 
> OK, I spoke too soon.  I'm still not able to use Report Footer totals in 
> Break point calculations
> I'm using DBCalcs for summing and have no expressions defined; per 
> Razzak's suggestions, I've predefined all variables and set them to null.
> Using the SubTotalsAndTotals report as an example, how would I set up 
> that report to use the Grand Total to, let's say, calculate each 
> customer's Sub-Total as a percentage of the Grand Total? 
> Is there an example in RRYB14 of using a report footer total in break 
> point calculations?  (I think I went through all the reports and didn't 
> find one but I could easily have missed it).
> 

Reply via email to