[RBASE-L] - Re: Using SUM OF in two page report

[Doug Hamilton]

Thanks Karen. What I'm trying to do is use the DBCalc totals from the footer in Break Point calculations above. Jan gave me some ideas that I'm working on. Doug karentel...@cs.com wrote: 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).