You coulda put some lipstick on it before you posted it... ;-)
----- Original Message -----
From: <[email protected]>
To: "RBASE-L Mailing List" <[email protected]>
Sent: Friday, April 30, 2010 5:44 PM
Subject: [RBASE-L] - Re: Using SUM OF in two page report
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).
