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

[Doug Hamilton]

There are two approaches that might help you: 1) Select the DBCalc and rightclick.  There's a ResetBreak option so you can choose which break it gets reset. 2) Ctrl-B lists all the break points and allows you to add, insert & delete breaks and select which vars to reset plus other options. Might those help? Doug Jim Belisle wrote: I have been following this thread with interest. I am interested to know if you can RESET the DBCalc that resides in a breakfooter? I have a compid (Comp_CountC) associated with my dbcalc count(Control#) and want to reset it based on each customer. Would I be better to use the old way of COUNT for break footers.   Jim     From: rbase-l@rbase.com [mailto:rbase-l@rbase.com] On Behalf Of karentel...@cs.com Sent: Friday, April 30, 2010 4:44 PM To: RBASE-L Mailing List 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).